Question: Draw an E-R diagram in Crow's Foot notation for the following scenario. You company buys items from vendors and sells them to customers. Attributes of

Draw an E-R diagram in Crow's Foot notation for the following scenario. You company buys items from vendors and sells them to customers. Attributes of item include Item-ID, description, and selling price Your company buys different quantities of items at different prices from vendors for example, 20 keyboards at $20 each from A vendor, 10 keyboards at $25 each from B vendor, etc. Your company also sells different quantities of items at the same price to customers. for example, 5 keyboards at $30 each to C customer, 10 keyboards at $30 each to D customer, etc. Attributes of vendor include: Vendor-ID, Vendor-Name, Location, Phone # Attributes of customer include: Customer-1 D, Customer-Name, Location, Phone # The ERDs you make look like the Tiny College ERD shown in Figure 4.35. That is: your ERD must show Draw an E-R diagram in Crow's Foot notation for the following scenario. You company buys items from vendors and sells them to customers. Attributes of item include Item-ID, description, and selling price Your company buys different quantities of items at different prices from vendors for example, 20 keyboards at $20 each from A vendor, 10 keyboards at $25 each from B vendor, etc. Your company also sells different quantities of items at the same price to customers. for example, 5 keyboards at $30 each to C customer, 10 keyboards at $30 each to D customer, etc. Attributes of vendor include: Vendor-ID, Vendor-Name, Location, Phone # Attributes of customer include: Customer-1 D, Customer-Name, Location, Phone # The ERDs you make look like the Tiny College ERD shown in Figure 4.35. That is: your ERD must show
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
