MSIS 2103 Ch 4-6 Fletcher Exam
correctly answered to pass
A relational database cannot have a many-to-many relationship between entities. - correct
answer ✔✔True
A relational database can have a many-to-many relationship between entities. - correct answer
✔✔False
A ___________ shows the relationship between the tables in a relational database. - correct
answer ✔✔entity relationship diagram
Because a properly designed relational database only has single data entry, variables that can be
calculated are not in the database. - correct answer ✔✔True
Because a properly designed relational database only has single data entry, it is common to put
calculated variables in the database. - correct answer ✔✔False
Every table has a primary key. When the primary key of one table is in another table it is called a
________ key. - correct answer ✔✔foreign
Metadata defines the _________. - correct answer ✔✔Format of the data fields, required data
fields, database business rules, number of characters in a text field.
The DBMS is used to create database business rules. - correct answer ✔✔True
Database Management System (DBMS) - correct answer ✔✔-creates databases
, -defines field formatting
-defines database business rules
-modifies the database structure
-usually only accessed by an admin
Structured Query Language (SQL) - correct answer ✔✔Lets you get information out of a
database
Visualizations - correct answer ✔✔Graphs, charts, maps, and any other visual views of the data
Enterprise Systems - correct answer ✔✔-used by most businesses
-single database and all applications access that database
-eliminates duplication
-allows each part of the business to see the same data
Enterprise Resource Planning (ERP) - correct answer ✔✔-used by businesses that manufacture
products
-i.e. SAP and Oracle
-most ERP systems include a CRM application
-may have an SCM application
Customer Relationship Management (CRM) - correct answer ✔✔-used by services and sales
companies
-i.e. Salesforce and Microsoft Dynamics
-may have an SCM application
correctly answered to pass
A relational database cannot have a many-to-many relationship between entities. - correct
answer ✔✔True
A relational database can have a many-to-many relationship between entities. - correct answer
✔✔False
A ___________ shows the relationship between the tables in a relational database. - correct
answer ✔✔entity relationship diagram
Because a properly designed relational database only has single data entry, variables that can be
calculated are not in the database. - correct answer ✔✔True
Because a properly designed relational database only has single data entry, it is common to put
calculated variables in the database. - correct answer ✔✔False
Every table has a primary key. When the primary key of one table is in another table it is called a
________ key. - correct answer ✔✔foreign
Metadata defines the _________. - correct answer ✔✔Format of the data fields, required data
fields, database business rules, number of characters in a text field.
The DBMS is used to create database business rules. - correct answer ✔✔True
Database Management System (DBMS) - correct answer ✔✔-creates databases
, -defines field formatting
-defines database business rules
-modifies the database structure
-usually only accessed by an admin
Structured Query Language (SQL) - correct answer ✔✔Lets you get information out of a
database
Visualizations - correct answer ✔✔Graphs, charts, maps, and any other visual views of the data
Enterprise Systems - correct answer ✔✔-used by most businesses
-single database and all applications access that database
-eliminates duplication
-allows each part of the business to see the same data
Enterprise Resource Planning (ERP) - correct answer ✔✔-used by businesses that manufacture
products
-i.e. SAP and Oracle
-most ERP systems include a CRM application
-may have an SCM application
Customer Relationship Management (CRM) - correct answer ✔✔-used by services and sales
companies
-i.e. Salesforce and Microsoft Dynamics
-may have an SCM application
