Question: Exercises Draw data models for the following situations. In each case, make certain that you show the attributes and feasible identifiers. Show relationships and cardinalities.

Exercises Draw data models for the following situations. In each case, make certain that you show the attributes and feasible identifiers. Show relationships and cardinalities.

a.A farmer can have many cows, but a cow belongs to only one farmer.

b. A university has many students, and a student can attend at most one university.

c. An aircraft can have many passengers, but a passenger can be on only one flight at a time.

d. A nation can have many states and a state many cities.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!