User Account

All Pages

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.

Related Discussions:- entity relationship diagram

ER diagram , ER diagram on cosmetics

ER diagram on cosmetics

Fragmentation, Differentiate between horizontal & mixed horizontal fragment...

Differentiate between horizontal & mixed horizontal fragmentation?

Describe integrity and security, Describe integrity and security? a)   ...

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

Write the syntax of creating an index, Write the syntax of creating an INDE...

Write the syntax of creating an INDEX ? Syntax of Creating an Index: CREATE [BITMAP] [UNIQUE] INDEX ON ( [, ] . . .);

How the one-to-one associations have to be implemented, Discuss how the one...

Discuss how the one-to-one associations have to be implemented. Some of properties of associations can be implemented directly by providing suitable declarations of the data me

Hello, Java program for horrizontal fragmentation in distributed database

Java program for horrizontal fragmentation in distributed database

Increases efficiency-data fragmentation, Increases efficiency : Data is sto...

Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there

What are called index-sequential files, What are called index-sequential fi...

What are called index-sequential files? The files that are ordered sequentially with a primary index on the search key are known as index-sequential files

What is a super key, What is a super key? A super key is a set of one o...

What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.

What is bankers algorithm, What is banker's algorithm?  Banker's algori...

What is banker's algorithm?  Banker's algorithm is a deadlock avoidance algorithm that is applicable to a resource-allocation system with multiple instances of each resource ty

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd