Represent the company description as an ER-diagram, including all relevantconstraints as the following steps: should use Lucidchart to draw the ERD For each entity name in the ERD the student should concatenate his University ID as the example below (in Red) BIVAN DONNA ID Name After each entity name include your university ID number Department 0190334 Page - 2 Dep ID ID Employee, 0190334 B Za when you create print screen, your user ID should be shown Name A company makes items. Each item has a name, ID and component quantity. Every item contains many components. Each component can be supplied by one or more suppliers. Suppliers have names and IDS. Each component has ID, name, description, suppliers who supply them, and items in which they are used. Not all suppliers provide components, and a component is not always associated with a supplier. Also, a component always have to be associated with one or more items. Finally, the company contact customers using their IDs, Names and Phones to sell them items. A customer can buy one or more items.
Represent the company description as an ER-diagram, including all relevantconstraints as the following steps: should use Lucidchart to draw the ERD For each entity name in the ERD the student should concatenate his University ID as the example below (in Red) BIVAN DONNA ID Name After each entity name include your university ID number Department 0190334 Page - 2 Dep ID ID Employee, 0190334 B Za when you create print screen, your user ID should be shown Name A company makes items. Each item has a name, ID and component quantity. Every item contains many components. Each component can be supplied by one or more suppliers. Suppliers have names and IDS. Each component has ID, name, description, suppliers who supply them, and items in which they are used. Not all suppliers provide components, and a component is not always associated with a supplier. Also, a component always have to be associated with one or more items. Finally, the company contact customers using their IDs, Names and Phones to sell them items. A customer can buy one or more items.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter2: Data Models
Section: Chapter Questions
Problem 15P
Related questions
Question
ERD
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning