Convert data model to a set of virtual windows

Assignment Help Database Management System
Reference no: EM1367450

You are to design a prototype for a hospital management system.
Patients are treated in a single ward by the doctors assigned to them. Usually each patient will be assigned a single doctor, but in rare cases they will have two.

Heathcare assistants also attend to the patients, a number of these are associated with each ward.

Initially the system will be concerned solely with drug treatment. Each patient is required to take a variety of drugs a certain number of times per day and for varying lengths of time.

The system must record details concerning patient treatment and staff payment. Some staff are paid part time and doctors and care assistants work varying amounts of overtime at varying rates (subject to grade).

The system will also need to track what treatments are required for which patients and when and it should be capable of calculating the cost of treatment per week for each patient (though it is currently unclear to what use this information will be put).

1. Design a data model for this system
2. Convert the data model to a set of virtual windows
3. Apply appropriate Gestalts to the prototype to structure the information

Reference no: EM1367450

Questions Cloud

Illustrate what is economy aggregate consumption function : Illustrate what is economy's aggregate consumption function. Illustrate what is marginal propensity to consume for economy.
Determine supply and demand for labor : Many factors discuss the supply and demand for labor. Identify and describe two factors that would increase or decrease the demand for labor.
Changes in price of a key commodity : How would government react to sudden, large changes in the price of a key commodity, such as gasoline, electricity, or prices on stocks on the New York Stock Exchange?
Illustrate what will be monopoly cost : If industries collude, Illustrate what will be monopoly cost (optimal cost P*), total output of two industries (Q= q1 + q2) and total profits of two industries.
Convert data model to a set of virtual windows : You are to design a prototype for a hospital management system. Design a data model for this system, Convert the data model to a set of virtual windows.
Caring code in clinical nursing education : I'm analyzing a research article titled ' application and evaluation of a caring code in clinical nursing education' where the purpose of the study is to determine if a 'caring code'
Illustrate comparison over time of market values of outputs : Illustrate what problem is posed by any comparison over time of market values of various total outputs. How is this problem resolved.
At what two locations on x-axis is the potential zero : A woman on a 10 speed bicycle travels at 9 m/s relative to ground as a she passes a little boy on a tricycle going in the opposite direction. If the boy is travelling at 1m/s relative to the ground, how fast does the boy appear to be moving relati..
Find name and membership number of members : Find the name and membership number of members who have borrowed more than five different books of that publisher.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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