Deck 4: Update Operations, update Anomalies, and Normalization

Question 1

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c } \text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \\111 & \text { Joe } & \text { El } & \text { Enghishl } \\222 & \text { Bob } & E 1 & \text { Enghishl } \\333 & \text { Lisa } & \text { H1 } & \text { Historyl }\end{array}$$

-Which of the following actions in the table ENROLLMENT will be affected by a modification anomaly?

A)Changing the name of Joe to Joseph
B)Changing the name of English1 to English101
C)Changing the name of History1 to History101
D)Changing the name of Bob to Robert

Answer 1

Changing the name of English1 to English101

Question 2

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

Answer 2

D

Question 3

Which of the following is a read operation?

A)Entering new data in the relation
B)Retrieving data from the relation
C)Removing data from the relation
D)Changing the existing data in the relation

Answer 3

B

Question 4

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c } \text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \\111 & \text { Joe } & \text { El } & \text { Enghishl } \\222 & \text { Bob } & E 1 & \text { Enghishl } \\333 & \text { Lisa } & \text { H1 } & \text { Historyl }\end{array}$$

-Which of the following functional dependencies does NOT exist in the table ENROLLMENT?

A)StudentID --> StudentName
B)StudentName --> StudentID
C)StudentID --> ClassID
D)ClassID --> ClassName

Question 5

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c } \text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \\111 & \text { Joe } & \text { El } & \text { Enghishl } \\222 & \text { Bob } & E 1 & \text { Enghishl } \\333 & \text { Lisa } & \text { H1 } & \text { Historyl }\end{array}$$

-Which of the following (regarding the relation ENROLLMENT)represents the insertion anomaly?

A)Inability to insert a student without adding a class
B)Inability to insert a class without adding a student
C)Inability to insert a class name without a class ID
D)Inability to insert a student name without a student ID

Question 6

If A --> B and B --> A are existing functional dependencies,which of the following are NOT equivalent functional dependencies?

A)A --> B and B --> A
B)A --> B,X and B --> A,X
C)X --> A and A --> B
D)X,A --> B,X and X,B --> A,X

Question 7

Every relation contains:

A)Equivalent functional dependency
B)Augmented functional dependency
C)Trivial functional dependency
D)All of the above

Question 8

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

Question 9

FLIGHT
Observe the table FLIGHT:
FLIGHT
$$\begin{array} { c l l c c } \text { FlightID } & \text { Date } & \text { Origin } & \text { Destination } & \text { NoOfpassengers } \\\text { U111 } & 1 / 1 / 2013 & \text { Chicago } & \text { Denver } & 100 \\\text { U111 } & 1 / 2 / 2013 & \text { Chicago } & \text { Denver } & 108 \\\text { U222 } & 1 / 1 / 2013 & \text { Denver } & \text { Seatle } & 115 \\\text { U333 } & 1 / 1 / 2013 & \text { Chicago } & \text { Orlando } & 160\end{array}$$

-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

Question 10

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

A)A,B --> C
B)A,C --> B
C)A --> C
D)B --> A

Question 11

Which of the following is a modify operation?

A)Entering new data in the relation
B)Retrieving data from the relation
C)Removing data from the relation
D)Changing the existing data in the relation

Question 12

Every relation contains:

A)Full key functional dependency
B)Partial functional dependency
C)Transitive functional dependency
D)All of the above

Question 13

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

Question 14

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c } \text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \\111 & \text { Joe } & \text { El } & \text { Enghishl } \\222 & \text { Bob } & E 1 & \text { Enghishl } \\333 & \text { Lisa } & \text { H1 } & \text { Historyl }\end{array}$$

-Which of the following (regarding the relation ENROLLMENT)represents the modification anomaly?

A)If a class name changes,it may have to be changed in more than one record
B)If a student ID changes,we may have to change the class ID as well
C)If a class ID changes,we may have to change the student ID as well
D)If a student decides to use a longer version of his or her name,we cannot accommodate that modification

Question 15

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

A)Trivial
B)Full key
C)Partial
D)Transitive

Question 16

Table ENROLLMENT is:

A)Not in 1NF
B)In 1NF but not in 2NF
C)In 2NF but not in 3NF
D)In 3NF

Question 17

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c } \text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \\111 & \text { Joe } & \text { El } & \text { Enghishl } \\222 & \text { Bob } & E 1 & \text { Enghishl } \\333 & \text { Lisa } & \text { H1 } & \text { Historyl }\end{array}$$

-Which of the following (regarding the relation ENROLLMENT)represents the deletion anomaly?

A)Deleting a student ID may delete a student name
B)Deleting a class ID may delete the class name
C)Deleting a class may delete all information about a student
D)Deleting a student may delete all information about a class

Question 18

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c } \text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \\111 & \text { Joe } & \text { El } & \text { Enghishl } \\222 & \text { Bob } & E 1 & \text { Enghishl } \\333 & \text { Lisa } & \text { H1 } & \text { Historyl }\end{array}$$

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

A)Trivial
B)Full key
C)Partial
D)Transitive

Question 19

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c } \text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \\111 & \text { Joe } & \text { El } & \text { Enghishl } \\222 & \text { Bob } & E 1 & \text { Enghishl } \\333 & \text { Lisa } & \text { H1 } & \text { Historyl }\end{array}$$

-Which of the following is in danger of being affected by the deletion anomaly in the table ENROLLMENT?

A)Student 111,Joe
B)Student 222,Bob
C)Class H1,History
D)Class E1,English

Question 20

ENROLLMENT
Observe the table ENROLLMENT:
ENROLLMENT
$$\begin{array} { c c c c } \text { StudentID } & \text { StidentName } & \text { ClasslD } & \text { CassName } \\111 & \text { Joe } & \text { El } & \text { Enghishl } \\222 & \text { Bob } & E 1 & \text { Enghishl } \\333 & \text { Lisa } & \text { H1 } & \text { Historyl }\end{array}$$

-Which of the following actions in the table ENROLLMENT will be prevented by an insertion anomaly?

A)Entering a new student 444,Sue
B)Entering a new student 555,Lisa
C)Entering a new record 666,Bob,E1,English
D)Entering a new class M1,Math1

Question 21

Every relation without transitive functional dependencies is in 3NF.

Question 22

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Attempting to insert a new vehicle 555,Van,Honda in the table VEHICLE will cause an occurrence of an insertion anomaly.

Question 23

Normalizing table FLIGHT to 3NF will result in:

A)No changes (table FLIGHT remains as is,no additional tables)
B)Two separate tables
C)Three separate tables
D)Four separate tables

Question 24

Every 3NF database can be further streamlined by including designer-added tables and keys.

Question 25

DOCTOR
Observe the table DOCTOR:
DOCTOR
$$\begin{array} { c c c c } \text { DoctorID } & \text { Name } & \text { Date OfMDGraduation } & \text { NumberOfPatients } \\\text { D111 } & \text { John } & 1 / 1 / 1999 & 100 \\\text { D222 } & \text { Tina } & 1 / 2 / 2003 & 117 \\\text { D333 } & \text { Ellen } & 1 / 1 / 2001 & 117 \\\text { D444 } & \text { Tina } & 1 / 1 / 2003 & 144\end{array}$$

This table will be used for the following questions citing table DOCTOR.

-Normalizing table DOCTOR to 3NF will result in:

A)No changes (table DOCTOR remains as is,no additional tables)
B)Two separate tables
C)Three separate tables
D)Four separate tables

Question 26

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.

Question 27

DOCTOR
Observe the table DOCTOR:
DOCTOR
$$\begin{array} { c c c c } \text { DoctorID } & \text { Name } & \text { Date OfMDGraduation } & \text { NumberOfPatients } \\\text { D111 } & \text { John } & 1 / 1 / 1999 & 100 \\\text { D222 } & \text { Tina } & 1 / 2 / 2003 & 117 \\\text { D333 } & \text { Ellen } & 1 / 1 / 2001 & 117 \\\text { D444 } & \text { Tina } & 1 / 1 / 2003 & 144\end{array}$$

This table will be used for the following questions citing table DOCTOR.

-What type of functional dependency exists in the table DOCTOR?

A)Trivial
B)Partial
C)Transitive
D)All of the above

Question 28

Every relation without transitive functional dependencies is in 2NF.

Question 29

DOCTOR
Observe the table DOCTOR:
DOCTOR
$$\begin{array} { c c c c } \text { DoctorID } & \text { Name } & \text { Date OfMDGraduation } & \text { NumberOfPatients } \\\text { D111 } & \text { John } & 1 / 1 / 1999 & 100 \\\text { D222 } & \text { Tina } & 1 / 2 / 2003 & 117 \\\text { D333 } & \text { Ellen } & 1 / 1 / 2001 & 117 \\\text { D444 } & \text { Tina } & 1 / 1 / 2003 & 144\end{array}$$

This table will be used for the following questions citing table DOCTOR.

-Table DOCTOR is:

A)Not in 1NF
B)In 1NF but not in 2NF
C)In 2NF but not in 3NF
D)In 3NF

Question 30

Every relation without partial functional dependencies is in 3NF.

Question 31

Table FLIGHT is:

A)Not in 1NF
B)In 1NF but not in 2NF
C)In 2NF but not in 3NF
D)In 3NF

Question 32

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.

Question 33

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 C --> D is a transitive functional dependency.

Question 34

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

Question 35

Every relation is in 1NF.

Question 36

Update operations are also referred to as read operations.

Question 37

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.

Question 38

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Attempting to insert a new vehicle 666,Car,Ford in the table VEHICLE will cause an occurrence of an insertion anomaly.

Question 39

Every relation without partial functional dependencies is in 2NF.

Question 40

Every normalized database is eventually denormalized.

Question 41

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency VehicleID --> OwnerID exists in the table VEHICLE.

Question 42

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency Make --> OwnerID exists in the table VEHICLE.

Question 43

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency Type --> VehicleID exists in the table VEHICLE.

Question 44

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency Make --> VehicleID exists in the table VEHICLE.

Question 45

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Attempting to insert a new owner O4,Matt in the table VEHICLE will cause an occurrence of an insertion anomaly.

