entity relationship diagram, Database Management System

Assignment Help:

Ask questApollo Hospitals (AH) is a popular medical service provider in Oman. AH wants to
automate its business functions into an information system. The proposed information system
must be developed keeping in mind the following business rules. As part of this, you need to
analyse and develop an Entity Relationship model depicting the following various business
requirements and functionalities for the proposed Pharmacy Information System of AH.
Dr. Prathap Reddy, Chairman, is aware that other multi-specialty hospitals are coming up in a
big way and AH will face fierce competition from new healthcare systems. So, he has decided
to take all measures to always be ahead of others in the market. It is increasingly important to
AH that Reddy be able to analyse services rendered by AH and perception of patients more
thoroughly.
The Pharmacy places requests to the Purchase Department whenever it is in need of drugs.
Pharmacy is identified by unique id, name and telephone number. Purchase Department is
identified by a unique number. The other elements are phone number, manager. The Purchase
Department submits many orders or may not submit an order. An order is uniquely identified
by an id. The other elements of order are placement date, fulfillment date, received date, order
amount. An order consists of one or more drugs or items. A drug is supplied by one or more
supplier. A supplier supplies many drugs or may not supply a drug. Whenever a supplier
supplies a drug, AH wants to record the shipment details such as date of supply. The elements
of drug are unique id, name, type, manufacturer id, manufacture date, expiry date, batch
number, unit cost. A supplier is uniquely identified by id. The other elements of supplier are
name, address, phone number, email, location and track record.
a) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all
the entities, attributes of each entity including primary key, relationship between the
entities and cardinality constraints. State any assumptions necessary to support your
design.

b) For the task 2a, analyse and recommend how the proposed ER model could accommodate
the shipment and payments.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

entity relationship diagram, Database Management System

Related Discussions:- entity relationship diagram

#title., WHY SHOULD NULL IN A RELATION BE AVOID AS possible?

What is system log, What is system log? What are the entries? An...

What is a transaction? and how does it differs from update, wh

Project operation, The PROJECT operation The project operation is used t...

What is a security, What is a security? Securities are claims on financ...

Discuss along with examples about several types of er model, Discuss along ...

Create data base table apply key and functions, CREATE YOUR DATABASE TABLES...

Abap/4 program, It is not possible to make an ABAP/4 program, which having ...

Storage of database on hard disks, Storage Of Database On Hard Disks At...

What is datawarehousing, What is DataWarehousing? Subject-oriented, me...

Write Your Message!

Featured Services

Online Tutoring

Project Development

Exam Preparation

Course Help

Assignment Help

Popular Subjects

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT