Create 2 tables based on

the

ER model shown below . Include all the

constraints in the CREATE TA

BLE statements. You should ha

ve only two

create Table statem

ents and no ALTER TABLE statements.

Name all

constraints except NOT NULLs

Use

the

column datatypes and sizes as indicated in

t

he ER model

ENO

and

DNO

are used to uniquely identify rows in these tables.

Each

E

mployee

must be assigned a

Departm

ent

, and no duplicate

department

names

are allowed.

Assign

commission default value 0 .

The Salary entered should be greater than zero

If the data is given in Gender coloumn, only

M

or

F

are acceptable

values

Each table should have 5 data records in them

Create and execute the SQL statements needed to enforce the data

relationships

among

these

tables.