Question 46

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-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.

Question 47

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency Make --> OwnerName exists in the table VEHICLE.

Question 48

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency Type --> OwnerName exists in the table VEHICLE.

Question 49

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Changing the name of owner O2,Pat to Patrick in the table VEHICLE will cause an occurrence of a modification anomaly.

Question 50

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Changing the name of owner O3,Pam to Pamela in the table VEHICLE will cause an occurrence of a modification anomaly.

Question 51

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency Type --> OwnerID exists in the table VEHICLE.

Question 52

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Changing the type and name of vehicle 444 in the table VEHICLE will cause an occurrence of a modification anomaly.

Question 53

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency VehicleID --> Type exists in the table VEHICLE.

Question 54

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency VehicleID --> Make exists in the table VEHICLE.

Question 55

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency VehicleID --> OwnerName exists in the table VEHICLE.

Question 56

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Deleting the following record in the table VEHICLE: 111,Car,Ford,O1,Pam
while leaving the remaining three records in the table,will cause an occurrence of a deletion anomaly.

Question 57

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency Make --> Type exists in the table VEHICLE.

Question 58

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Deleting the following record in the table VEHICLE: 333,Truck,Honda,O3,Pam
will cause an occurrence of a deletion anomaly.

Question 59

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Changing the name of owner O1,Pam to Pamela in the table VEHICLE will cause an occurrence of a modification anomaly.

Question 60

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency Type --> Make exists in the table VEHICLE.

Question 61

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Table VEHICLE is in 3NF

Question 62

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Partial functional dependency exists in the table VEHICLE.

Question 63

STUDENT
Observe the table STUDENT:
STUDENT
$$\begin{array} { l c l l } \text { StudentID } & \text { SSN } & \text { Nane } & { \text { Class } } \\\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \\D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \\D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \\D 444 & 444 - 444444 & \text { Parker } & \text { Sophomore } \\D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }\end{array}$$

-Functional dependency StudentID --> Name exists in the table STUDENT.

Question 64

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Normalizing table VEHICLE to 3NF will result in two separate tables.

Question 65

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency OwnerID --> Type exists in the table VEHICLE.

Question 66

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency OwnerName --> VehicleID exists in the table VEHICLE.

Question 67

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency OwnerID --> OwnerName exists in the table VEHICLE.

Question 68

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Trivial functional dependency exists in the table VEHICLE.

Question 69

STUDENT
Observe the table STUDENT:
STUDENT
$$\begin{array} { l c l l } \text { StudentID } & \text { SSN } & \text { Nane } & { \text { Class } } \\\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \\D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \\D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \\D 444 & 444 - 444444 & \text { Parker } & \text { Sophomore } \\D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }\end{array}$$

-Full key functional dependency exists in the table STUDENT.

Question 70

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Full key functional dependency exists in the table VEHICLE.

Question 71

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Table VEHICLE is in 1NF

Question 72

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency OwnerName --> Make exists in the table VEHICLE.

Question 73

STUDENT
Observe the table STUDENT:
STUDENT
$$\begin{array} { l c l l } \text { StudentID } & \text { SSN } & \text { Nane } & { \text { Class } } \\\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \\D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \\D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \\D 444 & 444 - 444444 & \text { Parker } & \text { Sophomore } \\D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }\end{array}$$

-Equivalent functional dependencies exist in the table STUDENT.

Question 74

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Table VEHICLE is in 2NF

Question 75

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency OwnerID --> VehicleID exists in the table VEHICLE.

Question 76

STUDENT
Observe the table STUDENT:
STUDENT
$$\begin{array} { l c l l } \text { StudentID } & \text { SSN } & \text { Nane } & { \text { Class } } \\\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \\D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \\D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \\D 444 & 444 - 444444 & \text { Parker } & \text { Sophomore } \\D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }\end{array}$$

-Augmented functional dependency exists in the table STUDENT.

Question 77

STUDENT
Observe the table STUDENT:
STUDENT
$$\begin{array} { l c l l } \text { StudentID } & \text { SSN } & \text { Nane } & { \text { Class } } \\\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \\D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \\D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \\D 444 & 444 - 444444 & \text { Parker } & \text { Sophomore } \\D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }\end{array}$$

-Functional dependency SSN --> Name exists in the table STUDENT.

Question 78

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency OwnerName --> OwnerID exists in the table VEHICLE.

Question 79

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency OwnerName --> Type exists in the table VEHICLE.

Question 80

VEHICLE
Observe the table VEHICLE that contains the following four records:
VEHICLE
$$\begin{array} { l l l c l } \text { Vehiclell } & \text { Type } & \text { Make } & \text { OwnerID } & \text { OwnerName } \\111 & \text { Car } & \text { Ford } & O 1 & \text { Pam } \\222 & \text { Car } & \text { Ford } & O2 & \text { Pat } \\333 & \text { Thuck } & \text { Honda } & O 3 & \text { Pan } \\444 & \text { Car } & \text { Honda } & \text { O1 } & \text { Pan }\end{array}$$

-Functional dependency OwnerID --> Make exists in the table VEHICLE.