Part $1$: Data Modeling $-30$ marks

INSTRUCTION

Create a Crow's Foot ER diagram for each business rule. The diagrams should clearly

describe and identify each entity and show relationships. Show all cardinality, primary

keys, and foreign keys. Use verbs to name and clarify relationships. Show only the

attributes contained explicitly in the case$/$ business rules.

You should also make and document any reasonable assumptions where you feel the

case is vague, ambiguous, or missing data necessary to meet the requirements.

Simplify $M$:$N$ relationships, if any.

You may develop the diagram on paper. If so$,$ submit the scanned version. You may also

use any relevant software like Erwin.

Submit a PDF file only. Other file formats are not accepted.

Steps to do:

The requirements collection and analysis phase of the database design process has provided

the following data requirements for a company called Convenient Rentals, which rents out

vehicles $($cars and vans$).$

a$)$ Convenient Rentals has various outlets $($garages$/$offices$)$ throughout Niagara. Each

outlet has a number, address, phone number, fax number, and a manager who

supervises the garage operation and offices at each site. A manager is also an employee;

a manager may manage the same outlet more than once at different times. See question

b for data maintained on each employee. $(6$ Marks$)$

b$)$ The company maintains the following data on each staff: staff number, name $($first

and last name$),$ home address, home phone number, date of birth $($DOB$),$ sex, Social

Insurance Number $($SIN$),$ date joined the company, job title, and salary. Each staff

member is associated with a single outlet but may be moved to an alternative outlet

as required, and that location information is maintained for each staff member. $(6$

Marks$)$