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

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 A) Not in 1NF B) In 1NF but not in 2NF C) In 2NF but not in 3NF D) In 3NF

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

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 A) StudentID --> StudentName B) StudentName --> StudentID C) StudentID --> ClassID D) ClassID --> ClassName

Exam 4: Update Operations, update Anomalies, and Normalization

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.

(True/False)

4.8/5

(32)

Question 61

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 -Equivalent functional dependencies exist in the table STUDENT.

(True/False)

4.9/5

(31)

Question 62

FLIGHT Observe the table FLIGHT: FLIGHT FlightID Date Origin Destination NoOfpassengers U111 1/1/2013 Chicago Denver 100 U111 1/2/2013 Chicago Denver 108 U222 1/1/2013 Denver Seatle 115 U333 1/1/2013 Chicago Orlando 160 -Which of the following (regarding the relation FLIGHT)represents the insertion anomaly?

(Multiple Choice)

4.8/5

(35)

Question 63

Give a definition of 3NF.

(Essay)

4.9/5

(40)

Question 64

Which of the following is a read operation?

(Multiple Choice)

4.8/5

(35)

Question 65

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. -Table DOCTOR is:

(Multiple Choice)

4.8/5

(26)

Question 66

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 2NF

(True/False)

4.9/5

(47)

Question 67

Update operations are also referred to as read operations.

(True/False)

4.9/5

(26)

Question 68

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

(True/False)

4.7/5

(31)

Question 69

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 actions in the table ENROLLMENT will be prevented by an insertion anomaly?

(Multiple Choice)

4.7/5

(41)

Question 70

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 -Partial functional dependency exists in the table VEHICLE.

(True/False)

5.0/5

(26)

Question 71

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 StudentID --> Name exists in the table STUDENT.

(True/False)

4.7/5

(34)

Question 72

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 functional dependencies does NOT exist in the table ENROLLMENT?

(Multiple Choice)

4.9/5

(35)

Question 73

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

(True/False)

4.8/5

(36)

Question 74

When does a partial functional dependency occur?

(Essay)

4.8/5

(34)

Question 75

Every relation without partial functional dependencies is in 2NF.

(True/False)

4.9/5

(36)

Question 76

Which three operations are collectively referred to as update operations?

(Essay)

4.8/5

(38)

Question 77

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

(True/False)

4.9/5

(36)

Question 78

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: 333,Truck,Honda,O3,Pam will cause an occurrence of a deletion anomaly.

(True/False)

4.9/5

(46)

Question 79

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

(True/False)

4.9/5

(43)

Question 80

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.

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 -Equivalent functional dependencies exist in the table STUDENT.

Give a definition of 3NF.

Which of the following is a read operation?

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. -Table DOCTOR is:

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 2NF

Update operations are also referred to as read operations.

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

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 actions in the table ENROLLMENT will be prevented by an insertion 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 -Partial functional dependency exists in the table VEHICLE.

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 functional dependencies does NOT exist in the table ENROLLMENT?

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

When does a partial functional dependency occur?

Every relation without partial functional dependencies is in 2NF.

Which three operations are collectively referred to as update operations?

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

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

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters