Database Final Project | IUG | Each drug is sold by only a drug Company, for each drug, the trade name and formula must be recorded

DBProject

Each drug is sold by only a drug Company, for each drug, the trade name and formula must

be recorded

the trade name identifies the drug uniquely from the product of the Company

Each drug Company is identified by name and has a phone number

Each patient has only one doctor, each doctor has at least one patient ,

Patients are identical by an SSN and their names, address, and ages are recorded

doctors are identified by SSN, name.

for each doctor, the name specialty and years of experience must be recorded.

each pharmacy sells several drugs, a drug can be sold at several pharmacies, each pharmacy

has a name, address, phone number.

Each pharmacy sales several drugs and has price.

for each, a drug can be sold at several pharmacies and the price is different from pharmacy to

another.

Doctors prescribe (suggest) drugs for patients. A doctor could prescribe one

or more drugs for several patients. Each prescription has a date and a

quantity associated with it

A drug company have contract with pharmacies.

and a pharmacy can contract several drug companies. For each contract you have to store a

start date, end date and the text for contract.

Grading Criteria:
You should submit a .zip file with your ID containing these files inside:
1- Your ER diagram as image (.PNG) using Visual Paradigm.
2- A text file that contains the whole code for the database.
Read Carefully:
WARNING: This is an individual project; you must solve it by yourself.
Any form of cheating will result in receiving ZERO in the project.

Q1:
Write SQL statement to create the following tables and then after create table, take
screenshot for the screen to describe the structure of table and the SQL statement for
creation this tables (so we must submit 2 pictures for each table).

Q2:
Write SQL statements to perform the following tasks (you must submit 2 pictures, one
for statement and second for result: