that consists of five tables. Primary keys are (BOLD and Italicized). Attributes with the same names in different tables are foreign keys. 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,
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.
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. Draw eligibly!!!
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.
Step by step
Solved in 2 steps with 2 images
