The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. You may assume the data are representative.PATIENT IDPATIENT NAMEPATIENT DOBCONSULT DATEITEM NUMBERITEM DESCRIPTIONFEEPROVIDER NUMBERDOCTOR NAME437REARDON4/08/198919/7/2020A012Standard56S55768Scott437REARDON4/08/198920/7/2020A012Standard56D42433Mueller562BILSTEIN12/05/200120/7/2020A013Short35S55768Scott361WILSON13/08/199720/7/2020A014Long75S55768Scott895LEMOS13/10/195220/7/2020A013Short35D42433Mueller895LEMOS13/10/195220/7/2020A014Long75D42433Mueller678MORT27/02/196920/7/2020A014Long75S55768Scott432SOAPIER1/08/197621/7/2020A012Standard56S55768Scott You have been asked to design a relational database based on this design. You know that there are problems with the current design and that it will need to be modified in order to work effectively.You need to write a report that addresses the following:What are the specific problems associated with the current design and why do they arise (about ½-1 page)?How would you change the current design and how does your new design address the problems you have identified with the current design.

Step 1:- Note:- I am giving the solution to the 1 question only. The given question contains the…

Answered: The following question is based upon…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. You may assume the data are representative.

PATIENT ID	PATIENT NAME	PATIENT DOB	CONSULT DATE	ITEM NUMBER	ITEM DESCRIPTION	FEE	PROVIDER NUMBER	DOCTOR NAME
437	REARDON	4/08/1989	19/7/2020	A012	Standard	56	S55768	Scott
437	REARDON	4/08/1989	20/7/2020	A012	Standard	56	D42433	Mueller
562	BILSTEIN	12/05/2001	20/7/2020	A013	Short	35	S55768	Scott
361	WILSON	13/08/1997	20/7/2020	A014	Long	75	S55768	Scott
895	LEMOS	13/10/1952	20/7/2020	A013	Short	35	D42433	Mueller
895	LEMOS	13/10/1952	20/7/2020	A014	Long	75	D42433	Mueller
678	MORT	27/02/1969	20/7/2020	A014	Long	75	S55768	Scott
432	SOAPIER	1/08/1976	21/7/2020	A012	Standard	56	S55768	Scott

You have been asked to design a relational database based on this design. You know that there are problems with the current design and that it will need to be modified in order to work effectively.

You need to write a report that addresses the following:

What are the specific problems associated with the current design and why do they arise (about ½-1 page)?
How would you change the current design and how does your new design address the problems you have identified with the current design.

Expert Solution

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions