Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ERD for the below scenario with cardinality: The ERD is for a database about families. The entities provided are Person (primary key is

Draw an ERD for the below scenario with cardinality: The ERD is for a database about families. The entities provided are Person (primary key is PersonID), Car (primary key is CarRegoNo), and Dog (primary key is DogID). You will need to add one or more entities and you may need to add attributes to some of the entities provided to indicate foreign keys. The ERD should indicate romantic relationships between any two people and the type of partnership (e.g. married, defacto, engaged, going out). The database should also record when the relationship started and when it ended. Use "started" and "finished" for the names of these attributes. Over time a person may be involved in several relationships. Sometimes, people break up and get back together again. The ERD should indicate that every person has at most one biological father and every person has at most one biological mother. The mother/father of some people may not be recorded in the database. To indicate these parental relationships between people, you will need to add one or more attributes to the person table - use meaningful names. A car must be owned by one person. A dog must be owned by someone and may be owned by many people. Do not include many to many relationships.

Step by Step Solution

3.52 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

Heres a description of the ERD for the given scenario Entities Person PersonID PK Name BirthDate Bio... 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

Step: 3

blur-text-image

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions

Question

Explain the core principle of the MapReduce algorithm.

Answered: 1 week ago