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 Leahy 437 REARDON 4/08/1989 20/7/2020 A012 Standard 56 D42433 Meuller 562 BILSTEIN 12/05/2001 20/7/2020 A013 Short 35 S55768 Leahy 361 WILSON 13/08/1997 20/7/2020 A014 Long 75 S55768 Leahy 895 LEMOS 13/10/1952 20/7/2020 A013 Short 35 D42433 Meuller 895 LEMOS 13/10/1952 20/7/2020 A014 Long 75 D42433 Meuller 678 MORTAL 27/02/1969 20/7/2020 A014 Long 75 S55768 Leahy 432 SOAPIER 1/08/1976 21/7/2020 A012 Standard 56 S55768 Leahy You have been asked to design a relational database for this system. You know that there are problems with the current design and that it will need to be modified in order to work effectively. What are the specific problems associated with the current design and why do they arise?( Illustrate define for problem (Insert/Delete/Update) the give example; Table-> Function dependency ->1nf/2nf/3nf-> the relation is … because…)

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	Leahy
437	REARDON	4/08/1989	20/7/2020	A012	Standard	56	D42433	Meuller
562	BILSTEIN	12/05/2001	20/7/2020	A013	Short	35	S55768	Leahy
361	WILSON	13/08/1997	20/7/2020	A014	Long	75	S55768	Leahy
895	LEMOS	13/10/1952	20/7/2020	A013	Short	35	D42433	Meuller
895	LEMOS	13/10/1952	20/7/2020	A014	Long	75	D42433	Meuller
678	MORTAL	27/02/1969	20/7/2020	A014	Long	75	S55768	Leahy
432	SOAPIER	1/08/1976	21/7/2020	A012	Standard	56	S55768	Leahy

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

What are the specific problems associated with the current design and why do they arise?( Illustrate define for problem (Insert/Delete/Update) the give example; Table-> Function dependency ->1nf/2nf/3nf-> the relation is … because…)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

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