Wellmeadows Hospital Case Study Er Diagram Online


Do you need help with with essay, research paper, homework or even dissertation?

Visit our website - https://goo.gl/HKbmHS (assignmenthelp24.com)





=================>>>CLICK HERE<<<=================
=================>>>CLICK HERE<<<=================
=================>>>CLICK HERE<<<=================


goo.gl
goo.gl


=================>>>GET ASSIGNMENT HELP<<<=================
=================>>>GET ASSIGNMENT HELP<<<=================
=================>>>GET ASSIGNMENT HELP<<<=================




scientific essay topic
essays and aphorisms schopenhauer pdf download
zamyatin's we a collection of critical essays on the scarlet
outline essay structure
khudi na bech essay contest
1000 word essay on being late in the army
essay on the poem phenomenal woman
lamar university academic partnership admissions essay
jasmine bharati mukherjee essay outline
of mice and men coursework questions
career aspirations banking essay
df wallace essays
dutch ruppersberger committee assignments wiki
free essays topics for kids
diwali essay in hindi short
compare and contrast essay model
dissertation outline template quantitative easing
industrialization case study manchester pdf file
read think write essay rubric example
a good dissertation abstract
wellmeadows hospital case study er diagram for library
short essay format answers yahoo
aiou solved assignments spring 2015 code 1423 n
define writing techniques for essays
public transportation benefits essay writing
mito t35 fantasy bibliography
rab2 6 rs of critical thinking
onkyo essay sr-556c
case study 2 power consumption in computer systems solution
I Need Help Writing My Personal Statement need help with my math homeworknow
unit 5 biology essay papers
case study scientific method definition of steps
the sims 3 university homeworks
online kinetics homework
zarb e azb essay definition
pacifica graduate institute dissertations and the ses
beautiful losers cohen analysis essay
black boy essay written by student
pyc1502 assignment 1 answers
assignment supply and demand paper xeco 212 week 7
cloning free essays
format essays college
difference between journal article and essay organizer
the odyssey extra credit assignments
essay on participation of women in politics
essays on help the needy
republican liberty and compulsory voting essays
the gift of the magi theme essay checklist
wallace stegner essayscorer
essay opening line
essay word limit-10100
burak bulut dissertation
writing prompts for a descriptive essay
accounting and finance cover letter placement on a guitar
good sports article titles in an essay
is starting an essay with a question bad
deca I Need Help Writing My Personal Statement case study tips
classical argument example about smoking essays on poverty
phillip lopate essays on education
essays on race and racism
the chicago manual of style bibliography format
india first country before self essay slogans for student
dark energy I Need Help Writing My Personal Statement dissertation mass effect 3 review
summary of freud's essay on the uncanny
phantom assignments glitch
turning point of civil war essay
inventor refuses to sign assignment discovery
uses and a buses of science essay conclusion
I Need Help Writing My Personal Statement arboretum primary school derby head teacher personal statement
a photo essay on the bombing of hiroshima and nagasaki atomic bomb
sitwell junior school head teacher personal statement
polsis essay guide 2012 gmc
haiti earthquake case study geology in australia
essays on jane eyre and wide sargasso sea
good introductory phrases for essays
everyday use essay by alice walker
creative and critical thinking games and activities
wuthering heights essay free
french bibliography websites apa
my dream school bus essay definition
marketing 205 unit 3 assignment
smoke signals movie analysis essays on ads
hochswender essay
sea cadet bmr assignment 4 answers to guess
did i do my homework lyrics big
nageh allam physics 111 homework
introductory words or phrases for essays on music
william trevor bibliography creator
laude san pedro homework help
cahsee essay prompts 2014 super
cat 2005 paper solved assignment
nyu admissions essay 2012 presidential candidates
how would you describe yourself as a person essays
free essay writing practice
bhopal the city of lakes essay writing
an evaluative essay on current conceptions of effective leadership
writing essay my idol game
gideon v wainwright essay checker
help me do my assignment
sandy fluvial systems assignment
nats 1840 assignment management
negley farson bibliography chicago
persuasive essays samples middle school
ford motor company business case study
aphrodite of melos essay definition
idleness is the root of all evil essay
how to write an in class essay well
15 years from now essay
zero carbon homes case study
lektorat dissertation erlaubt ist
vitenskapsteori essay topics
essay writing tutorial tagalog movies
informal reflective essay ideas
sanskrit essays myself
68 pin vhdci pin assignment
raksha bandhan essay in hindi 200 words I Need Help Writing My Personal Statement related
nicci french bibliography generator
hospital housekeeping resume cover letter
ap english language composition exam sample essays
ils se sont essays
essay on money is the root cause of all evil i deem
polynesian language similarities essay
metropolitano hospital serra essay
metamathematical argumentative essay
stock ticker orbital comparison essay
how to buy a research paper online
aaiche sanskar essay typer
master s essay templates
why do i need a university education essay
earl brink scholarship essay
writing an introduction for an essay.ppt
works cited references bibliography generator
dissertation theme
azazel isaac asimov bibliography
how to write a literature review for a nursing dissertation
francis bacon essay of studies sparknotes the great
early marriage short essay example
apocalypse now heart of darkness essay sample
mcs 052 assignment solution cs201
aspiration essay
400 blows essays
martin baxmeyer dissertation definition
how to talk about your hobbies in a personal statement
5th grade research paper guidelines apa
I Need Help Writing My Personal Statement essay best holiday ever
ged social studies essay format
history homework sheets ks2
mng2601 assignment 1/2012kgf gold
illustration by example essay about my mother
josh hamilton essay


