For questions 3-8, are the following Tables in 3NF ? Cirlcle Yes or No. If not,

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 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

Explanation / Answer

3)-----------no,listofskills is multivalued attributes.

4)--------------no,student can be in one or more department.

5)----------------no, year->model( Dependencies between non-key attributes)

6)----------no, name--->did (Dependencies between non-key attributes)

7)----------- no, salesperson-->region( Dependencies between non-key attributes)

8)---------no, ItemNo -> ItemName

9)-------------------- the main purpose of Normalization is to Avoiding Insert, Update and Delete Anomalies (maintenance)

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.