Question: Normalize the un-normalized table given below through 1NF, 2NF and 3NF. Show the normalization process in a file (.docx, .xlsx, or .pdf). In order to
Normalize the un-normalized table given below through 1NF, 2NF and 3NF. Show the normalization process in a file (.docx, .xlsx, or .pdf).
In order to complete this assignment successfully, please keep in mind the following points as you work on the normalization case:
- Normalize the flat table through each of the 1NF, 2NF and 3NF separately and in sequence.
- Make sure that you cover each normalization step (1NF, 2NF, 3NF) separately, explicitly, and in sequence.
- Do not skip any normalization steps.
- In each normalization step, you should only resolve the issue(s) that pertain to the given step. (For example, do not resolve transitive dependencies in 1NF or 2NF, as transitive dependencies are 3NF business.)
- In each step, list all of the tables, including those do not change in the given step.
- Identify and show primary keys and foreign keys in each step.
- Show the relationships between the tables in each form (by drawing lines/arrows between corresponding PKs and FKs).
- The sample records are for your reference only to help you understand the nature of each field. You should not include them in your normalization work.
- Type your work in an MS Word or a similar text processing file. You can also use a spreadsheet application such as MS Excel, if you find it easier to work with. You can also use the .pdf format.
- Hint: Note that there are two groups of repeating fields in this un-normalized table.
Movies Table
| Field | Sample Record |
| Movie ID Number | 143 |
| Movie Title | Godfather |
| Movie Genre | Drama |
| Movie Length | 175 |
| Production Company Name | Paramount |
| Production Company Address | 5555 Melrose Ave., Hollywood, CA 90038 |
| Production Company Phone No. | (323) 956 5000 |
| Production Company Website | http://www.paramount.com |
| Actor/Actress 1 First Name | Marlon |
| Actor/Actress 1 Last Name | Brando |
| Actor/Actress 1 Role | Don Vito Corleone |
| Actor/Actress 2 First Name | Al |
| Actor/Actress 2 Last Name | Pacino |
| Actor/Actress 2 Role | Michael Corleone |
| Actor/Actress 3 First Name | Diane |
| Actor/Actress 3 Last Name | Keaton |
| Actor/Actress 3 Role | Kay Adams Corleone |
| Showing at Theater 1 Name | Bethesda 10 |
| Theater 1 Address | 7272 Wisconsin Ave., Bethesda, MD 20814 |
| Theater 1 Phone Number | (301) 718 9449 |
| Showing at Theater 2 Name | Rockville Stadium 13 |
| Theater 2 Address | 199 East Montgomery Ave., Rockville, MD 20850 |
| Theater 2 Phone Number | (301) 340 9390 |
| Showing at Theater 3 Name | Germantown Stadium 14 |
| Theater 3 Address | 20000 Century Blvd., Germantown, MD 20874 |
| Theater 3 Phone Number | (301) 916 4435 |
The answer from the other post with this same question is incorrect.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help