You will create 4 tables including their constraints in this lab following short business narrative and given descriptions of each entity.

All constraint (except NOT NULL) must have a proper name and for first three tables you will use Column Level method (Inline) and for the last (bridge) table you will use Table Level method (Outline) when assigning constraints.

Company provides programming services for its clients, so that programmers (or consultants) work on different projects for the same or different client.

Client may be associated with many projects, but a particular project is assigned to only one client. Client may or may not have associated projects, but a project must always have a matching client. Programmers (or consultants) may work on many projects at any given time (or none) and project will include many consultants (or at the initial stage none of them).

Here are Table Instance Chart descriptions:

CLIENT

Column Type NN / U PK Ref-Tab PK-Ref Check

Client_id Number(5) Y

Client_name Varchar2(20) NN, U

Client_address Varchar2(30)

Client_city Varchar2(10) NN

Client_prov Char(2) NN

Client_postal Char(6) NN

PROG

Column Type NN / U PK Ref-Tab PK-Ref Check

Prog_id Number(5) Y

Prog_name Varchar2(30) NN

Prog_office Char(4) NN

Prog_phone Char(10)

PROJECT

Column Type NN / U PK Ref-Tab PK-Ref Check

Project_id Number(6) Y

Proj_name Varchar2(40) NN, U

Complet_date Date

Total_cost Number(8,2) > 0

Client_id Number(5) NN CLIENT Client_id

PROJECT_STAFF

Column Type NN / U PK Ref-Tab PK-Ref Check

Prog_id Number(5) Y PROG Prog_id

Project_id Number(6) Y PROJECT Project_id

Week_Year Char(5) Y

Hours_worked Number(4,1) NN > 0

After creation of all tables you will DESCRIBE them all.