Database Tables in 3NF For the following answer whether Tabl

Database Tables in 3NF

For the following, answer whether Tables are in 3NF? If No. State the normalization rule that is violated. Rules can be: No multi-valued attribute Not dependent on the whole primary key Dependencies between non-key attributes. Employee (ssn, Name, Salary, Address, List Of Skills) Yes No Violates Rule:_ Vehicle (License Plate. Brand. Model. Purchase Price. Year. Owner SSN, Owner Name) Yes No Violates Rule:_ Employee (ssn, Name, Salary, did) Yes No Violates Rule:_ Customer (Cust Id, Name, Salesperson, Region) where Salesperson determines Region. Yes No Violates Rule:_ Component (Item No, Component No, Item Name, Quantity) where Item No rightarrow Item Name Yes No Violates Rule:_

Solution

6.

Statement : Employee (ssn, Name, Salary, Address, ListOfSkills).

The above statement refers to the No multi-valued attribute.

The normalization rule that is violated is rule A.

Therefore No is correct choicce.

7.

Statement : Vehicle (LicensePlate,Brand, Model, PurchasePrice, Year, OwnerSSN, OwnerName)

The above statement refers to the Dependencies between non-key attributes.

The normalization rule that is violated is rule C.

Therefore No is correct choicce.

8.

Employee (ssn,Name, Salary, did)

The above statement not violated any normalized rule.

9.

Statement : Customer (Cust_Id, Name, Salesperson, Region) where Salesperson determines Region.

The above statement refers to the Dependencies between non-key attributes.

The normalization rule that is violated is rule C.

Therefore No is correct choicce.

10. Statement : Component (ItemNo, ComponentNo, ItemName, Quantity) where ItemNo ->ItemName.

Statement : Customer (Cust_Id, Name, Salesperson, Region) where Salesperson determines Region.

The above statement refers to the Not dependent on the whole primary key.

The normalization rule that is violated is rule B.

Therefore No is correct choicce.