Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

To create an Entity-Relationship Diagram (ERD) based on the metadata you provided for your video rental store database, follow these steps: Step 1: Identify Entities From your metadata, the entities...

Q:

Introduction This assignment allows students to demonstrate their skills in the area of designing relational databases to satisfy specific business rules and requirements. The deliverables for this...

Q:

Project 1 Details: In this project you will be provided with a description of an application (below) to create an entity-relationship diagram (ERD) and design accompanying table layout using sound...

Q:

INFOAP2 Database Design Study Block Project The University Boole Library Database Modelling Project The University Boole Library has approximately 19,000, members, 200,000 book titles, and 500,000...

Q:

In this project you will be provided a set of specifications to create an entity-relationship diagram and design accompanying table layout using sound relational modeling concepts and practices. The...

Q:

1. A color-coded Word document with each entity and its related attributes colored in a matching font. For instance, in the narrative, if you have a customer entity with name and address details,...

Q:

Intro to Database Management Project 3 Start Assignment Due Thursday by 11:59pm Points 100 Submitting a file upload File Types vsdx, pdf, xlsx, and docx Attempts 0 Allowed Attempts 3 Available Dec 6...

Q:

Use this data model to complete the following tasks. 1. Transform the data model to physical model (database design). Note: a. Draw the entity-relationship diagram (ERD) in Crows foot notation using...

Q:

these are clearer pics of Q3 and Q4 QUESTION 1 You are helping a homestay rental company to develop a new database. Below is the collected information about the company: - They are the middleman...

Q:

Please refer to Case #11 Tiny College Motor Pool) below. Please create an entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and...

Q:

Evaluating a companys economic health and stability is just as important as evaluating their performance. Economic health metrics should provide insight into the strength of a companys Balance Sheet....

Q:

If concrete compression test fails, should Schmidt hammer test be adopted as an alternative test to prove the concrete strength?

Q:

when conducting on an audit service engagement involving agreed upon procedures, what level of assurance if any will be provided on the work performed?

Q:

Question 38 Not yet answered Marked out of 1 P Flag question The geometrical arrangement of electron pairs of CIF, is: a. Square planar b. Trigonal bipyramidal OOOO c. T shape d. Octahedral

Q:

4. Development road map: Descriptions of development activities that should occur at each career level and that support development needs and prevent derailers. These activities include job...

Q:

3. Development needs: Needs that frequently occur at each career level, those that vary by individual, and the derailers that can stall career progress and negatively affect performance. Ways to...

Q:

4. Learning Labs: These five-day in-class workshops build on the learning acquired during the previous phases of e-learning. The workshops emphasize peer learning and the development of a learning...