Quiz

Question 1 (1 point)

Saved

Listen

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 would be a partial functional dependency.

Question 1 options:

	1) True
	2) False

Question 2 (1 point)

Saved

Listen

Every relation contains:

Question 2 options:

1)	Full key functional dependency
2)	Partial functional dependency
3)	Transitive functional dependency
4)	All of the above
5)	None of the above

Question 3 (1 point)

Saved

Listen

Every relation without partial functional dependencies is in 2NF.

Question 3 options:

	1) True
	2) False

Question 4 (1 point)

Listen

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

Question 4 options:

	1) True
	2) False

Question 5 (1 point)

Listen

Observe the table VEHICLE that contains the following four records: VEHICLE VehicleID Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Truck Honda O3 Pam 444 Car Honda O1 Pam Changing the name of owner O1, Pam to Pamela in the table VEHICLE (with its current 4 records) will cause an occurrence of a modification anomaly.

Question 5 options:

	1) True
	2) False

Question 6 (1 point)

Listen

Observe the table STUDENT: STUDENT StudentID SSN Name Class D111 111-11-1111 Connor Freshman D222 222-22-2222 Trevor Freshman D333 333-33-3333 Connor Sophomore D444 444-44-4444 Parker Sophomore D555 555-55-5555 Connor Sophomore Functional dependency StudentID --> Name exists in the table STUDENT.

Question 6 options:

	1) True
	2) False

Question 7 (1 point)

Saved

Listen

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 7 options:

	1) True
	2) False

Question 8 (1 point)

Saved

Listen

Every relation without partial functional dependencies is in 3NF.

Question 8 options:

	1) True
	2) False

Question 9 (1 point)

Saved

Listen

Observe the table ENROLLMENT: ENROLLMENT StudentID StudentName MajorID MajorName 111 Joe E English 222 Bob H History 333 Lisa H History Which of the following (regarding the relation ENROLLMENT) represents the insertion anomaly?

Question 9 options:

1)	Inability to insert a student without adding a major
2)	Inability to insert a major without adding a student
3)	Inability to insert a major name without a major ID
4)	Inability to insert a student name without a student ID
5)	All of the above

Question 10 (1 point)

Listen

Observe the table VEHICLE that contains the following four records: VEHICLE VehicleID Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Truck Honda O3 Pam 444 Car Honda O1 Pam Deleting the following record in the table VEHICLE: 333, Truck, Honda, O3, Pam while leaving the remaining three records in the table, will cause an occurrence of a deletion anomaly.

Question 10 options:

	1) True
	2) False

Submit Quiz6 of 10 questions saved

Listen