Question: How to Normalize these Tables? 1NF, 2NF, and 3NF Data Dictionar Table Name FK reference Attribute Name Contents Type Required PK/FK table CUST ID F

How to Normalize these Tables? 1NF, 2NF, and 3NF Data Dictionar TableHow to Normalize these Tables? 1NF, 2NF, and 3NF

Data Dictionar Table Name FK reference Attribute Name Contents Type Required PK/FK table CUST ID F NAME L_NAME Number Y Character Y Character Y Customer ID First Name Last Name Customer Mobile Number Number Y Customer City Customer Area Customer address Book ID Book Title Author Name Publishing Year Employee ID Employee First Name Employee Last Name Employee Phone NumberNumber y Order ID Customer ID Book ID Author Name Employee ID Order Date PK Customers CUSTMOB CUST CITY CUST AREA CUST ADRS BOOK ID BOOK TITLE AUTH_NAME PUB YEAR EMP_ID EMP FNAME Character Y Character Y Character Y Number Y Character Y Character Y Number Number Y Character Y Character Y PK Books PK EmployeesEMP_LNAME EMPPHONE ORD ID CUST ID BOOK ID PK FK FK Number Y Number Y Number Y Character Y Number Y Number Y Customer Book Employee Orders AUTH NAME EMP ID ORD DATE FK Data Dictionar Table Name FK reference Attribute Name Contents Type Required PK/FK table CUST ID F NAME L_NAME Number Y Character Y Character Y Customer ID First Name Last Name Customer Mobile Number Number Y Customer City Customer Area Customer address Book ID Book Title Author Name Publishing Year Employee ID Employee First Name Employee Last Name Employee Phone NumberNumber y Order ID Customer ID Book ID Author Name Employee ID Order Date PK Customers CUSTMOB CUST CITY CUST AREA CUST ADRS BOOK ID BOOK TITLE AUTH_NAME PUB YEAR EMP_ID EMP FNAME Character Y Character Y Character Y Number Y Character Y Character Y Number Number Y Character Y Character Y PK Books PK EmployeesEMP_LNAME EMPPHONE ORD ID CUST ID BOOK ID PK FK FK Number Y Number Y Number Y Character Y Number Y Number Y Customer Book Employee Orders AUTH NAME EMP ID ORD DATE FK

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!