Question: 1 . As you continue to work with data and designing relational databases you will note some common patterns. The following ERD diagram represents a

1. As you continue to work with data and designing relational databases you will note some common patterns. The following ERD diagram represents a common generic structure used to represent a business which sells products.
One piece that this ERD is missing is information about where the organization gets their products from. Products (raw materials, semi-finished goods, and trade goods) are ordered from vendors. Enhance the ERD below to reflect which vendor a product is ordered from. Add an entity for Vendor and keep track of the Vendor Name, Contact Name, Phone Number. Your enhanced ERD should reflect the relationship between PRODUCT and VENDOR, with primary keys and foreign keys added.
1 . As you continue to work with data and

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 Programming Questions!