Draw the corresponding ERD. You can do this at the end of this Word Doc. if you need more space, or use a different tool and upload and extra file, or upload two Word Doc. files (this one and the ERD). You can also NEATLY hand draw it and upload a picture of it. 3.2) Identify all relationships in the ERD that you created in part 3.1. For each relationship, identify the relationship connectivity (cardinality)
Question 3
Consider the following relational schema that consists of five tables. Primary keys are (BOLD and Italicized). Attributes with the same names in different tables are foreign keys.
For time and speed on the Exam the address and name attributes are just one column each.
Person (driver_id, LastName, FirstName, EmailAddress, license, dateOfBirth)
Car (license, model_id, color, report_num, trim)
Accident (report_num, date, location)
Model(model_id, description, year)
PersonInsuranceCompany(driver_id, insurance_company_id, policy_issue_date)
InsuranceCompany(insurance_company_id, name, EmailAddress)
3.1) Draw the corresponding ERD. You can do this at the end of this Word Doc. if you need more space, or use a different tool and upload and extra file, or upload two Word Doc. files (this one and the ERD). You can also NEATLY hand draw it and upload a picture of it.
3.2) Identify all relationships in the ERD that you created in part 3.1. For each relationship, identify the relationship connectivity (cardinality) and write a business rule to describe the relationship.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
