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 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
Get step-by-step solutions from verified subject matter experts
