Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedHow 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started