Question

Design and implement your own database. Your database must model a real-world situation of your choice, must have at least three tables, and must not be one of the sample databases discussed in class.

Create a database and tables that represent your design from previous Project. Be sure to represent your relationships as foreign keys or separate tables. Populate your database with sufficient data support interesting queries.

Hand in a script that creates your database and populates your tables with data. Hand in the output from SELECT queries that list the contents of each table.

Relation Functional Dependencies

Doctor               
D_Ssn—> D_Name, Gender, Age, Position, Office, Phone, Address
Paycheck         
Chk_Num—> Salary, Pay_Date

Patient         
P_Ssn—> P_Name, Gender, Age, Phone, Address
D_Ssn, P_Ssn—> P_Name, Gender, Age, Phone, Address

Insurance      
InsCo_Id—> InsCo_Name, Phone, Address

Payment      
PayTrans_Num—> Pay_Method, Pay_Status, Paid_Date
Invoice_Num, PayTrans_Num!Pay_Method, Pay_Status, Paid_Date

Diagnosis      
Diagnosis_Id —> Category

Prescription      
Prescription_Id—> Medicine Quantity

Medicine            
MInventory_Id—>M_Name, Price, Exp_Date Prescription_Id

Queries

select * from Doctor

select * from Paycheck

select * from Insurance

select * from Patient

select * from Diagnosis

select * from Prescription

select * from Medicine

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Database Development Questions

This is only a preview of the solution. Please use the purchase button to see the entire solution

Assisting Tutor

Related Homework Solutions

SQL Server for Business Intelligence
Homework Solution
$23.00
SQL
Server
Business
Intelligence
SSAS
Data
Mining
MDX
DAX
Role
Named
Multidimensional
Model
Analysis
Services
Holdout
Set
Lift
Chart
Prediction
Query
Named
KPI
Calculated
Column
Measure
Tabular
Row
Filter
Context
BI
Database Developments & SQL Queries
Homework Solution
$20.00
Computer Science
Database Development
Relationships
SQL Queries
MS Access
Relational Schema
Referential Integrity
Books
Authors
Orders
Sales
Data Sets
Tables
DMV Service Fees
Homework Solution
$50.00
Computer Science
Database Management
Tables
VB Codes
Outstanding Fees
Registration
Multiple Services
Companies
Business
Finance
Invoice
Charges
Operations
Database Management Systems
Homework Solution
$20.00
Databases
Computer Science
SQL
Keys
Farmers
Cows
Physicians
Patients
Records
Tables
Car Dealer
Prices
Sales
Profit
Students
Data Structures
Data Mining and Warehouse Assignment
Homework Solution
$20.00
Flight
Data
Warehouse
OLAP
Dimension
Fact
Table
Cube
Operation
Business
Time
Arrival
Star
Schema
Doctor
Patient
SQL
Query
Relational
Database
Departure
Traveler
Roll-up
Select
Get help from a qualified tutor
Live Chats