ASSIGNMENT #3 INSTRUCTIONS:

Normalize the un-normalized table given below through 1NF, 2NF and 3NF. Show the normalization process in a file (.doc, .xls, etc.), and submit it through the link available on Canvas. Name your file according to this scheme: yourlastname_a3_movies.docx. (or ...xlsx, etc.)

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

- Hint: Note that there are two groups of repeating fields in this un-normalized table.

Movies Table eld mple Record ie ID Number 43 ie Title father Genre rama e Length uction Company Name Paramount uction Company Address 5555 Melrose Ave., Hollywood, CA 90038 uction Company Phone (323) 956 5000 175 uction Company Website http://www.paramount.com tor/Actress 1 First Name tor/Actress 1 Last Name tor/Actress 1 Role n Vito Corleone r/Actress 2 First Narne Actor/Actress 2 Last Name r/Actress 2 Role ichael Corleone tor/Actress 3 First Name tor/Actress 3 Last Name aton tor/Actress 3 Role Adams Corleone Showing at Theater 1 Name Bethesda 10 eater 1 Address 272 Wisconsin Ave., Bethesda, MD 20814 eater 1 Phone Number 301) 718 9449 Showing at Theater 2 Name ckville Stadium 13 ter 2 Address 199 East Montgomery Ave., Rockville, MD 20850 ter 2 Phone Number (301) 340 9390 Showing at Theater 3 Name n Stadium 14 ter 3 Address 0 Cerntury Blvd., Germantowrn, MD 20874 ter 3 Phone Number (301) 916 4435