Question
For questions 3-8, are the following Tables in 3NF ? Cirlcle Yes or No. If not, explain why ? State the normalization rule that it
For questions 3-8, are the following Tables in 3NF ? Cirlcle Yes or No. If not, explain why ? State the normalization rule that it is violating. Rules can be: A) No multi-valued attribute, B) Not dependent on the whole primary key, C) Dependencies between non-key attributes. Hint: if A determines B and B determines C, then A determines C.
Example
Employee (eid, ename, address, salary, did, dname)
Yes, No. Rule: C) Dependencies between non-key attributes
3) Employee (ssn, Name, Salary, Address, ListOfSkills)
Yes, NO Rule: No multi-valued attribute
4) Department (Did, Dname, ssn)
Yes, NO. Rule: No multi-valued attribute
5) Vehicle (LicensePlate, Brand, Model, PurchasePrice, Year, OwnerSSN, OwnerName
Yes, No Rule: Dependencies between non-key attributes
6) Employee (ssn, Name, Salary, did) (obs.: employee can only belong to one department)
Yes, No. Rule:
7) Customer (Cust_Id, Name, Salesperson, Region) where Salesperson determines Region.
Yes, NO. Rule: Dependencies between non-key attributes
8) Component (ItemNo, ComponentNo, ItemName, Quantity) where ItemNo -> ItemName
Yes,NO. Rule: Not dependent on the whole primary key
9) What is the main purpose of Normalization
a) Speeding up queries
b) Avoiding Insert, Update and Delete Anomalies (maintenance)
c) Saving Disk Space
d) Flunking Students
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started