Exam 4: Update Operations, update Anomalies, and Normalization

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 -Changing the name of owner O2,Pat to Patrick in the table VEHICLE will cause an occurrence of a modification 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 (regarding the relation ENROLLMENT)represents the modification anomaly?

STUDENT Observe the table STUDENT: STUDENT StudentID SSN Nane Class D111 111-11-1111 Connor Freshman D222 222-22-2121 Trevor Freshman D333 333-33-3333 Connor Sophomore D444 444-444444 Parker Sophomore D555 555-55-5555 Connor Sophomore -Table STUDENT is in 1NF.

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 OwnerName --> Make exists in the table VEHICLE.

STUDENT Observe the table STUDENT: STUDENT StudentID SSN Nane Class D111 111-11-1111 Connor Freshman D222 222-22-2121 Trevor Freshman D333 333-33-3333 Connor Sophomore D444 444-444444 Parker Sophomore D555 555-55-5555 Connor Sophomore -Table STUDENT is in 3NF.

Briefly describe the process of normalization.In your description,list the three most fundamental normal forms,but do not go into detail about any particular normal form.

Which of the following is a modify operation?

Table FLIGHT is:

Every relation contains:

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 -Deleting the following record in the table VEHICLE: 222,Car,Ford,O2,Pat while leaving the remaining three records in the table,will cause an occurrence of a deletion anomaly.

Give a definition of 1NF.

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 -Changing the name of owner O3,Pam to Pamela in the table VEHICLE will cause an occurrence of a modification anomaly.

Every relation without partial functional dependencies is in 3NF.

If A,B,C,and D are columns of the table whose composite primary key is A,B while C and D are nonkey columns then B --> D is a transitive 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 -Changing the type and name of vehicle 444 in the table VEHICLE will cause an occurrence of 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 3NF

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. -What type of functional dependency exists in the table DOCTOR?

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 --> OwnerName exists in the table VEHICLE.

Which of the following functional dependencies does not exist in the table FLIGHT?

Every normalized database is eventually denormalized.