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
D_Ssn—> D_Name, Gender, Age, Position, Office, Phone, Address
Chk_Num—> Salary, Pay_Date
P_Ssn—> P_Name, Gender, Age, Phone, Address
D_Ssn, P_Ssn—> P_Name, Gender, Age, Phone, Address
InsCo_Id—> InsCo_Name, Phone, Address
PayTrans_Num—> Pay_Method, Pay_Status, Paid_Date
Invoice_Num, PayTrans_Num!Pay_Method, Pay_Status, Paid_Date
Diagnosis_Id —> Category
Prescription_Id—> Medicine Quantity
MInventory_Id—>M_Name, Price, Exp_Date Prescription_Id
select * from Doctor
select * from Paycheck
select * from Insurance
select * from Patient
select * from Diagnosis
select * from Prescription
select * from Medicine
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.
This is only a preview of the solution. Please use the purchase button to see the entire solution