Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: kenneth e. kendall, julie e. kendall

8th Edition

135094909, 013608916X, 9780135094907, 978-0136089162

More Books

Students also viewed these Databases questions

Question

1 Distinguish between strategic planning and tactical planning.

Answered: 1 week ago

Question

When are open-ended questions appropriate for use in interviewing?

Answered: 1 week ago