[go: up one dir, main page]

0% found this document useful (0 votes)
25 views2 pages

07 Performance Task 1 PDF

The document outlines the normalization process for a database of movie rentals at MVC Video Rentals, demonstrating the transition from an unnormalized table to 1NF, 2NF, and 3NF. It includes detailed tables showing how data is organized and relationships are established between members and the movies they rented. The final structure separates personal information, rental details, and salutations into distinct tables to eliminate redundancy.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
25 views2 pages

07 Performance Task 1 PDF

The document outlines the normalization process for a database of movie rentals at MVC Video Rentals, demonstrating the transition from an unnormalized table to 1NF, 2NF, and 3NF. It includes detailed tables showing how data is organized and relationships are established between members and the movies they rented. The final structure separates personal information, rental details, and salutations into distinct tables to eliminate redundancy.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

BM2401

NAME: Pepito, Mark Venes DATE: 03-15-25 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. Salutation

Full Names Physical Address Movies Rented Category


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

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 Caribbean 4) Mr.
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 Caribbean
35) 1 36) The Avengers
37) 2 38) The Hows of Us
39) 2 40) The Notebook
41) 3 42) The Avengers
• 3NF

Membership ID Full Names Physical Address Salutation ID


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

07 Performance Task 1 *Property of STI


Page 1 of 2
BM2401

Membership ID Movies Rented


55) 1 56) Pirate Of 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) Mr.
2) Mr.
3) Ms.
4) Ms.

07 Performance Task 1 *Property of STI


Page 2 of 2

You might also like