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