Question: Draw a dependency relational schema diagram for this data. You may assume the following: Each material item has one or more suppliers. Each supplier may
Draw a dependency relational schema diagram for this data. You may assume the following:
Each material item has one or more suppliers. Each supplier may supply one or more items or may not supply any items.
The unit price for a material item may vary from one vendor to another.
The terms code for a supplier uniquely identifies the terms of the sale eg code means percent net days The terms for a supplier are the same for all material items ordered from that supplier.
b Decompose this diagram into a set of diagrams in NF
c Draw an ER diagram for this situation.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
