Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create an Entity-Relationship Diagram (ERD) using the Crow's Foot Notations. The ERD must include the following: * PK * FK * Types of relationships (1:1,
Create an Entity-Relationship Diagram (ERD) using the Crow's Foot Notations.
The ERD must include the following:
* PK * FK * Types of relationships (1:1, 1:M, M:N???)
* Mandatory or Optional Relationships
* Cardinality
Table: Employee | |||||||||
PK | FK | FK | PK | ||||||
EmpID | EmpName | Hire Date | PositionID | PositionDesc | DeptID | DeptName | Dependent ID | DependentDOB | DependentRelation |
101 | Juan Rivera | 12/02/2000 | 1 | President | 10 | Corporate | 1 | 05/10/1970 | Spouse |
101 | Juan Rivera | 12/02/2000 | 1 | President | 10 | Corporate | 2 | 1/14/2000 | Son |
101 | Juan Rivera | 12/02/2000 | 1 | President | 10 | Corporate | 3 | 1/14/2000 | Daughter |
102 | Mike West | 04/15/2010 | 2 | Controller | 20 | Budgeting | 1 | 11/11/1985 | Spouse |
102 | Mike West | 04/15/2010 | 2 | Controller | 20 | Budgeting | 2 | 10/11/2012 | Son |
103 | Gita Phogat | 10/10/2010 | 3 | Staff | 30 | Finance | 2 | 03/06/2013 | Son |
103 | Gita Phogat | 10/10/2010 | 3 | Staff | 30 | Finance | 3 | 07/11/2015 | Daughter |
104 | Mary Lamb | 01/31/2017 | 3 | Staff | 40 | IT | 1 | 09/09/1990 | Spouse |
Table: Employee_Dependents | |||||||||
PK | PK,FK | ||||||||
Dependent ID | DependentDOB | DependentRelation | EmpID | ||||||
1 | 05/10/1970 | Spouse | 101 | ||||||
2 | 1/14/2000 | Son | 101 | ||||||
3 | 1/14/2000 | Daughter | 101 | ||||||
1 | 11/11/1985 | Spouse | 102 | ||||||
2 | 10/11/2012 | Son | 102 | ||||||
2 | 03/06/2013 | Son | 103 | ||||||
3 | 07/11/2015 | Daughter | 103 | ||||||
1 | 09/09/1990 | Spouse | 104 |
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