Dept. Dept. # Name 11232 Soap Division 11232 Soap Division Location Mgr. Mgr. Tel Name ID Mary Samuel Extn. Cust. # Cust. Name No. Cincinnati Mary S11 7711 P10451 Robert Samuel Drumtree Cincinnati Date of Nature of Complaint Complaint 1/12/2012 Poor Service S11 7711 P10480 Steven 1/14/2012 Discourteous Parks Attendant
Convert the un-normalized table below to 3NF. Assume that the Dept. # and Cust. #
are both needed to uniquely identify the date and nature of the complaint about the
department.
Introduction of 3NF:
3NF (Third Normal Form) is a database normalization technique that is used to ensure that a database is organized in a systematic and efficient manner. It is a form of normalization that is used to reduce data redundancy and ensure data integrity by eliminating columns that do not directly depend on the primary key of a table. It also ensures that all non-key attributes are mutually independent.
3NF is an important concept in database design, as it ensures that data is organized in a way that is easy to understand and maintain. Additionally, it helps prevent data inconsistencies by ensuring that all data is stored correctly and efficiently.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
