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

Database Development Questions
Homework Solution
$25.00
Computer Science
SQL
Database Development
Suppliers
Parts
Catalog
Business
Tables
DBMS
Names
Addresses
Queries
Statements
Test Results
Average Costs
Prices
Finance
Management
Pet Store Database
Homework Solution
$60.00
Computer Science
Database Development
Pet Store
Tables
Records
Columns
Headers
Queries
Reports
Employees
Finance
Profitable Products
Inventory Quantity
Transactions
Costs
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
Get help from a qualified tutor
Live Chats