Scribd
Upload
263 views2 pages

Normalization of MVC Rental Database

The document describes normalizing a movie rental database from a single table to 1NF, 2NF, and 3NF. The original table contains customer information and rented movies. The 1NF table splits the data into separate rows. The 2NF table extracts the customer ID and addresses into separate tables. The 3NF table further normalizes the data by separating salutations into another table.

Uploaded by

Emperor Savage
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
263 views2 pages

Normalization of MVC Rental Database

The document describes normalizing a movie rental database from a single table to 1NF, 2NF, and 3NF. The original table contains customer information and rented movies. The 1NF table splits the data into separate rows. The 2NF table extracts the customer ID and addresses into separate tables. The 3NF table further normalizes the data by separating salutations into another table.

Uploaded by

Emperor Savage
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

BM2013

NAME: DATE: SCORE:

THE NORMALIZATION ACTIVITY

MVC Video Rentals maintains a database of movies rented out. Without normalization, all information is
stored in one (1) table, as shown below.

Full Names Physical Address Movies Rented Salutation Category


Pirates of the Caribbean, The
Patrick Rivera 1st Street, Lot 4 Mr. Action, Action
Avengers
Romance,
Lorreyn Mondragon 3rd Street The Hows of Us, The Notebook Ms.
Romance
Lorreyn Mondragon 5th Avenue The Avengers Ms. Action

Required: Normalize the table into (a) 1NF, (b) 2NF, and (c) 3NF by supplying the answers for each table. (65
items x 1 point)

 1NF

Full Names Physical Address Movies Rented Salutation


1) Patrick Rivera 2) 1st Street, Lot 4 3) Pirates of the 4) Mr.
Caribbean
5) Patrick Rivera 6) 1st Street, Lot 4 7) The Avengers 8) Mr.
9) Lorreyn Mondragon 10) 3rd Street 11) The Hows of Us 12) Ms.
13) Lorreyn Mondragon 14) 3rd Street 15) The Notebook 16) Ms.
17) Lorreyn Mondragon 18) 5th Avenue 19) The Avengers 20) Ms.

 2NF

Membership ID Full Names Physical Address Salutation


21) 1 22) Patrick Rivera 23) 1st Street, Lot 4 24) Mr.
25) 2 26) Lorreyn Mondragon 27) 3rd Street 28) Ms.
29) 3 30) Lorreyn Mondragon 31) 5th Avenue 32) Ms.

Membership ID Movies Rented


33) 1 34) Pirates of the
Caribbean
35) 1 36) The Avengers
37) 2 38) The Hows of Us
39) 2 40) The Notebook
41) 3 42) The Avengers

07 Task Performance 1 *Property of STI


Page 1 of 2
BM2013

 3NF

Membership ID Full Names Physical Address Salutation ID


43) 1 44) Patrick Rivera 45) 1st Street, Lot 4 46) 1
47) 2 48) Lorreyn Mondragon 49) 3rd Street 50) 2
51) 3 52) Lorreyn Mondragon 53) 5th Avenue 54) 2

Membership ID Movies Rented


55) 1 56) Pirates of the
Caribbean
57) 1 58) The Avengers
59) 2 60) The Hows of Us
61) 2 62) The Notebook
63) 3 64) The Avengers

Salutation ID Salutation
1) 1 Mr.
2) 2 Ms.
3)
4)

07 Task Performance 1 *Property of STI


Page 2 of 2

You might also like