I wannt to trannslate the E-R design into SQL. I wannt to write tables.

Write an SQL script with the commands to create the tables of your database.

The CREATE TABLE statements must specify:

o Appropriate types for the attributes;

o The primary key;

o Constraints such as NOT NULL and UNIQUE whenever appropriate;

o Default values where appropriate; o FOREIGN KEY constraints, together with the policy for reacting to changes (remember that the default is ON DELETE NO ACTION)

Write comments into the script that explain the rationale behind the definition of your constraints.

if there is any errore in the ER, please fix it.

The Victim can be shot by many criminal,

And criminal can shoot many victims.

The Jail can be taken many criminals,

And criminal can send them to many jails.

The police can catch many criminals,

And criminals can be caught by many police.

The court can hand in the criminal by many police,

And many police can be handed in many criminals to the court.

The punishment is handed out by many courts,

And court can hand out one punishment.

please help me, I have spent many hours to do it, but I have faced many errors.

Address SSN Age SSN Name Address Name Victim Criminal N Send Catch Jail Address Number Address ld Court N hands in Police Address ID Hand Out Punishment Punishment Number Type Year