Given the following table definition for the shipment table, sp:CREATE TABLE sp   (spno VARCHAR(4) NOT NULL,    sno    VARCHAR(3)  NOT NULL,    pno    VARCHAR(3)  NOT NULL,    qty   SMALLINT NOT NULL CHECK (qty>=0), PRIMARY KEY (spno), FOREIGN KEY (sno) REFERENCES s ON DELETE RESTRICT ON UPDATE CASCADE, FOREIGN KEY (pno) REFERENCES p ON DELETE RESTRICT ON UPDATE CASCADE );And the following data on the supplier, s, part, p, and shipment, sp, tables: supplier (s)part (p)shipment (sp)The following update will be allowed on the supplier table, s: update sSET sno = 'S20'WHERE sno='S1';

Refer to the given schema.Write a query to create the courier and courier status tables with the constraints mentioned. Assume that the customer and branch tables are already created.

Dia is responsible for managing a pharmaceutical production and distribution system. This system tracks information about drugs, production batches, and shipments. She needs to ensure that the data across these tables is accurate and meaningful.Write the DDL statements to create the following tables with the specified constraints:symbol refers to the primary key NN refers to Not NULL Create the DRUG table to store information about different drugs.Create the BATCH table with a foreign key constraint named FK_DRUG_ID to reference the DRUG table's DRUG_ID column, ensuring each batch is associated with a specific drug. Include a check constraint named CK_QUANTITY to ensure the QUANTITY column has a positive value.Create the SHIPMENT table with a foreign key constraint named FK_BATCH_ID to reference the BATCH table's BATCH_ID column, ensuring each shipment is linked to a specific production batch. Include a check constraint named CK_QUANTITY_SHIPPED to ensure the QUANTITY_SHIPPED column has a positive value.Note: The user must write only the query to create and alter the table. The query to display the description of the table is already given.Input format :No console inputOutput format :The output displays the successful table creation status and the structure of all three tablesRefer to the sample output.Sample test cases :Input 1 :Output 1 :Table DRUG created.Table BATCH created.Table SHIPMENT created. Name Null? Type ____________________ ___________ ________________ DRUG_ID NOT NULL NUMBER DRUG_NAME NOT NULL VARCHAR2(100) ACTIVE_INGREDIENT NOT NULL VARCHAR2(100) CATEGORY NOT NULL VARCHAR2(50) Name Null? Type __________________ ___________ _______________ BATCH_ID NOT NULL NUMBER DRUG_ID NOT NULL NUMBER BATCH_NUMBER NOT NULL VARCHAR2(50) PRODUCTION_DATE NOT NULL DATE QUANTITY NOT NULL NUMBER Name Null? Type ___________________ ___________ ________________ SHIPMENT_ID NOT NULL NUMBER BATCH_ID NOT NULL NUMBER SHIPMENT_DATE NOT NULL DATE DESTINATION NOT NULL VARCHAR2(255) QUANTITY_SHIPPED NOT NULL NUMBER TABLE_NAME SEARCH_CONDITION STATUS _____________ __________________________________ __________ BATCH QUANTITY > 0 ENABLED BATCH "DRUG_ID" IS NOT NULL ENABLED BATCH "BATCH_NUMBER" IS NOT NULL ENABLED BATCH "PRODUCTION_DATE" IS NOT NULL ENABLED BATCH "QUANTITY" IS NOT NULL ENABLED DRUG "DRUG_NAME" IS NOT NULL ENABLED DRUG "ACTIVE_INGREDIENT" IS NOT NULL ENABLED DRUG "CATEGORY" IS NOT NULL ENABLED SHIPMENT QUANTITY_SHIPPED > 0 ENABLED SHIPMENT "BATCH_ID" IS NOT NULL ENABLED SHIPMENT "SHIPMENT_DATE" IS NOT NULL ENABLED SHIPMENT "DESTINATION" IS NOT NULL ENABLED SHIPMENT "QUANTITY_SHIPPED" IS NOT NULL ENABLED 13 rows selected.

Alexander is developing a ride-sharing application to track drivers, vehicles, and trips. The system needs to handle three main types of data: DRIVERS, VEHICLES, and TRIPS. Write the DDL statements to create the following tables with the mentioned constraints to handle the data: The DRIVERS table has a named primary key constraint pk_driver.The VEHICLES table has a named primary key constraint pk_vehicle for VehicleID and a named foreign key constraint fk_driver for DriverID.The TRIPS table has a named primary key constraint pk_trip for TripID and a named foreign key constraint fk_vehicle for VehicleID.symbol refers to the primary key NN refers to Not NULLAlexander ensures the following constraints are altered:Remove the foreign key constraint named fk_driver from the VEHICLES table.Note: The user must write only the query to create and alter the table. The query to display the description of the table is already given.Input format :No console inputOutput format :The output displays the successful table creation status, the structure of all three tables, and the existing foreign key constraint details.Refer to the sample output.Sample test cases :Input 1 :Output 1 :Table DRIVERS created.Table VEHICLES created.Table TRIPS created.Table VEHICLES altered. Name Null? Type ________________ ___________ ________________ DRIVERID NOT NULL NUMBER NAME NOT NULL VARCHAR2(100) LICENSENUMBER NOT NULL VARCHAR2(20) Name Null? Type ____________ ___________ _______________ VEHICLEID NOT NULL NUMBER DRIVERID NOT NULL NUMBER MAKE NOT NULL VARCHAR2(50) MODEL NOT NULL VARCHAR2(50) Name Null? Type ____________ ___________ _________ TRIPID NOT NULL NUMBER VEHICLEID NOT NULL NUMBER TRIPDATE NOT NULL DATE DISTANCE NOT NULL NUMBER TABLE_NAME FOREIGN_KEY_NAME FOREIGN_KEY_COLUMN REFERENCED_CONSTRAINT_NAME REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME _____________ ___________________ _____________________ _____________________________ ________________________ _________________________ TRIPS FK_VEHICLE VEHICLEID PK_VEHICLE VEHICLES VEHICLEID 1 row selected. Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

Consider a relation involving suppliers, parts, and projects:Initial Table (SupplierPartsProjects)Supplier Part  Project S1 P1 J1S1 P2 J1S1 P1 J2S2 P2 J2Assume the following constraints:i. Every part supplied for a project is supplied by all suppliers supplying any part for that project.ii. Every part supplied by a supplier is supplied by that supplier for all projects to which that supplier supplies any part.In the given example, what join dependencies exist on the table "SupplierPartsProjects"?{Supplier, Part} ⟶ SupplierPartsProjects{Supplier, Project} ⟶ SupplierPartsProjects{Part, Project} ⟶ SupplierPartsProjectsAll of the above

Question 13When must you use a Type I nested query in an UPDATE or DELETE statement?1 pointA non target table has row conditions.A non target table has combined primary key.A non target table has an optional foreign key.A non target table provides columns for the UPDATE statement.