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

1 Expert Approved Answer
Step: 1 Unlock

Heres a description of the ERD for the given scenario Entities Person PersonID PK Name BirthDate Bio... View full answer

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!