Answered step by step
Verified Expert Solution
Link Copied!
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

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

Students explore these related Databases questions

Question

What is a journal entry?

Answered: 3 weeks ago

Question

What is the orientation toward time?

Answered: 3 weeks ago