Answered step by step
Verified Expert Solution
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...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