Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Analysis and design techniques:

A case study accompanies this assignment. It describes the requirement for a system within a business context. This is an outline of a draft brief. You will need to make assumptions in the course of constructing your models. Ensure you submit a list of these assumptions with your assessment elements as appropriate.

The case study will be used for all element(s) of the assignment.

You are required to submit the following:

1) A state model for a suitable class. Try and show as much detail as possible (actions; guard conditions; activities as appropriate)

2) A sequence diagram for a suitable use case. Show both user actions and system responses.

3) An updated class diagram (submitted in assignment 1), that shows how operations you have identified as a result of the sequence diagram in (2) have been allocated to various classes.

4) A report and description (maximum – 1500 words)

Provide supporting evidence of your discussion by citing appropriate references.

Case Study:

LH Medical Company (LHM):

LHM is a London based privately owned hospital which provides healthcare to its patients. The hospital uses in-house software to manage and service its patients which they refer to as clients. It is an expanding venture and needs to accommodate for processing its information globally. The practice management system is web enabled and multi-platform for connectivity via web services, in addition it has connectivity to existing legacy systems.  An enterprise document management system ensures patient documents are replicated globally and available per demand.

In addition to medical treatments, medicine and drugs, consultation and vaccinations are offered to its patients (with a variable additional fee) the company offers medical instruments to other companies either to purchase or to lease.

LHM records the details of its clients with possibly their full medical history in their computer system. When a new patient requests an appointment (walk-in or on-line) a treatment course begins and a practitioner is allocated to the patient. A full history and previous medical records are printed showing different categories of Treatments during different time intervals.  Analyses are drawn in terms of any possible allergies and previous histories. Treatments may involve many surgeons and consultants depending on its complexity.

The contact practitioner is responsible for estimating the costs of treatments that is agreed by the client at the start of the treatment. The duration of the treatment may be set at any time duration and may also be changed during the treatment depending on the complexity of possible operations. The final cost and completion date are recorded at the end of the treatment.

During a treatment process notifications may be sent to patients and other practitioners.

Repeat prescriptions may automatically be produced by the system if appropriate and are available for collection at any surgery by the patient. At any time a practitioner may suspend or cancel the prescriptions.

The cost for a treatment is paid for by the client or an insurance policy provided by a number of insurers. Insurance policies may have additional surcharges and costing depending on treatment types and medicines. Long term treatment courses may be edited or cancelled by practitioners or clients. To re-start an existing treatment an additional fee is applied.

LHM may receive requests for specialise treatments from other hospitals or they may refer clients to other medical centres.

Each treatment course or service may include one or more of the following items:

• Operations and vaccinations
• Consultations and check-up
• Medicine and different types of tablets
• Clinical reports and attached documents and history
• Prescriptions and repeat Prescriptions

A treatment course comprising services from other hospitals carry additional changes set by the medical service providers. A full list of Treatment courses may be requested by the site manager at any time. 

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9742

Have any Question? 


Related Questions in DBMS

Problem 1 please create a plsql procedure to print out the

Problem 1: Please create a PL/SQL procedure to print out the reservation ID, checkin date, and checkout date of reservations made by a guest. The input parameters is the name of the guest. There is no output parameter. P ...

1 analyse situations andor environments for the application

1) Analyse situations and/or environments for the application of database solutions including web connectivity 2) Create, alter and remove relational tables, indexes and data using an appropriate database language. 3) Ex ...

Assignmentcreate a simple excel spreadsheet with data to

Assignment Create a simple excel spreadsheet with data to update the database. 1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database (you can link the spreadsheet manually using the wiz ...

Option simulation preparation paperby the end of module 2

Option : Simulation Preparation Paper By the end of Module 2, you will have received the URL, team name (also known as logon ID), and password for the Littlefield Simulation site from your instructor. This week, you must ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Database in-class assignment normalizationfor the following

Database In-class Assignment Normalization For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF. Movie Rating Showtime Theater The SpongeBob Movie PG 4:00 ...

Graph databases assignment1choose a social network that you

Graph Databases Assignment 1. Choose a social network that you use. Say, FaceBook, Twitter, LinkedIn, or anything else. 2. Design a model to store and manage relationship data from these social networks in a graph databa ...

The strayer oracle server may be used to test and compile

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multina ...

Enterprisebim projectgoal - to enable students to

Enterprise/BIM Project Goal - To enable students to experience the process of building a non-trivial database-backed web application. Tasks 1. Choose any area that interests you - this does not necessarily have to be abo ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen