Create SQL select statements for the questions below using the data base. CREATE TABLE CUSTOMER ( CustID

Create SQL select statements for the questions below using the data base.

    

Transcribed Image Text:

CREATE TABLE CUSTOMER ( CustID CustName Annual Revenue CustType ); CREATE TABLE TRUCK ( TruckNo TRUCK (TruckNo) ); CREATE TABLE PACKAGE ( DriverName VARCHAR (20) Supervisor INT CONSTRAINT Truck_Supervisor_FK INT PRIMARY KEY, VARCHAR (30), CONSTRAINT TRUCK (TruckNo) CONSTRAINT DECIMAL (10,0) CHAR (1) CREATE TABLE CITY ( CityID CityName VARCHAR (30), Population DECIMAL (10,0) CITY (CityID) INT PRIMARY KEY, Shipment No DECIMAL (4,0), CustID INT, Weight TruckNo CityID ShipDate DATE /*ON UPDATE NO ACTION ON DELETE NO ACTION */ NOT NULL, INT PRIMARY KEY, INT INT CHECK (Annual Revenue > 0), CHECK (CustType IN ('1', '2', '3')) DEFAULT 103, DECIMAL (6,2) NOT NULL, NOT NULL, /*CHECK (ShipDate > GETDATE ()-1))*/, CONSTRAINT Package_PK PRIMARY KEY (ShipmentNo, CustID), CONSTRAINT Package_Cust_FK FOREIGN KEY (CustID) REFERENCES CUSTOMER (CustID) FOREIGN KEY (Supervisor) REFERENCES CHECK (WEIGHT > 0), ON UPDATE CASCADE ON DELETE NO ACTION, Package_Truck_FK FOREIGN KEY (TruckNo) REFERENCES ON UPDATE CASCADE ON DELETE NO ACTION, Package_City_FK FOREIGN KEY (CityID) REFERENCES ON UPDATE CASCADE ON DELETE NO ACTION CREATE TABLE CUSTOMER ( CustID CustName Annual Revenue CustType ); CREATE TABLE TRUCK ( TruckNo TRUCK (TruckNo) ); CREATE TABLE PACKAGE ( DriverName VARCHAR (20) Supervisor INT CONSTRAINT Truck_Supervisor_FK INT PRIMARY KEY, VARCHAR (30), CONSTRAINT TRUCK (TruckNo) CONSTRAINT DECIMAL (10,0) CHAR (1) CREATE TABLE CITY ( CityID CityName VARCHAR (30), Population DECIMAL (10,0) CITY (CityID) INT PRIMARY KEY, Shipment No DECIMAL (4,0), CustID INT, Weight TruckNo CityID ShipDate DATE /*ON UPDATE NO ACTION ON DELETE NO ACTION */ NOT NULL, INT PRIMARY KEY, INT INT CHECK (Annual Revenue > 0), CHECK (CustType IN ('1', '2', '3')) DEFAULT 103, DECIMAL (6,2) NOT NULL, NOT NULL, /*CHECK (ShipDate > GETDATE ()-1))*/, CONSTRAINT Package_PK PRIMARY KEY (ShipmentNo, CustID), CONSTRAINT Package_Cust_FK FOREIGN KEY (CustID) REFERENCES CUSTOMER (CustID) FOREIGN KEY (Supervisor) REFERENCES CHECK (WEIGHT > 0), ON UPDATE CASCADE ON DELETE NO ACTION, Package_Truck_FK FOREIGN KEY (TruckNo) REFERENCES ON UPDATE CASCADE ON DELETE NO ACTION, Package_City_FK FOREIGN KEY (CityID) REFERENCES ON UPDATE CASCADE ON DELETE NO ACTION

Answer rating: 100% (QA)

The image provided contains SQL CREATE TABLE and INSERT INTO statements to set up and populate a dat... View the full answer