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 clarify relationships. Show only the attributes contained explicitly in the case/ business rules.

You should also make and document reasonable assumptions where you feel the case is vague, ambiguous, or missing data necessary to meet the requirements.

You must simplify M: N relationships, if any.

You may develop the diagram on paper. If so, submit the scanned version. Of course, you may also use any relevant software like Erwin

Steps to do:

The database design process's requirements collection and analysis phase has provided the following data requirements for a small neighbourhood pharmacy called Neighbourhood Drug Mart (NDM for short) that maintains and dispenses medications to patients.

a) NDM has various outlets throughout the Niagara Region. Each Outlet has a number, address, phone number and a manager who supervises the Outlet's operation at each site. Each Outlet maintains historical data about managers, such as who previously managed the Outlet. A manager is also an employee; a manager may manage the same Outlet more than once at different times. The Outlets record the following data on each employee, employee 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. (6 Marks)

b) Each employee is associated with a single outlet but may be moved to an alternative outlet as required. The Company maintains data on in which Outlet an employee worked and when. (6 Marks)

c) NDM allocates prescription drugs to each Outlet; however, it may move medicines between outlets as required. NDM maintains data on the movement of drugs between stores. A drug number uniquely identifies each drug. You may add additional characteristics/ attributes of a drug here. (6 Marks)

d) NDM has clients/patients. The data stored on clients include the client number, name (first and last name), home address, phone number, date of birth, and driving licence number. The client number uniquely identifies each client. (1 Marks)

e) NDM maintains data on Doctors that may prescribe medications to patients. NDM maintains the following data on each Doctor: physician ID (unique), name (first and last name), work address, phone number, and date of birth (DOB). (1 Mark)

f) An employee dispenses drugs prescribed by Doctors to clients/patients. (6 Marks)