Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
INSTRUCTION 1. 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. 2. You must simplify M: N relationships if any. 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.

INSTRUCTION 1. 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. 2. You must simplify M: N relationships if any. 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.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Please only answer homework question part a) asap please, thanks.

INSTRUCTION 1. 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. 2. You must simplify M: N relationships if any. 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. b) Each employee is associated with a single outlet but may be moved to an alternative outlet as required. Even if that is the case, the database records the current Outlet where the employee works, not the historical data. c) NDM retains data on dependents for those employee members who have dependents. The data stored on dependents include the dependent ID, name of the dependent, relationship to the staff, sex, and date of birth. d) 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. e) 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. f) 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). g) An employee dispenses drugs prescribed by Doctors to clients/patients. h) Represent the complete set of requirements in one ER diagram.
Transcribed Image Text:INSTRUCTION 1. 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. 2. You must simplify M: N relationships if any. 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. b) Each employee is associated with a single outlet but may be moved to an alternative outlet as required. Even if that is the case, the database records the current Outlet where the employee works, not the historical data. c) NDM retains data on dependents for those employee members who have dependents. The data stored on dependents include the dependent ID, name of the dependent, relationship to the staff, sex, and date of birth. d) 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. e) 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. f) 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). g) An employee dispenses drugs prescribed by Doctors to clients/patients. h) Represent the complete set of requirements in one ER diagram.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS