1) Provide a list of tables and columns for each table that changes the example

Question

1) Provide a list of tables and columns for each table that changes the example to first normal form.

2) Is your answer to question 1 also in third normal form? If not, provide a list of tables and the columns for each table that changes the example to third normal form.

Address 3333 Mocking Bird Lane, London, England 3333 Mocking Bird Lane, London, England 1071 5th Avenue, New York, NY 10128 Name Coursel Course2 Course3 Joe Smith INET 4707 INET 4031 INET 4165 Mary Lee INET 4082 ABUS CSCI 4211 4022 Tom Hanson ADPY 6107 AST 1001 Sue Hass PO Box 1880, Tombstone, AZ 85638

Explanation / Answer

1. First Normal Form

STUDENT

2.

No the table is not in third Normal Form. Following tables are in third normal form

STUDENT(Name,Address)

COURSE(CourseName)

STUDENTCOURSE(CourseName,StudentName)

Name Address CourseName Joe Smith 3333 Mocking Bird Lane,London,England INET 4707 Joe Smith 3333 Mocking Bird Lane,London,England INET 4031 Joe Smith 3333 Mocking Bird Lane,London,England INET 4165 Mary Lee 3333 Mocking Bird Lane,London,England INET 4082 Mary Lee 3333 Mocking Bird Lane,London,England ABUS 4022 Mary Lee 3333 Mocking Bird Lane,London,England CSCI 4211 Tom Hansen 1071 5th Avenue,New York,NY 10128 ADPY 6107 Tom Hansen 1071 5th Avenue,New York,NY 10128 AST 1001 Sue Hass PO Box 1880,Tombstone,AZ 85638 NULL

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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