Sign In
Not register? Register Now!
Essay Available:
Pages:
4 pages/≈1100 words
Sources:
4 Sources
Style:
APA
Subject:
Health, Medicine, Nursing
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 19.44
Topic:

The Removal of Functional Dependencies and Normalizations

Essay Instructions:

Based on the feedback received on your Topic 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table).
Modify the database by adding an additional column ("Deleted_Date") to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph. In addition, explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.
Please refer to assignment in order # 00083489. Please try not to use references older than 10 years old.

Essay Sample Content Preview:

Database Schema
Author Name
Institution Affiliation
Entities
All of the ten tables/entities (including the required information) are associated with nine relations and are based on the E-R Diagram. The attributes of these tables/entities are shown in the table below.
Paycheck
Chk_Num, Salary, Bonus, Pay_Date
Doctor
D_Name, D_Ssn, Gender, Age, Position, Phone, Address, Office, City, Zip
Diagnosis
Diagnosis_Id, Category
Patient
P_Name, P_Ssn, Gender, Age, Position, Phone, Address, Office, City, Zip
Invoice
Invoice_Num, Amount, Invoice_Date, Due_Date
Medicine
MInventory_Id, M_Name, Manufacturer, Price, Quantity, Exp_Date
Insurance
InsCo_Id, InsCo_Name, Category, Phone, Address, City, Zip
Payment
Invoice_Num, PayTrans_Num, Pay_Method, Pay_Status, Paid_Date
CPT
CPT_Id, Category
Prescription
Prescription_Id, Medicine_Quantity
Relational Model
On the basis of functional dependencies of these relations, we have normalized the relations and then converted the E-R model into a relational model. Below, we have shown it precisely.
Doctor (D_Ssn, D_Name, Gender, Age, Position, Office, Phone, Address, City, Zip)
Paycheck (D_Ssn, Chk_Num, Salary, Bonus, Pay_Date)
Patient (D_Ssn, P_Ssn, P_Name, Gender, Age, Position, Phone, Address, City, Zip)
Insurance (InsCo_Id, InsCo_Name, Category, Phone, Address, City, Zip)
PatientInsurance (P_Ssn, InsCo_Id)
Invoice (P_Ssn, Invoice_Num, CPT_Id, Diagnosis_Id, Prescription_Id, Amount, Invoice_Date, Due_Date)
Payment (Invoice_Num, PayTrans_Num, Pay_Method, Pay_Status, Paid_Date)
CPT ( CPT_Id, Category)
Diagnosis (Diagnosis_Id, Category)
Prescription (Prescription_Id, Med_Quantity)
Medicine (MedInventory_Id, Med_Name, Manufacturer, Price, Quantity, Exp_Date)
PrescriptionMedicine (Prescription_Id, Medinventory_Id)
Functional Dependencies
The functional dependencies can be understood from the table below.
...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

You Might Also Like Other Topics Related to cell phone:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!
Order Now