menu
Sign up

Normalizing Table Enrollment to 3nf Will Result In

Question 16
Multiple Choice

Normalizing table ENROLLMENT to 3NF will result in: A)No changes (table ENROLLMENT remains as is,no additional tables) B)Two separate tables C)Three separate tables D)Four separate tables

Related questions
Q 17
Which of the following (regarding the relation FLIGHT)represents the insertion anomaly? A)Inability to insert a flight without its occurrence B)Inability to insert an origin without a destination C)Inability to insert a destination without an origin D)Inability to insert a number of passengers without a flight ID and date
Q 18
Which of the following functional dependencies does not exist in the table FLIGHT? A)FlightID --> NoOfPassengers B)FlightID --> Origin C)FlightID --> Destination D)FlightID,Date --> NoOfPassengers
Q 19
Which of the following functional dependencies in the table FLIGHT is an augmented functional dependency? A)FlightID,Date --> NoOfPassengers B)FlightID --> Origin C)FlightID --> Destination D)FlightID,Date --> Origin
logo
© 2020-2021 Cozyplus FZ LLC. All rights reserved