Design relational databases using normalisation

Assignment Help Database Management System

Reference no: EM132961581

CSI6207 Systems Analysis and Database Design - Edith Cowan University

Analysis and Modeling Report

Learning outcome 1: Apply appropriate data analysis and modelling concepts to meet specific business needs.
Learning outcome 2: Design relational databases using normalisation and entity-relationship modelling.
Learning outcome 3: Work collaboratively to develop and demonstrate a range of analysis, modelling and database tools.

Task: Your team's task is to prepare a requirements specification. ABC, like many firms, has a standard template which you must use for preparing this report (Microsoft Word template supplied separately). Please note that if you do not use this template, your work will not be assessed. For drawings, use MS Visio or any other UML diagram drawing tool. The information you need to create this report comes from the lectures/workshops (the techniques) and the problem statement (below).

Microsoft Visio (MS Visio) is a UML-based modelling tool for system analysis and design activities. The Microsoft Imagine program (which previously included MS Visio) is now Microsoft Azure Dev Tools for Teaching and Learning. To download and install MS Visio, please go to and sign in using your ECU credentials. All the Microsoft products including Visio (which we will be using for UML models) is available to download via this link. Please download and install Visio in your personal computer/laptop so that you can work on your assignment tasks. However, it is not mandatory to use MS Visio and you can use any other tool of your choice for creating UML diagrams (e.g. Lucid char, draw.io, visual paradigm).

Problem:
You are a junior system analyst at Company ABC and you are tasked to design a Medical Management System for a clinic.

A typical Medical Management System in a clinic is used by the receptionists, nurses, and doctors. The receptionists use the system to enter new patient information when first-time patients visit the doctor. They also schedule all appointments. The nurses use the system to keep track of the results of each visit including diagnosis and medications. For each visit, free form text fields are used to capture information on diagnosis and treatment. Multiple medications may be prescribed during each visit. The nurses can also access the information to print out a history of patient visits. The doctors primarily use the system to view patient history. The doctors may enter some patient treatment information and prescriptions occasionally, but most frequently they let the nurses enter this information. Each patient is assigned to a family. The head of family is responsible for the person with the primary medical coverage. Information about doctors is maintained since a family has a primary care physician, but different doctors may be the ones seeing the patient during the visit.

Attachment:- Analysis and Modelling Report.rar

Reference no: EM132961581

Questions Cloud

What are the main responsibilities of unions in singapore : What are the main responsibilities of unions in Singapore? Are they carrying out these responsibilities? Illustrate your answer by including answers to the foll

Transformational changes such as mergers and acquisitions : How could they reduce the challenges faced by employees during transformational changes such as mergers and acquisitions?

Prepare the necessary journal entries from transaction : The bonds pay interest annually on February 1 and mature on February 1, 2024. Prepare the necessary journal entries from transaction

Does bibby have a gender discrimination case : Delta Bibby had worked as a dental assistant in Dr. Harley Hayes's dental practice for three years. When Delta became pregnant, she approached Dr. Hayes about a

Design relational databases using normalisation : Design relational databases using normalisation and entity-relationship modelling and Work collaboratively to develop and demonstrate a range of analysis

Determine the total dividends paid to each class : Determine the total dividends paid to each class and the dividend per share to both common and preferred shareholders

What is the unit product cost using variable costing : Dude Company incurred the following costs while producing 600 units: direct materials, $12 per unit; What is the unit product cost using variable costing

Determine a union gains bargaining rights : In conclusion, what changes, if any, would you recommend be made to the framework used to determine if a union gains bargaining rights. Explain your answer. (th

Economic policy in the american government : What is the public process policy and economic policy in the American government?

User Account

All Pages