Exam 4: Update Operations, update Anomalies, and Normalization

ENROLLMENT Observe the table ENROLLMENT: ENROLLMENT StudentID StidentName ClasslD CassName 111 Joe El Enghishl 222 Bob E1 Enghishl 333 Lisa H1 Historyl -Which of the following (regarding the relation ENROLLMENT)represents the insertion anomaly?

ENROLLMENT Observe the table ENROLLMENT: ENROLLMENT StudentID StidentName ClasslD CassName 111 Joe El Enghishl 222 Bob E1 Enghishl 333 Lisa H1 Historyl -Which of the following is in danger of being affected by the deletion anomaly in the table ENROLLMENT?

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Functional dependency Make --> VehicleID exists in the table VEHICLE.

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Functional dependency VehicleID --> Make exists in the table VEHICLE.

If A --> B is an existing functional dependency,which of the following is an augmented functional dependency?

ENROLLMENT Observe the table ENROLLMENT: ENROLLMENT StudentID StidentName ClasslD CassName 111 Joe El Enghishl 222 Bob E1 Enghishl 333 Lisa H1 Historyl -Which of the following actions in the table ENROLLMENT will be affected by a modification anomaly?

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Table VEHICLE is in 1NF

What type of functional dependency does NOT exist in the table FLIGHT?

Normalizing table ENROLLMENT to 3NF will result in:

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Functional dependency VehicleID --> Type exists in the table VEHICLE.

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Functional dependency OwnerID --> Type exists in the table VEHICLE.

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Functional dependency Make --> OwnerID exists in the table VEHICLE.

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Attempting to insert a new owner O4,Matt in the table VEHICLE will cause an occurrence of an insertion anomaly.

DOCTOR Observe the table DOCTOR: DOCTOR DoctorID Name Date OfMDGraduation NumberOfPatients D111 John 1/1/1999 100 D222 Tina 1/2/2003 117 D333 Ellen 1/1/2001 117 D444 Tina 1/1/2003 144 This table will be used for the following questions citing table DOCTOR. -Normalizing table DOCTOR to 3NF will result in:

What is necessary redundancy in a relational database?

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Normalizing table VEHICLE to 3NF will result in two separate tables.

ENROLLMENT Observe the table ENROLLMENT: ENROLLMENT StudentID StidentName ClasslD CassName 111 Joe El Enghishl 222 Bob E1 Enghishl 333 Lisa H1 Historyl -What type of functional dependency does NOT exist in the table ENROLLMENT?

Normalizing table FLIGHT to 3NF will result in:

Which of the following functional dependencies in the table FLIGHT is an augmented functional dependency?

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Thuck Honda O3 Pan 444 Car Honda O1 Pan -Full key functional dependency exists in the table VEHICLE.