QUESTION 16 Observe the table STUDENT: STUDENT StudentID D111 D222 D333 D444 D555 SSN 111-11-1111 222-22-2222 333-33-3333 444-44-4444 555-55-5555 Name Connor Trevor Connor Parker Connor Class Freshman Freshman Sophomore Sophomore Sophomore Functional dependency Class -- --> Name exists in the table STUDENT. True False ENROLLMENT Student StudentName Majorld MajorName 111 Joe E English 222 Bob H History 333 Lisa H History which of the following actions in the table ENROLLMENT will be affected by a modification anomaly (with its current 3 records)? O Changing the name of Joe to Joseph O Changing the name of English to English Literature O Changing the name of Lisa to Lizzy Changing the name of Bob to Robert None of the above Observe the table VEHICLE that contains the following four records: VEHICLE VehicleID Type 111 Car 222 Car 333 Truck 444 Car Make OwnerID Ford 01 Ford 02 Honda 03 Honda 01 OwnerName Pam Pat Pam Pam Deleting the following record in the table VEHICLE: 111, Car, Ford 01. Pam while leaving the remaining three records in the table, will cause an occurrence of a deletion anomaly. True O False Observe the table VEHICLE that contains the following four records: VEHICLE VehicleID Type 111 Car 222 Car Truck 444 Car Make OwnerID Ford 01 Ford 02 Honda 03 Honda 01 OwnerName Pam Pat Pam Pam 333 Attempting to insert a new owner 04, Matt in the table VEHICLE will cause an occurrence of an insertion anomaly. O True O False Observe the table VEHICLE that contains the following four records: VEHICLE VehicleID Type 111 Car 222 Car 333 Truck 444 Car Make OwnerID Ford 01 Ford 02 Honda 03 Honda 01 OwnerName Pam Pat Pam Pam Attempting to insert a new vehicle 555, Van, Honda in the table VEHICLE will cause an occurrence of an insertion anomaly. True False Observe the table VEHICLE that contains the following four records: VEHICLE VehicleID Type Car 222 Car 333 Truck 444 Car 111 Make OwnerID Ford 01 Ford 02 Honda 03 Honda 01 OwnerName Pam Pat Pam Pam Functional dependency OwnerID --> Owner Name exists in the table VEHICLE. O True False