Question: need solution for part 6 with examples from the code provided on page 2 LISTED BELOW NULL, CREATE TABLE STAFF ENUM DECIMAL (12) NOT NULL

LISTED BELOW NULL, CREATE TABLE STAFF ENUM DECIMAL (12) NOT NULL / Staft employee number FNAME VARCHAR(50) NOT NULL, 1. First se LNAME VARCHAR(50) NOT NULLA / Last name DOR DATE Date of birth CONSTRAINT STAFF_PKEY PRIMARY KEY (EUR): CREATE TABLE DRIVER ENUM DECIMAL (12) NOT NULL, Statt ployee 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 FREY FOREIGN KEY CENTIM) REFERENCES STAFF LEBUH). CONSTRAINT DRIVER STATUS CHECK STATUS IN "AVAILABLE IN SERVICE", "ON LEAVE"> CREATE TABLE TRUCK REGNUM VARCHAR(10) NOT NULL, Registration number CAPACITY DECIMAL (7) NOT NULL Capacity WEIGHT DECIMAL (7) NOT NULL Weight STATUS VARCHAR(10) NOT NULL Present states CONSTRAINT TRUCK PKEY PRIMARY KEY (REGNUM), CONSTRAINT TRICK_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
