IS 314 Database design and Management Homework 1
INSTRUCTIONS:
In order to complete this homework, draw the Diagram for the following description using ERDPlus or by hand and upload the images through Moodle.
- Create an entity based on the following requirement:
- For each doctor, we will keep track of a DoctorID (unique), DoctorLicense (unique, composed of LicenseNo and State), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school).
- Create the ER diagrams for a scenario based on these requirements:
- A health care organization keeps track of its doctors and outpatient locations. For each doctor it keeps track of the DoctorID (unique), DoctorName, and
- DoctorYearOfMDGraduation (year of graduating from medical school).
- For each outpatient location it keeps track of the OLID (unique) and OLName
Additional requirement
- Each doctor works at exactly one outpatient location, and each outpatient location has exactly one doctor working at it.
Subjects List
Database (48)
Accounting (39)
Economics (34)
Finance (54)
Programming (122)
Management (69)
Marketing (25)
Report Writing (52)
Engineering (79)
Statistics (39)
Business Studies(45)
Case Studies (15)
Networking (26)
UML (9)
Science (23)
Nursing (11)
MATLAB (17)
Psychology (6)
Math (20)
Data Structure (9)
Python (15)
HRM (25)
IT (21)
Computer Science (57)
Law (4)
Essay (3)
Data Analysis (2)
Big Data (3)
Philosophy (2)
History (1)