1.Convert 1NF to 2NF a. Rule1 - be in 1NF b. Rule 2- Single Column Primary Key A

Question

1.Convert 1NF to 2NF

a. Rule1 - be in 1NF

b. Rule 2- Single Column Primary Key

Assignment: A video library maintains a database of movies rented out. Without any normalization, all information is stored in one table as shown below Full Names Physical Address First Street PlotPirates of the Movies rented Salutation Category anet Jones Ms. Action, Action Caribbean Clash of the Titans Forgetting Sarah Marshal, Daddy's Little Girls Clash of the Titans Robert Phil 3rd Street 34 Mr. Romance, Romance Robert Phil 5th Avenue Mr. Action

Explanation / Answer

SOLUTION:-

1 NF :-

Because Full Names(mentioned bold in above table) are common so in order to indentification of record uniquely, we will need Full Name and Address. Here is a composite key given below:-

2 NF:-

a. Rule1- Be in 1NF

b. Rule 2- Single Column Primary Key

(TABLE-1)

PRIMARY KEY : Member_ID for Table-1

Foreign Key: Member_ID for Table-2   (TABLE-2)

From Table-2, Member_ID (Mentioned in above Table-2) Foreign Key will act as a Primary Key :Member_ID for Table-1 given below:-

(TABLE-1)

=====================================================================================

Full Names Physical Address Movies rented Salutation Janet Jones First Street Plot No 4 Pirates of the Caribbean Ms. Janet Jones First Street Plot No 4 Clash of the Titans Ms. Robert Phil 3rd Street 34 Forgetting Sarah Marshal Mr. Robert Phil 3rd Street 34 Daddy's Little Girls Mr. Robert Phil 5th Avenue Clash of the Titans Mr.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.