Question
Draw an Entity Relationship Diagram (ERD) of the proposed Barwon Health Prescription System based on Crow's Foot notation using a professional drawing tool Based on
Draw an Entity Relationship Diagram (ERD) of the proposed Barwon Health Prescription System based on Crow's Foot notation using a professional drawing tool Based on the below scenario,
Prescription System for Barwon Health, Geelong The prescription branch of Barwon Health is facing a rising cost and looking into ways that could help reduce operational cost. It has been decided that a new database system is needed. You have been hired to be their database consultant. After a few interviews with different stakeholders of the system, you gathered the followings. Patients who visited Barwon Health are identified by their unique identifier called UR Numbers. The system should also store patients' names, addresses, ages, contact details (email and phone) and their Medicare card numbers if available. Doctors on the other hand, are identified by their ID. For each doctor certified to make prescriptions, the system should also capture the doctor's name, contact details (email and a phone number), their specialty, and the years of experience they have in their area of specialization. Drugs are supplied by different pharmaceutical companies. Each company is identified by their name, address, and a phone number. For each drug, the system should record the trade name and the drug strength. If a pharmaceutical company is removed from the system, then all its product should also be removed from the database. Later, you also found out that every patient has a primary doctor, and every doctor is assigned to at least one patient. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. For each prescription, a date and a quantity are associated with it.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Entities Patients UR Number Name Address Age Email Telephone Federal medical insurance Card Number Specialists Specialist ID Name Email Telephone Stre...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started