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

Entity database, what is entity in database system?

what is entity in database system?

What is primary index, Primary Index In primary index, there is a one-t...

Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

Define integrity, (a) Explain briefly the three parts of a relational Model...

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

Central database schema, Consider an information system designed for an onl...

Consider an information system designed for an online company which provides IT products and services. These include desktops, laptops, networking products, IT books, parts, and te

Write short notes on relational model, Write short notes on relational mode...

Write short notes on relational model   The  relational  model  uses a  collection of  tables  to show  both data  and the relationships between those  data.  The relational mo

Process of implementing system design in dynamic models, Process of impleme...

Process of implementing system design in dynamic models There are three essential approaches to implementing system design in dynamic models. These approaches are as below:

Find out employee who draws salary more than average , Normal 0 ...

Normal 0 false false false EN-US X-NONE X-NONE

Example of weak entity, Consider the entity type dependent related to emplo...

Consider the entity type dependent related to employee entity, which is used to keep track of the dependents of every employee. The attributes of dependents are: name, sex, birth d

Describe the benefits of OOD techniques, Describe the benefits of OOD techn...

Describe the benefits of OOD techniques OOD techniques are very useful for development of large and complex systems. It has been noted that large projects that are developed u

Explain hierarchical model, Explain Hierarchical Model ? Hierarchical ...

Explain Hierarchical Model ? Hierarchical Model - It was established to model several kinds of hierarchical organizations which exist in the real world. It uses tree structur

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