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 Statements For Hospital Management Systems
Homework Solution
$60.00
Computer Science
SQL Statements
Database Development
Tables
Hospitals
Medication
Attributes
Physicians
Panic
Dates
Names
Patients
Records
Database Development Questions
Homework Solution
$115.00
Computer Science
Database Development
Tables
Constraints
Elements
Digits
Data
Shipping Company
Packages
Forms
Objects
Aggregation
Association
Normal Forms
SQL
Queries
Database Development Problems
Homework Solution
$25.00
Computer Science
Database Development
ERWIN
ER Diagram
Meetings
Companies
Employees
Bank Accounts
Departments
Transactions
Lines
Database Development Problems
Homework Solution
$75.00
Computer Science
Database Development
Procedures
Employees
Tables
Parameters
Statements
Cursors
Salaries
Dates
Discounts
Prices
Get help from a qualified tutor
Live Chats