Question: 5 - You are given below a database table in 1 NF . table [ [ customerID , productID,City,PlateNo,Qty ] , [ M 1

5- You are given below a database table in 1NF.
\table[[customerID,productID,City,PlateNo,Qty],[M145,U1,Denizli,20,100],[M145,U2,Denizli,20,150],[M151,U2,Tokat,60,75],[M149,U3,Samsun,55,200],[M148,U1,Tokat,60,140]]
Apply the rules to normalize the given table such that all tables are in 3NF.(20 pts.)
5- You are given below a database table in 1NF. \table[[customerID,productID,City,PlateNo,Qty],[M145,U1,Denizli,20,100],[M145,U2,Denizli,20,150],[M151,U2,Tokat,60,75],[M149,U3,Samsun,55,200],[M148,U1,Tokat,60,140]]

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!

Q:

QUESTION 1 In a table containing data about people, the property "First Name" would be an example of: 1. A Row 2. A Table 3. A Database 4. A Column QUESTION 2 A many to many relationship in the...

Q:

HI there, so the project is complete. But could you please provide diagrams for this project, also include screenshots. Project Title: E - Commerce Database for Online Retail Store Project Overview:...

Q:

Database principles create three sql scripts and three E-R diagrams 1. The Henry Books Store Considering the normalized data tables created in assignment#5b do the following tasks. a. Using MySQL...

Q:

Plz provide the code and remove it 2 days after u have posted as I don't want to share it with others and copy what I have written. Don't remove it before 2 days. al-1docx/?justUnlocked=1#question...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

here is the table structure DROP TABLE Order_line_t CASCADE CONSTRAINTS ; DROP TABLE PRODUCT_t CASCADE CONSTRAINTS ; DROP TABLE ORDER_t CASCADE CONSTRAINTS ; DROP TABLE CUSTOMER_t CASCADE CONSTRAINTS...

Q:

Describe the purpose of a nondisclosure agreement and the purpose of a noncompete agreement.

Q:

Review the PMBOK Guide (PMI, 2017), Part 1, Section 12317 regarding Control Procurement Process Discuss the Enterprise Environmental Factors (EEF) that can influence the Control Procurement process...

Q:

A line passes through the point ( 3 , - 1 2 ) and has a slope of 7 . Find the equation of this line. y = 7 x 9 y = 3 x 1 9 y = 7 x 3 3 y = 3 x 5

Q:

Discuss several ways ( at least four ways ) to improve the requirement process and thus, a project team can avoid a situation where too many changes to the project requirements occur at the later...

Q:

Understand the actual and perceived hazards of personal relationships in the workplace

Q:

Be able to differentiate between the formal documentation that is required and the informal documentation that is optional but helpful

Q:

Appreciate the legal implications of employment documentation