Question: Normalization: Library ( call _ no , member _ id , first _ name, last _ name, DOB, start _ date, end _ date, date

Normalization:
Library(call_no, member_id, first_name, last_name, DOB, start_date, end_date, date_borrowed, date_returned, ISBN, classification, date_bought)
Note:
(1) classification refers to classification of a book.
(2) Start_date and end_date refer to membership start and end dates.
Question:
Take the relation above and perform normalization to achieve 1NF,2NF, and 3NF. Write the output for all three stages. Assume that there are no repeating groups.
 Normalization: Library(call_no, member_id, first_name, last_name, DOB, start_date, end_date, date_borrowed, date_returned, ISBN,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!