Module 3 Exam Complete this exercise as we have been complet

Module 3 Exam: Complete this exercise as we have been completing the other three normalization problems. Here are formatting requirements

Save the file as \"Pipes\" using whichever text editor you prefer

All I want is a table listing in 3NF. You do not have to list the various steps you use . . . all I want is the finished 3NF listing of tables.

NO UML!

Primary keys should be underlined and bold

Foreign keys should be italicized

If you make assumptions about how the business processes work you must list those in the document.

Attach the completed file to the provided drop box.

Solution

That\'s the \"saying\" about 3NF tables. Simply put, each table must contain a primary key (1NF). 2NF is \"the whole key\" which means that all attributes within each table must depend on the primary key of the table. 3NF is \"nothing but the key.\" Requiring that non-key attributes be dependent on \"nothing but the key\" ensures 3NF. This means that non-key attributes cannot depend on attributes other than the primary key itself for any given table.

For example:

This table has a primary key, so it fits 1NF. 2NF states that all attributes depend on the key. For this table, I personally don\'t believe that the job_desc and specialty are dependent on the instructor itself as far as entity-attribute relationships go. For this, I would actually split that attribute into a new table like so.

The Instructors table now fits 2NF. Now for the third normal form. 3NF is \"nothing but the key\" which means that non-key attributes cannot depend on attributes other than the primary key itself for any given table.

Let\'s look at instructor\'s attributes: instructorID(PK) - the PK itself.

This table now meets 3NF.