1. In a relational database, a unique identifier is known as a: a. primary key b. foreign key c. DBMS d. data e. composite key 2. How does a DBMS (Database Management System) typically manage a database? a. By providing the means for creating, maintaining and using databases. b. By storing different types of information including text, numbers, documents, images and videos. c. By evaluating business intelligence for managers. d. By manipulating data such as reducing inventory when a product is ordered. e. By hiring a DBA to oversee the data in the system. 3. For large and complex amounts of information, storing the information is best achieved by using what? a. A spreadsheet b. A database C. A file d. A document e. A smartphone app 4. Netflix has countless copies of the newest movies released, as well as countless members that are willing to rent the newest movie. What type of relationship would this example mostly likely a. One to one b. One to many c. One to two d. Many to many e. Recursive 5. Your technology firm has been contacted by a local accounting firm about designing a database to organize clients and workload. The managing partner of the Accounting firm has described the way that the firm handles business and you have decided that the best method to begin your work is to create a diagram called a. an entity relationship diagram b. a decision flow char c. a gantt chart d. database architecture e. an entire relationship diagram 6. Why is the entity relationship diagram (ERD) or database schema necessary, even if you never design or build a database? a. To understand the structure of the database b. To identify tables c. To understand rows d. To define fields e. To communicate data fields to end users 7. A table in a database contains information about Employees. The DeptNum repeats itself multiple times in this table but links each employee to another table that contains the information about that particular department. What is DeptNum known as? a. Primary key b. Foreign key c. DBMS d. Relationship e. Composite primary key 8. In a relational database, the link between two tables by a primary key and a foreign key is known as what? a. A partnership b. A connection c. A reference d. A relationship e. A composite primary key