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

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!