P1: Mission statement and Objectives of Database Application System

The purpose of database application system assignment is to organize, manage and store large amounts of data in organizations.

To ensure integrity and consistency of data, database management and database application system performs some vital functions:

  • Transaction Management
  • Security Management
  • Back up and recovery
  • Data integrity management
  • Multiuser Access Control
  • Database Access Languages
  • Data Storage Management
  • Transaction Management : This says that, all transactions must follow ACID properties and must be completed in entirety or not started at all.

ACID stands for Atomicity, Consistency, Isolation and Durability.

Atomicity:  All tasks of the transaction must be performed or transaction must not be started at all, this means that a transaction must not remain in incomplete state otherwise it will make database incorrect.

Consistency: The database must remain in consistent state before the transaction starts and after the transaction is over, whether the transaction is successful or not. This implies that a database must show value which is a whole number, it must not be in fractions.

Isolation: Two transaction, occurring simultaneously in a system cannot access or view each other at a time. This implies, that transactions cannot  are not accessible in intermediate state. This is required to maintain consistency in database.

Durability: When the transaction gets completed successfully, the results must persist and not get undone by any kind of disaster like natural calamity or system crash.

  • Security Management: Only authorized users who have proper login credentials can access the database. This is important to safeguard database against malicious and unidentified access.
  • Back up and recovery: This measure is required to protect the database in case of persistent problems like power outage. Backup and Recovery function of database ensures that how long the database management system takes to bring back the system in its original state.
  • Data integrity management: To reduce data redundancy and maximize data consistency is the rule that is enforced by database application system, ensuring that resulting database returns same answers that is intended.
  • Multiuser Access Control : Without affecting the integrity and consistency of the database, the ability of multiple users to access the database at same time.
  • Database Access Languages : A non-procedural language like SQL is used which gives the facility to easily manage the database transactions like insertion, deletion, updation of database. It is simple and can be learnt by naïve users easily.
  • Data Storage Management or data dictionary management: When any data is requested by end user it is fetched from database management system or DBMS. DBMS removes the data and structural dependency and provides end user with abstracted version of data, which is lot easier to read, understand and implement.

The objective of database application system is to serve as an organized means of keeping track of database like Wellmeadows Hospital.

Mission and Objectives of Wellmeadows Hospital

Mission statement : To provide cost effective and accessible healthcare services all over United Kingdom.

Objective statement : To provide world’s best healthcare services to elderly people, treating illness in compassionate way.

The database application system will allow the end users to search various entities and their corresponding relationship.

This database will enhance proper functioning of hospital, and will help hospital staff to keep track of various activities easily.

This will also allow to develop an organized check-in and check-out system and help to keep a check on various staff members, patients and doctors. Also see Features of Database Management System.

A centralized database will ease the work of patients, doctors, and all hospital staff members, to check various transactions, hospital supplies, inpatient and outpatient status, and attendance of various members of staff.

P2: ER Diagram for Wellmeadows Hospital :

Above ER Diagram for Wellmeadows hospital shows following operations:

  • Suppliers supply Wellmeadows Hospital with pharmaceutical, surgical and non-surgical supplies.
  • Hospital has a medical officer who manages various supplies (pharmaceutical, surgical and non-surgical)
  • Hospital has a personnel officer who particularly looks towards staff and its operations.
  • Staff has hospital consultants and charge nurses etc.
  • Patients take appointments via hospital consultants.
  • Doctors treat patients and prescribe medication.
  • Patients can be inpatient or outpatient.
  • There are wards in the hospital which has respective staff.

