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

Explain the disadvantages of using dbms, Explain the disadvantages of using...

Explain the disadvantages of using DBMS There could be a few disadvantages of using DBMS. As DBMS requires computers, we have to invest a good amount in acquiring the hardwa

What is multiplicity in the associations, What is multiplicity in the assoc...

What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For

How is concurrency identified, How is concurrency identified? Concurren...

How is concurrency identified? Concurrency in objects can be identified by the way they alter their state. Current objects can change their state independently. Aggregation imp

Describe the concept of aggregation, Aggregation Aggregation is strong...

Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp

Evaluate the null hypothesis, 1.Suppose you are given a dataset that consis...

1.Suppose you are given a dataset that consists of a random sample of tasters, on which the following variables were obtained: (y) Zpref = taste preference for green beans store

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

CREATE YOUR DATABASE TABLES Your database project must have a minimum of four tables. Include the SQL scripts used to create the tables in your documentation. Explain the tables

In an e-r diagram how attributes are represented, In an E-R diagram how att...

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

Name the metrics for selecting top algorithm, Name the metrics for selectin...

Name the metrics for selecting top algorithm There are a number of metrics for selecting top algorithm: i) Computational complexity: Computational complexity refers to eff

Explain what is to be done during defining problem statement, Briefly expla...

Briefly explain what is to be done during defining problem statement. To define Problem Statement of a system, define what is to be done and how you can go to implement that. Y

Write Your Message!

Captcha
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!

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