Question: Can someone please help me with these 3 problems? I'm very confused and don't understand this. You just have to use the tables provided. Thank

Can someone please help me with these 3 problems? I'm very confused and don't understand this. You just have to use the tables provided. Thank you in advance.

Can someone please help me with these 3 problems? I'm very confused

and don't understand this. You just have to use the tables provided.

3. Indicate the changes (using the shorthand representation) that you would need to make to the original TAL Distributors database design in the event that the original Requirement 3 is changed as follows. For an item, store the item's number, description, category, and price. In addition, for each storehouse in which the item is located, store the number of the store- house, the description of the storehouse, and the number of units of the item stored in the storehouse. Draw an E-R diagram for the new design. 4. Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. ITEM (ITEM NUM, DESCRIPTION, ON HAND, CATEGORY, STOREHOUSE, PRICE, ORDER NUM, ORDER DATE, CUSTOMER NUM, CUSTOMER NAME, NUM ORDERED QUOTED PRICE)) 5 Indicate the changes you need to make to the TAL Distributors database to support the fol- lowing additional requirement. Each storehouse has a manager who is identified by a man- ager number, a manager last name, and a manager first name

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!