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

Describe in brief about object oriented design, Describe about Object orien...

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

Determine the minimal set of functional dependencies, Determine the minimal...

Determine the minimal set of functional dependencies for the following data. This table is part of the OHSU database of extracurricular activities and tracks the DMICE band's co

Produce a logical database design for pharma, Using a database design appro...

Using a database design approach of your choice, produce a logical design for Pharma. 1) Your answer must consist of ONE the following: An entity-relationship (ER) diagra

Create table, What are the advantages of creating a table from existing tab...

What are the advantages of creating a table from existing table?

Define the unique constraints for the table client, Define the following co...

Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1

Differences between structured data and unstructured data, Explain the diff...

Explain the differences between structured data and unstructured data. Structured data are facts concerning objects and events. The most significant structured data are numeric

What is de-normalization, What is De-normalization? De-normalization is...

What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

Create a data flow diagram, For your chosen project, you need to identify t...

For your chosen project, you need to identify the current problem that you wish your project to solve.  Produce a Problem Statement.  The Problem Statement should explain the purpo

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