Solution-Explain relational database design

Explain relational database design

Assignment Help Database Management System

Reference no: EM13335077

Relational Database Design

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.

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.

You need to write a 1-2 page report that addresses the following:

1. What are the specific problems associated with the current design and why do they arise?

2. How would you change the current design and how does your new design address the problems you have identified with the current design.

In order to receive high marks for this question, you will need to demonstrate an understanding of the theories discussed in Topics 1, 2 and 3, how they apply to his problem, and justify the changes you are making to the system. Simply providing the amended design (even if it is correct) will only attract a small percentage of the marks for this question.

Reference no: EM13335077

Questions Cloud

What are the different types of metrology used : 1) Write a brief essay discussing the significance and need for metrology in today’s global market place. What are the different types of metrology used and why are they important. This paper should be at least 4 pages double spaced although I expect..

Evaluate the ph at the equivalence point : Calculate the ph at the equivalence point for the following titration 0.20M HCl versus 0.20M methylamine (CH3NH2). The Ka of methylammonium is 2.3x10^-11.

Determine what must the risk-free rate be : A stock has an expected return of 14 percent, its beta is 1.90, and the expected return on the market is 10.5 percent. What must the risk-free rate be

What is the principal repayment on the 20th payment : To finance the purchase, you have arranged for a 30-year mortgage loan for 80 percent of the $2,800,000 purchase price. The monthly payment on the loan will be $22,000.

Explain relational database design : How would you change the current design and how does your new design address the problems you have identified with the current design.

Determine what is the total return on the investment : One year ago, Peyton purchased 3,600 shares of Broncos stock for $101,124. Today, he sold those shares for $26.60 a share. What is the total return on this investment if the dividend yield is 1.9 percent

What is the angular impulse on the basketball : Two children are playing a game. The rst throws a basketball straight up, and the second tries to hit it with a thrown baseball. What is the angular impulse on the basketball

By how much would aerelons shares be expected to fall : If Aerelon has 65 million shares outstanding, an equity cost of capital of 12%, and no debt, by how much would Aerelon's shares be expected to fall in price as a result of this accident

Integrated software application for patient records mgmt : Assume that you have been asked to procure a new integrated software application for patient records management.

User Account

All Pages

Explain relational database design

Reference no: EM13335077

Reference no: EM13335077

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT