Question: 8. A(n) exists when there are functional dependencies such that Y is functionally dependent on X,Z is functionally dependent on Y, and X is the

8. A(n) exists when there are functional dependencies such that Y is functionally dependent on X,Z is functionally dependent on Y, and X is the primary key. a. partial dependency b. repeating group c. atomic attribute d. transitive dependency 9. When relating SEMESTER and COURSE to an associative entity such aS CLASS where a SEMESTER Can have many CLASSES and a COURSE can have many CLASSES, then COURSE would have what type of relationship to CLASS? a. one to many b. one to one c. many to one d. many to many 10. In the early development stage, if a company suggests entities CUSTOMER and MAINTENANCE to a database designer to build a database that will track car repairs, what other entities would a designer want to add to improve the overall design based on operational needs? a. CAR and PART b. ADDRESS and CAR c. FNAME and LNAME d. MAKE and MODEL 11. The main goal of normalization is to eliminate a. dependencies b. data anomalies c. repeating group d. nonkey attributes 12. Attribute A attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B. a. determines b. derives from c. controls d. owns
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
