Draw an ER model according to the below information. NOTE: Use a word or any website to
Question:
Draw an ER model according to the below information. NOTE: Use a word or any website to produce the diagrams. Dont use handwriting.
In ERD diagram:
1. Entity:
There are 6 Entity in this diagram: 1.Company 2. CEO 3. Department 4. Employee 5. Product 6. Carbon Transaction 2. Primary and Foreign Keys Primary keys in this ERD are: 1. CompanyName 2. c_lD (CEO id) 3. E_ID ( Employee id) 4. D_ID (Department ld) 5. PAD ( Product id) 6. T_ID ( Transaction id) Foreign key in this ERD are: 1 . The CompanyName act as a Foreign key in Table Department 2. The D_ID act as a Foreign Key in Table Product 3. The E_ID act as a Foreign key in Table Department 4. The C_ID act as a Foreign key in Table Employee 5. The D_ID act as a Foreign key in Carbon Transaction Table 6. The C_ID act as a Foreign key in Company Table
3. Other Attributes of Each Entity: For Company Entity: 1. Company Name : PK 2. Location 3. Contact Detail For CEO Entity: 1. CAD: PK 2. Name
3. Phone No 4. Email For Department Entity: 1. DAD: PK
2. Department Name 3. Location For Employee Entity: 1. Name
2. Surname 3. phoneNO 4. Email For Product Entity: 1. PID:PK 2. Description
3. Quantity
For Carbon transaction:
1. T_ID : PK
2. Date
3. Value
4. Relationship With Name: 1 . Each Company Consist Department 2. Each Company has CEO 3. Each Employee has CEO 4. Each Department has Employee 5. Each Department WorkOn Product 6. Each Carbon Transaction accounted For Department 5. Multiplicities: 1 . There is I:M multiplicity in between Company Entity and Department Entity. 2. There is 1:1 multiplicity in between Company Entity and CEO Entity. 3. There is I:M multiplicity in between Employee Entity and Department Entity 4. There is M:l multiplicity in between Product Entity and Department Entity 5. There is M:l multiplicity in between Carbon Transaction Entity and Department Entity 6. There is I:M multiplicity in between CEO Entity and Employee Entity
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel