Question: apply the normalization rule based on the FD's to ensure that the following table achieve the 3NF and re-design the table based on that. then

apply the normalization rule based on the FD's to ensure that the following table achieve the 3NF and re-design the table based on that. then draw the functional dependency diagram before and after acheiving the 3NF, and what it will be happened if the table below doesn't acheive the 2NF

item_Shipment table

sup_name	Item_name	price	qty	deptno	dname
Ali	laptop	400	10	10	sales
Ali	CD	20	10	10	sales
Ahmed	CD	20	20	20	programming
Salim	book	20	20	10	sales

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!

with out table just column names Given the Customer_Orders table that shows the details of orders that ordered by customers, the product included in each order, answer the below questions...

just column names Given the Customer_Orders table that shows the details of orders that ordered by customers, the product included in each order, answer the below questions Customer_Orders Table...

Assignment 1. You recognize that the existing table structure is very poor and need to improve it. Given what you see in the table above, a) Draw a dependency diagram. Identify the possible primary...

Draw table for each part. (B) Normalize the following table to 3NF and show the results of each normal form using the "listing dependencies" notation as shown in "Listing Dependencies.docx". State...

7. Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members,...

Please help with this SQL Oracle lab. At least with part of it. ---------------------------------------------------------------------------------------- Normalization and Creating Tables (For this...

A non - profit organization operates a number of events to raise money for its continued operation. They keep track of who attended the event and how much each person donated, if anything. The...

A levered firm has only 2 assets on its balance sheet with the below market values and CAPM betas. The risk free rate is 3% pa and the market risk premium is 5% pa. Assume that the CAPM is correct...

In what sense does the argument for ethical egoism based on economics support not egoism but utilitarianism? In other words, the view that we ought to do what is in the best interest of all or the...

Do you think Tournament Sporting Goods is having a problem financing its growth? Is the increase in dividends a good idea for the company?

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Identify behavior that constitutes sexual harassment, and list things that an organization can do to eliminate or minimize it. page 125

Identify the tasks performed and the skills required in a given job. page 167

Identify the major provisions of the Occupational Safety and Health Act (1970) and the rights of employees that are guaranteed by this act. page 130