For the following, answer whether Tables are in 3NF? If No, State the normalizat
ID: 3851821 • Letter: F
Question
For the following, answer whether Tables are in 3NF? If No, State the normalization rule that is violated. Rules can be: A) No multi-valued attribute B) Not dependent on the whole primary key C) Dependencies between non-key attributes. Employee (ssn, Name, Salary, Address, ListOfSkills) Yes No Violates Rule: _____ Vehicle (LicensePlate, Brand, Model, PurchasePrice, Year, OwnerSSN, OwnerName) 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 (ItemNo, ComponentNo, ItemName, Quantity) where ItemNo rightarrow ItemName Yes No Violates Rule: _____Explanation / Answer
6.
1.
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.
2.
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.
3.
Employee (ssn,Name, Salary, did)
The above statement not violated any normalized rule.
4.
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.
5.
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.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.