Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 FKStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started