Question: Please help mME REMOVE ERROR SPOOL figure9.log SPOOL figure9.log DROP TABLE Distributors CASCADE CONSTRAINT; DROP TABLE Catalogs CASCADE CONSTRAINT; DROP TABLE Orders CASCADE CONSTRAINT; DROP
Please help mME REMOVE ERROR SPOOL figure9.log SPOOL figure9.log DROP TABLE Distributors CASCADE CONSTRAINT; DROP TABLE Catalogs CASCADE CONSTRAINT; DROP TABLE Orders CASCADE CONSTRAINT; DROP TABLE Customers CASCADE CONSTRAINT; /* Create Tables */ CREATE TABLE Customers ( Customer_id NUMBER(10) NOT NULL, CustomerFirst_name VARCHAR(20) NOT NULL, CustomerLast_name VARCHAR(20) NOT NULL, CustomerStreet_address VARCHAR(30) NOT NULL, CostumerCity VARCHAR(20) NOT NULL, CustomerState CHAR(2) NOT NULL, CostumerZip VARCHAR(9) NOT NULL, CustomerPhone_number VARCHAR(10) NOT NULL, CONSTRAINT Customer_PK PRIMARY KEY (Customer_id)); CREATE TABLE Orders ( Order_id NUMBER(10) NOT NULL, OrderDate DATE DEFAULT SYSDATE, CONSTRAINT Order_PK PRIMARY KEY (Order_id)); CREATE TABLE Products ( Product_id NUMBER(10) NOT NULL, ProductDescription VARCHAR(50), ProductMovieType NUMBER(11), Order_id NUMBER(10) NOT NULL, CONSTRAINTS Product_PK PRIMARY KEY (Product__id), CONSTRAINTS Product_FK FOREIGN KEY (Order_id) REFERENCES Order (Order_id)); CREATE TABLE Distributors ( DistributorDisc_id NUMBER(11,0) NOT NULL, DistributorPrice NUMBER(11,0) NOT NULL, DistributorOrderQuantity NUMBER(11), Order_id NUMBER(10) NOT NULL, CONSTRAINTS Distributor_PK PRIMARY KEY (DistributorDisc__id) CONSTRAINTS Distributor_FK FOREIGN KEY (Order_id) REFERENCES Order (Order_id)); CREATE TABLE Catalogs ( Catalog_id NUMBER(5,0) NOT NULL, CatalogRating VARCHAR(10) NOT NULL, CatalogAcademyAwards VARCHAR(50) NOT NULL, CatalogDateReleased DATE DEFAULT SYSDATE, Product_id NUMBER(10) NOT NULL, Order_id NUMBER(10) NOT NULL, DistributorDisc_id NUMBER(11,0) NOT NULL, CONSTRAINT Catalog_PK1 PRIMARY KEY (Catalog_id), CONSTRAINT Catalog_FK1 FOREIGN KEY (Order_id) REFERENCES Orders (Order_id), CONSTRAINT Catalog_FK2 FOREIGN KEY (Product_id) REFERENCES Product (Product_id), CONSTRAINT Catalog_FK3 FOREIGN KEY (DistributorDisc_id) REFERENCES Distributor (DistributorDisc_id)); CREATE TABLE Rentals ( Rental_id NUMBER (9) NOT NULL, RentalReturnDate DATE DEFAULT SYSDATE, RentalRentedQuantity VARCHAR(1) NOT NULL, RentalTotal_charge NUMBER(19,4) NOT NULL, RentalTax NUMBER(19,4) NOT NULL, Product_id NUMBER(10) NOT NULL CONSTRAINT Rental_PK PRIMARY KEY (Rental_id), CONSTRAINT Rental_FK FOREIGN KEY (Product_id) REFERENCES Product (Product_id)); /* Create Foreign Keys */ ALTER TABLE Rentals ADD FOREIGN KEY (DistributorDisc_id) REFERENCES Distributor (DistributorDisc_id); ALTER TABLE Distributors ADD FOREIGN KEY (Product_id) REFERENCES Product (Product_id); ALTER TABLE Products ADD FOREIGN KEY (DistributorDisc_id) REFERENCES Distributor (DistributorDisc_id); ALTER TABLE Rentals DROP COLUMN Catalog_id; ALTER TABLE Customers ADD FOREIGN KEY (RentalTotal_charge); SPOOL OFF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
