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
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, semifinished 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.
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
