CSE2DCX DB Normalization

Question 1

List three benefits of normalizing a relation.

Question 2

Define first normal form (1NF), second normal form (2NF), and third normal form (3NF).

Scenario for Questions 3-5

Consider the relation in answering the questions that follow. The relation is for a library which maintains the below relation to store details of books that have been issued to members. Each book has a unique ISBN number while the library may have multiple copies of a book with each having a separate book number (Book_No). The library maintains records of only the current loans.

Member_No Name Book_No ISBN_No Title Issued_Date
15 Silva 103 111111 Database Systems 15/08/2009
101 222222 Linux 15/06/2010
105 333333 OS 15/08/2009
106 444444 Hacking Explained 23/12/2009
102 555555 Mac OS X 15/08/2009
18 Perera 113 111111 Database Systems 12/12/2009
118 777777 Database Systems 2 10/05/2010
114 888888 Solaris 15/06/2010
112 333333 OS 20/04/2010
119 999999 Java SE 12/12/2009

Question 3

What is the current level of normalization in the above relation?

Question 4

Write the functional dependencies for the above table.

Question 5

Normalize the above database table up to third normal form (3NF) and show the relations. Intermediate steps are required for 1NF and 2NF. Use underline for primary key attributes.

Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.