Question 1

List the types of update anomalies?

Accepted Answer

Insertion anomaly,de

Question 2

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.

Accepted Answer

A) True 
 B)False

Question 3

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.

Accepted Answer

A) True 
 B)False

Question 4

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.

Accepted Answer

A) True 
 B)False

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

When does a full key functional dependency occur?

Accepted Answer

Full key functional dependency

Question 7

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.

Accepted Answer

A) True 
 B)False

Question 8

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.

Accepted Answer

A) True 
 B)False

Question 9

Every relation without transitive functional dependencies is in 2NF.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

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.

Accepted Answer

A) True 
 B)False

Question 12

What is denormalization?

Accepted Answer

Denormalization refers to reve

Question 13

Give an example of redundant data.

Accepted Answer

A table of purchases

Question 14

When do trivial functional dependencies occur?

Accepted Answer

Trivial functional dependencie

Question 15

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}$$
-Table STUDENT is in 2NF.

Accepted Answer

A) True 
 B)False

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

When does a functional dependency occur?

Accepted Answer

A functional dependency occurs

Question 18

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.

Accepted Answer

A) True 
 B)False

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 (regarding the relation ENROLLMENT)represents the deletion anomaly?

Accepted Answer

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

Every relation contains:

Accepted Answer

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

List the types of update anomalies?

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

When does a full key functional dependency occur?

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

Every relation without transitive functional dependencies is in 2NF.

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

What is denormalization?

Give an example of redundant data.

When do trivial functional dependencies occur?

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 -Table STUDENT is in 2NF.

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

When does a functional dependency occur?

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 (regarding the relation ENROLLMENT)represents the deletion anomaly?

Every relation contains:

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

Exam 4: Update Operations, update Anomalies, and Normalization

List the types of update anomalies?

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

When does a full key functional dependency occur?

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

Every relation without transitive functional dependencies is in 2NF.

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

What is denormalization?

Give an example of redundant data.

When do trivial functional dependencies occur?

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 -Table STUDENT is in 2NF.

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

When does a functional dependency occur?

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 (regarding the relation ENROLLMENT)represents the deletion anomaly?

Every relation contains:

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