Plzzzzzz heeelllp me plzzzz !!!

Database ...

I want Table Creation:

Using SQL statement, we created XX tables as follows:

? PHARMACY: (This is an Example)

CREATE TABLE Pharmacy

(

PNumber

char(11)

Check (PNumber >000 AND PNumber

PPhone

char(7)

not null,

PAddress

varchar(40)

not null,

PRIMARY KEY (PNumber));

2.and i want Database State:

We insert some values into the database in order to test our SQL create view and query statement.

? INSERTION OF TABLE Pharmacy: (This is an Example)

--------------------------------------------------------------------------------------------------------

insert into Pharmacy

values ('003', 2148759, 'Building#3, King Fahd road, Olaya ',

------------------------------------------------------------------------

3. Table Screenshot:

Here list all your table instance/data, after the insertion process take screenshot from each table.

Query Implementation:

Here give out the SQL views and queries. For each one; write the view/query statement that you selected then write its SQL solution.

1- Retrieve the names of companies who haven't manufactured any drugs. (This is an Example)

SELECT?Cname

FROM?Company

WHERE?NOT EXISTS ( SELECT *

? FROM Drug

? WHERE Cname=PCname);

You have to create two views and eight queries. Choose them from the list then indicate their implementation and results. Note: The values on the blue color can be change according to the entered data

PameDoll PERSON EMPLOYEE PHYSICIAN PATIENT FOR NURSE STAFF TECHNICIAN RESIDENT OUTPATIENT SCHEDULED VISIT wORKS-IN LABORATORY N NURSE IN CHARGE TO EER Diagram for Healthway Hospital CARE CENTER CONTAI BED PROVIDED