Need 4 questions done I need question 3, 4, 5 and 6I need all the sql codes as well and these codes are supposed to coded on my sql workbench on Ubuntu.

1 answer below »
Need 4 questions done I need question 3, 4, 5 and 6I need all the sql codes as well and these codes are supposed to coded on my sql workbench on Ubuntu.
Answered 2 days AfterJan 27, 2021

Answer To: Need 4 questions done I need question 3, 4, 5 and 6I need all the sql codes as well and these codes...

Neha answered on Jan 28 2021
134 Votes
/*
Student Name:
Student Number:
Date:
*/
CREATE TABLE TRUCK (
REGNUM VARCHAR (10) NOT NULL,
CAPACITY DECIMAL (7) NOT NULL,
WEIGHT DECIMAL (7) NOT NULL,
STATUS VARCHAR (10) NOT NULL,
CONSTRAINT TRUCK_PKEY PRIMARY KEY(REGNUM),
CONSTRAINT TRUCK_WEIGHT CHECK (WEIGHT > 0.0 AND WEIGHT < 500),
CONSTRAINT TRUCK_STATUS CHECK (STATUS IN ('AVAILABLE', 'USED', 'MAINTAINED')),
CONSTRAINT TRUCK_CAPACITY CHECK (CAPACITY > 0.0 AND CAPACITY < 221));
CREATE TABLE TRIP (
TNUM...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here