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 -Functional dependency Type --> OwnerName 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 Type --> VehicleID exists in the table VEHICLE.

Every relation is in 1NF.

Table ENROLLMENT is:

An insertion anomaly occurs when a user who wants to insert data about one real world entity is forced to enter a unique value about it.

When does a transitive key functional dependency occur?

Give a definition of 2NF.

Every relation without transitive functional dependencies is in 3NF.

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 --> 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 -Trivial functional dependency 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 --> Make 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 Type --> Make 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 -Changing the name of owner O1,Pam to Pamela in the table VEHICLE will cause an occurrence of a 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 -Augmented functional dependency exists in the table STUDENT.

A nonkey column is a column in a relation that is not a primary or a candidate key column.

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 -Full key functional dependency exists in the table STUDENT.

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 --> C is a partial 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 -Functional dependency OwnerName --> Type exists in the table VEHICLE.

In what two different ways is the term update operation often used?

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 -Functional dependency SSN --> Name exists in the table STUDENT.