Derive a set of relational tables from the er diagram

Assignment Help Data Structure & Algorithms
Reference no: EM13922332

Scenario:
Assume that the chief operating officer ofthe clinic has contacted you to create a conceptual model whose application will meet the expecteddatabase requirements for the clinic. The officer gives you the description of the clinic's operatingenvironment. Any patient can make any number of appointments with one or more doctors in the clinic,and a doctor can accept appointments with many patients. However, each appointment is made withonly one doctor, and each appointment references a single patient. Emergency cases do not require anappointment. However, an emergency is entered into the appointment book as "unscheduled" forappointment management purposes. If kept, an appointment yields a visit with the doctor specified inthe appointment. The visit yields a diagnosis and, when appropriate, treatment. Each visit updates thepatient's records to provide a medical history.

Each patient visit creates a bill. Each patient visit is billedby one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may bepaid off in many installments, and a payment may cover more than one bill. A patient may pay the billdirectly, or the bill may be the basis for a claim submitted to an insurance company. It is expected that ifthe bill is paid by an insurance company, the deductible is submitted to the patient for payment.

Propose a conceptual model after an in-depth research on clinic information management system'soperations and processes. In order to come up with an appropriate design/solution, you must study therequirements, issues and best practices in this problem context. You can make relevant assumptionsrequired to formulate business rules, security, administration and modelling.

Based on the above information execute Task 1, Task 2 and Task 3. You may have to make additional assumptions to execute Task 1, Task 2 and Task 3.

Task 1:

Design an Entity Relationship Diagram (ERD) to model the above scenario. Identify the different entities and attributes of each entity. (A minimum of 8 entities need to be identified). Suggest and justify the choice of relationship and cardinality of the relationship. State the assumptions (if any) made by you to develop the ERD based on your research. Provide detailed analysis and justification for the selection of entities and attributes based on your research.

Task 2:

Derive a set of relational tables from the ER diagram (Task 1), using appropriate choices for the tableattributes. List the integrity rules and business rules, which you would recommend to ensure the qualityof data. Indicate all necessary key constraints. Critically analyze the constraints and business rules basedon your study of the clinic.

Task 3:

Outline the kinds of anomalies that can arise in the scenario given above by using un-normalized tables. Show how the table created in task 2 could be re-organised into separate tables to avoid anomalies (Decompose the table structures to a set of 3NF tables).

Task 4:

As a database administrator identification of specific roles for users, authentication policy,storage management and database recovery are critical. The efficiency and complexity of databaseadministration depends on the identified strategy and tools. Propose and critically review usermanagement, backup/recovery strategy, storage management/techniques formulated for the systemdiscussed in Task 1-3.

Reference no: EM13922332

Questions Cloud

Internet search using the term break-even analysis : Perform an Internet search using the term break-even analysis. Select and read a case study or article from the results of your search.
Enhance knowledge of organizational : Critically evaluate information from core business functions and the value chain to enhance knowledge of organizational strategic position and direction.
What is meant by the law of agency in the united states : What is meant by the "law of agency" in the United States? And how does this law relate to health care - What is meant by "cloning?" Do you feel that there is a role for cloning in human health care? Why or why not?
Problem regarding the personal model of helping : Write a 2,100- to 2,800-page paper on your personal model of helping. Incorporate learning from this course and discuss how and why you have, at this point in your development, formed your viewpoints. Include:
Derive a set of relational tables from the er diagram : Outline the kinds of anomalies that can arise in the scenario given above by using un-normalized tables. Show how the table created in task 2 could be re-organised into separate tables to avoid anomalies
Social psychologists investigate how we view ourselves : This is a formal research paper 8-10 pages in length. Imagine that this will be used as a reference for someone who is completely unfamiliar with social psychology principles. This paper will provide them with an overview of the field, and expla..
What types of leaders are required in dangerous occupations : What types of leaders are required in dangerous occupations - How do emergency response leaders differ from public policy leaders? Explain
Oriel company expects to use : If Oriel Company expects to use 100,000 machine hours, the predetermined overhead rate is $2. 00 per machine hour.If Oriel Company expects to use 75,000 machine hours, the predetermined overhead rate is $1. 50 per machine hour.
When should manager reorder to achieve desired probability : When should the manager reorder to achieve the desired probability? Why might the model not be appropriate if seasonality were present?

Reviews

Write a Review

Data Structure & Algorithms Questions & Answers

  Implement an open hash table

In this programming assignment you will implement an open hash table and compare the performance of four hash functions using various prime table sizes.

  Use a search tree to find the solution

Explain how will use a search tree to find the solution.

  How to access virtualised applications through unicore

How to access virtualised applications through UNICORE

  Recursive tree algorithms

Write a recursive function to determine if a binary tree is a binary search tree.

  Determine the mean salary as well as the number of salaries

Determine the mean salary as well as the number of salaries.

  Currency conversion development

Currency Conversion Development

  Cloud computing assignment

WSDL service that receives a request for a stock market quote and returns the quote

  Design a gui and implement tic tac toe game in java

Design a GUI and implement Tic Tac Toe game in java

  Recursive implementation of euclids algorithm

Write a recursive implementation of Euclid's algorithm for finding the greatest common divisor (GCD) of two integers

  Data structures for a single algorithm

Data structures for a single algorithm

  Write the selection sort algorithm

Write the selection sort algorithm

  Design of sample and hold amplifiers for 100 msps by using n

The report is divided into four main parts. The introduction about sample, hold amplifier and design, bootstrap switch design followed by simulation results.

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