PART A: MULTIPLE CHOICE QUESTIONS. CIRCLE the correct choice 1. Which of the following can be found in an ERD? a. Tables and Instances. b. Entities and Instances c. Tables and Attributes d. Entities and Attributes. 2. When designing a database for a car shop, the CAR entity was first conceptualized with a few basic, common characteristics for a car like, model, make, and color. However, a car does not only have one color. If a database designer splits the COLOR attribute in a Crow's Foot model, why would this be preferred over keeping it as is? a. The table cannot recognize multiple entities b. The table cannat recognize multiple primary keys c. The table cannot recognize multiple foreign keys d. The table cannot recognize multivalued attributes. 3. If CUSTOMER and INVOICE is classified as a 1 :M and one direction would specify that a CUSTOMER may generate many INVOIC.Es, what would be true of the opposite direction? a. CUSTOMER is unique to many INVOICES b. Each INVOICE is generated by one CUSTOMER c. Each INVOICE is written to many CUSTOMERs d. CUSTOMERs are given INVOICEs 4. When a database designer determines that two entities share the same primary keys in their relationship, what can the designer infer between the two? a. Weak relationship b. strong relationship c. optional relationship d. Unary relationship 5. When creating a strong relatianship between COURSE and CLASS, which af the follawing would be true about the CLASS object? a. It has a primary key that is also the primary key of COURSE b. It has a foreign key that is also primary key of COURSE c. It has two primary keys that is also foreign keys of COURSE d. It has two foreign keys in which one is a primary key of COURSE 6. In an ERD that sayS DOCTOR writes PRESCRIPIION, a PAIIENI receives a PRESCRIPIION, and a DRUG appears in a PRESCRIPTION, it is mostly portraying what type of relationship degree? a. unary b. binary c. ternary d. recursive 7. If a college with a department called Research must also offer courses to its students, just like all other departments that offer courses, then what type of relationship would a COURSE have to a DEPARTMENT in an entity relationship diagram (ERD)? a. optional b. primary c. strong d. mandatory