Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw data models for the following situations. In each case, think about the names you give each entity: I. Farmers can own cows or share

Draw data models for the following situations. In each case, think about the names you give each entity:

I. Farmers can own cows or share cows with other farmers.

II. A track and field meet can have many competitors, and a competitor can participate in more than one event.

III. A patient can have many physicians, and a physician can have many patients.

IV. A student can attend more than one class, and the same class can have many students.

V. The Marathoner, a monthly magazine, regularly reports the performance of professional marathon runners. It has asked you to design a database to record the details of all major marathons (e.g., Boston, London, and Paris). Professional marathon runners compete in several races each year. A race may have thousands of competitors, but only about 200 or so are professional runners, the ones The Marathoner tracks. For each race, the magazine reports a runners time and finishing position and some personal details such as name, gender, and age.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions