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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started