Database

1. The following relational schema, Order (OrderNo, Product1, Product2, Product3, UnitPrice, Quantity) is in violation of which Normal Form?

Select one:

A.First Normal Form.

B.Second Normal Form.

C.Third Normal Form.

D.None of the above.

2. The property of _________ enables an entity subclass to collect the attributes and relationships of the superclass.

Select one:

A.functional dependency

B.lossless-join property

C.specialization hierarchy

D.inheritance

3. Why is the following relational schema, Registration (StudentNo, ProjectNo, StudentName, StartDate, TotalHours) is NOT in Second Normal Form?

Select one:

A.It is not in First Normal Form.

B.It has a composite key.

C.Non-key attribute StudentName is dependent on StudentNo.

D.Non-key attributes StartDate and TotalHours are dependent on (StudentNo, ProjectNo).