ERD Page - 1Please complete reading page 1 before going to page 2.Represent the company description as an ER-diagram, including all relevant constraints as thefollowing steps:should use Lucidchart to draw the ERDFor each entity name in the ERD the student should concatenate hisUniversity ID as the example below (in Red)messen d-BIVANT LIDNameAfter each entityname include youruniversity ID numberDepartment0190334Page - 2Dep IDIDEmployee019033420Zawhen you createprint screen, youruser ID should beshownNameA company makes items. Each item has a name, ID and component quantity.Every item contains many components. Each component can be supplied by oneor 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 allsuppliers provide components, and a component is not always associated with asupplier. 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 sellthem items. A customer can buy one or more items.

Answered: Represent the company description as an…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

ERD

Page - 1
Please complete reading page 1 before going to page 2.
Represent the company description as an ER-diagram, including all relevant constraints 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)
messen d
-BIVANT L
ID
Name
After each entity
name include your
university ID number
Department
0190334
Page - 2
Dep ID
ID
Employee
0190334
20
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.

Expert Solution

Step 1

ER-Diagram:-

Data structure diagrams (DSDs), which emphasize interactions between elements within entities rather than relationships between things themselves, are linked to ER diagrams. ER diagrams are frequently combined with data flow diagrams (DFDs), which depict the information flow for systems or processes.

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions