Define the below key terms (25 points)

Data Model

Relationship

Business Rule

Constraint

Entity

Given the below business rule identify the relationship between the entities. (One to one, One to many, or many to many). The first one is filled in for you. (30 points)

For the Dragon Rider database a DRAGON is assigned to many RIDERS, a RIDER is assigned one DRAGON. One to Many

For the Car Service database, a CUSTOMER can own many CARS, a CAR is owned by one CUSTOMER.

In the Daycare Database, a CHILD can have many PARENTS, a PARENT can have many CHILDREN.

In the University Enrollment database, a STUDENT is assigned one FINANCIAL AID ACCOUNT. A FINANFICAL AID ACCOUNT belongs to one STUDENT.

In the Dragons database, a DEVICE is given one DEVICE ID, a DEVICE ID is assigned to one DEVICE.

A CUSTOMER can make many PAYMENTS, but each PAYMENT is made by only one CUSTOMER.

An EMPLOYEE is assigned to many PROJECTS. A PROJECT can be worked on by many EMPLOYEES.

What is data modeling? Why are data models important in the database design process? (10 points)

What are the four basic components of a data model? (10 points)

What three types of relationships exist? Give an example of each of the three types of relationships. (10 points)

How do you translate business rules into data model components? (10 points)