P3: Relational Database for Wellmeadows Hospital

We will discuss relational database for Wellmeadows Hospital. The tables with their respective attributes and constraints are as follows:

TableAttributeConstraints
SupplierSupp_idPrimary Key
Supp_name
Supp_street
Supp_city
Supp_phone
Supp_fax_no
StaffStaff_idPrimary Key
Staff_fname
Staff_lname
Staff_street
Staff_city
Staff_dob
Staff_gender
Staff_nin
Staff_phone
Staff_salary_scale
Staff_salary
Staff_position
Staff_work_exp_start_date
Staff_work_exp_end_date
Staff_org_name
Staff_date_of_qualification
Staff_qualification_type
Staff_institution_name
Staff_employment_contract
DoctorDoc_idPrimary Key
Doc_fname
Doc_lname
Doc_clinic_no
Doc_street
Doc_city
Doc_phone
PatientPat_idPrimary Key
Pat_fname
Pat-lname
Pat_street
Pat_city
Pat_registration_date
Pat_dob
Pat_gender
Pat_appointment_no
Pat_next_of_kin_fname
Pat_next_of_kin_lname
Pat_next_of_kin_relationship
Pat_next_of_kin_phone
MedicationBill_noPrimary Key
Pat_fnameForeign Key
Pat_lnameForeign Key
Pat_street
Pat_city
Drug_id
Drug_name
Med_Start_date
Med_end_date
Unit_per_day
Method_of_adm
WardWard_idPrimary Key
Ward_name
Location
No_of_beds
Phone_ext_no
Pharmaceutical SuppliesDrug_idPrimary Key
Drug_name
Drug_desc
Reorder_level
Cost_per_unit
Drug_dosage
Method_of_administration
Quantity_in_stock
Non_surgical_suppliesNon_surgical_supplies_idPrimary Key
Non_surgical_supplies_name
Non_surgical_supplies_desc
Quantity_in_stock
Reorder_level
Requisition_FormRequisition_form_idPrimary Key
Drug_idForeign Key
Drug_name
Drug_desc
Cost_per_unit
Drug_dosage
Date_of_ordering_drug
Method_of_administration
Drug_quantity_required
Ward_id
Ward_name
Staff_idForeign Key
Staff_name

Read about Catering Database Management.

Relationships between various entities:

The relationships and corresponding entities with cardinality constraints are as follows:

RelationshipEntity 1Entity 2Cardinality
SuppliesCharge NurseRequisition_form1:N
Supplied bySupplierSuppliesM:N
Gives appointmentHospital consultantpatient1:N
Treated byPatientDoctorN:1
PrescribeDoctorMedication1:N
ManagesPersonnel officerStaff1:N
ManagesMedical officerStaff1:N
ManagesMedical officerBed1:N
ManagesMedical officerSupplies1:N
HasHospitalMedical officer1:1
HasHospitalPersonnel officer1:1
HasStaffWardM:N

References :

  • Generalization, Specialization and Aggregation [Online]. [Accessed on 25 November 2014]. Available on world wide web: <http://www.studytonight.com/dbms/generalization-and-specialization.php>
  • Entity Relationship Modeling [Online]. [Accessed on 25 November 2014]. Available on world wide web: <http://www.databasedesign.co.uk/bookdatabasesafirstcourse/chap3/chap3.htm>
  • DBMS Functions- Database Management [Online]. [Accessed on 25 November 2014]. Available on world wide web: <http://databasemanagement.wikia.com/wiki/DBMS_Functions>
  • Introduction to database systems [Online]. [Accessed on 25 November 2014]. Available on world wide web: <http://www.cse.buffalo.edu/~bina/cse462/lectures/lec1/sld001.htm>
  • What is Database Management System [Online]. [Accessed on 25 November 2014]. Available on world wide web: <http://education-portal.com/academy/lesson/what-is-a-database-management-system-purpose-and-function.html>
  • Database ACID properties [Online]. [Accessed on 26 November 2014]. Available on world wide web: <http://www.lightwolftech.com/index.php?page=backgrounders>

Programming Assignments Helpis the best assignment help provider in the United Kingdom. Our online assignment writing help UK is especially dedicated for the students studying in all UK colleges and universities. Submit assignmentto get the best quality assignment help.

Database AssignmentDatabase Management Systems Assignment

0 comments

Leave a Reply

Your email address will not be published. Required fields are marked *