Question: NEED ANSWER ASAP CREATE TABLE STAFF ENUM DECIMAL (12) NOT NULL, /* Staft employee number ENAME VARCHAR (50) NOT NULL, First name LNAME VARCHAR (50)

CREATE TABLE STAFF ENUM DECIMAL (12) NOT NULL, /* Staft employee number ENAME VARCHAR (50) NOT NULL, First name LNAME VARCHAR (50) NOT NULL, Last name DOR DATE NULL, Date of birth CONSTRAINT STAFF_PKEY PRIMARY KEY (ENUM)); CREATE TABLE DRIVER ( ENUM DECIMAL (12) NOT NULL, Staff employee number LNUM DECIMAL (8) NOT NULL, Driving license number STATUS VARCHAR(10) NOT NULL Driver status CONSTRAINT DRIVER_PKEY PRIMARY KEY (ENUM), CONSTRAINT DRIVER UNIQUE UNIQUE (LNUM). CONSTRAINT DRIVER FKEY FOREIGN KEY CENUM REFERENCES STAFF (ENUM), CONSTRAINT DRIVER STATUS CHECK STATUS IN AVAILABLE", "IN SERVICES, ON LEAVE'>> ): CREATE TABLE TRUCK REGNUM VARCHAR(10) NOT NULL, Registration number CAPACITY DECIMAL (7) NOT NULL, 1. Capacity WEIGHT DECIMAL (7) NOT NULL, Weight STATUS VARCHAR(10) NOT NULL, 1. Present status CONSTRAINT TRUCK_PKEY PRIMARY KEY (REGNUM), CONSTRAINT TRUCK_STATUS CHECK STATUS IN ("AVAILABLE", USED", "MAINTAINED' ) ), CONSTRAINT TRUCK_WEIGHT CHECK ( WEIGHT > 0.0 AND WEIGHT 0.0 AND CAPACITY
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
