Page

$1$

of $4$

Pragati Dharmale

CS $457$L LAB E$-$R DIAGRAM

Part $1$ :

Q$1$ to Q$8-3$ points each

Q$96$ point

Total : $30$

Part $2$ :

$5$ point each

Total $20$

Part $3$:

$12\mathrm{.}5$ points each

Total : $50$ points

Total Marks : $100$ points

NOTE :

$1.$ You can use any tool of your choice to draw ERDs.

Try to stick to a professional Tool though

$2.$ There are different ways to draw ERD $.$ Eg$.$ Chens notation $,$crow foot notation.

The one you practiced in the class was Crow Foot and Chen$$s notation.

For this Lab please follow the one that we discussed during the lecture.

You can refer to slides uploaded in the file section$-$ppt$.$

$3.$ Expectation : Clear ERD with cardinalities mentioned $.$

$4.$ Plagiarism or any similarity identified from anywhere will be graded as $0$

Pragati Dharmale

CS $457$L LAB E$-$R DIAGRAM

A horse has a registration number, name, type $($quarter horse or thoroughbred$),$gender, and trainer.

The heritage of every horse must also be maintained if the information is available. For example,

the mother $($dam$)$ and father $($sire$)$ should be recorded. It is also necessary to identify the offspring

of a given horse. A horse is always stabled at a specific barn at the race track. Each barn has a barn

ID and barn name.

Information about people involved in the horse racing business $($i$.$e$.,$ owners, trainers, and jockeys$)$

should be maintained. An identifier, name, address, and phone number should be maintained about

every person. If a person is a horse trainer, the database should indicate the horses trained by that

person. A horse trainer can train many horses, but a horse is only trained by one person.

A horse can have more than one owner. An owner can own more than one horse. Information is

always recorded about the most recent date and purchase price of a horse by its current owner$($s$).$

Owners must also record their percentage of ownership of a horse. For example, a horse could be

owned by three owners, where one owner has a $50\%$ share and the other two owners each have a

$25\%$ share. Every race track has a race schedule indicating the date of each race day and the list of

races for each race day. A race day typically has $10$ scheduled races, where each race has a race

number $($from $1$ to $10)$ and a purse. The purse is the amount of money awarded to the winner of

the race.

Every race has several entries. Each entry indicates the horse, jockey, and gate position of the

horse at the start of the race. After the race, the entry records the finishing position of the horse

$($first$,$ second, third, etc.$).$ Every horse and every jockey must be able to produce a history of the

races in which they have participated.

Hands$-$On Demonstration

Part $1$: Derive Entities and Attributes from a Text Description

Pragati Dharmale

CS $457$L LAB E$-$R DIAGRAM

$1.$ Document the entities that should be added to the diagram.

$2.$ Document possible attributes for the Horse entity based on the requirements scenario.

$3.$ Document possible attributes for the Barn entity based on the requirements.

$4.$ Document possible attributes for the Person entity based on the requirements.

$5.$ Document possible attributes for the Schedule entity based on the requirements.

$6.$ Document possible attributes for the Race entity based on the requirements.

$7.$ Document possible attributes for the Entry entity based on the requirements.

$8.$ Make a screen capture showing the ER diagram with four entities

$9.$ Make a screen capture showing the ER diagram with nine entities and their attributes for

the Darling Downs Race Track scenario