Having Trouble Getting my SQL DB INSERT INTO script to work
Having Trouble Getting my SQL DB INSERT INTO script to work. I have
been at it adjusting and re-adjusting for 6 hours. EBERT.sql file is my database and loads fine. Populate.sql is all messed up.
SPOOL CreateDatabase2.log;DROP TABLE Directors_table ;DROP TABLE Academy_awards ;DROP TABLE Actors_table ;DROP TABLE Distribution_details ;DROP TABLE Movies_table ;DROP TABLE Distributer_table ;DROP TABLE Stars_table ;DROP TABLE Customers_table ;DROP TABLE Rentals_table ;DROP TABLE Discount_table ;DROP TABLE Genre_table ;DROP TABLE Video_type ;CREATE SEQUENCE SEQ_director_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_award_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_movie_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_actor_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_distributer_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_rental_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_genre_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_type_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_discount_id INCREMENT BY 1 START WITH 1CREATE SEQUENCE SEQ_customer_id INCREMENT BY 1 START WITH 1CREATE TABLE Directors_table (director_idNUMBER(5,0)PRIMARY KEY,nameVARCHAR2(40)NOT NULL,birthdateDATENOT NULL );CREATE TABLE Academy_awards (award_idNUMBER(5,0)PRIMARY KEY,movie_idINTNOT NULL,director_idINTNOT NULL,actor_idINTNOT NULL,award_yearNUMBER(4,0)NOT NULL );CREATE TABLE Actors_table (actor_idNUMBER(5,0)PRIMARY KEY,nameVARCHAR2(40)NOT NULL,birthdateDATENOT NULL);CREATE TABLE Distribution_details (movie_idINTPRIMARY KEY,distributer_idINTNOT NULL,quantityNUMBER(4,0)NOT NULL,priceDECIMAL(5,2) );CREATE TABLE Movies_table (movie_idNUMBER(5,0)PRIMARY KEY,director_idNUMBER(5,0)NOT NULL,discount_idNUMBER(5,0),
genre_idNUMBER(5,0)NOT NULL,type_idNUMBER(5,0)NOT NULL,titleVARCHAR2(40)NOT NULL,yearNUMBER(4,0)NOT NULL,lengthNUMBER(3,0),ratingNUMBER(1,0) );CREATE TABLE Distributer_table (distributer_idNUMBER(5,0)PRIMARY KEY,nameVARCHAR2(40)NOT NULL,phoneNUMBER(10,0)NOT NULL,addressVARCHAR2(255) );CREATE TABLE Stars_table (movie_idNUMBER(5,0)PRIMARY KEY,actor_idNUMBER(5,0)NOT NULL,newattribute_1VARCHAR2(255),newattribute_2VARCHAR2(255) );CREATE TABLE Customers_table (customer_idNUMBER(5,0)PRIMARY KEY,nameVARCHAR2(40)NOT NULL,phoneNUMBER(10,0)NOT NULL,addressVARCHAR2(255) );CREATE TABLE Rentals_table (rental_idNUMBER(5,0)PRIMARY KEY,movie_idNUMBER(5,0)NOT NULL,customer_idNUMBER(5,0)NOT NULL,date_rentedDATENOT NULL,date_returnedDATENOT NULL,late_feeDECIMAL(4,2),rewind_feeDECIMAL(3,2) );CREATE TABLE Discount_table (discount_idNUMBER(5,0)PRIMARY KEY,rateDECIMAL(3,2)NOT NULL );CREATE TABLE Genre_table (genre_idNUMBER(5,0)PRIMARY KEY,genre_typeVARCHAR2(20)NOT NULL );CREATE TABLE Video_type (type_idNUMBER(5,0)PRIMARY KEY,type_dvd_vhsVARCHAR2(3)NOT NULL );ALTER TABLE Academy_awards ADD FOREIGN KEY (movie_id) REFERENCES Movies_table(movie_id) ;ALTER TABLE Academy_awards ADD FOREIGN KEY (director_id) REFERENCESDirectors_table (director_id) ;ALTER TABLE Academy_awards ADD FOREIGN KEY (actor_id) REFERENCES Actors_table(actor_id) ;ALTER TABLE Distribution_details ADD FOREIGN KEY (movie_id) REFERENCESMovies_table (movie_id) ;ALTER TABLE Distribution_details ADD FOREIGN KEY (distributer_id) REFERENCESDistributer_table (distributer_id) ;ALTER TABLE Movies_table ADD FOREIGN KEY (director_id) REFERENCESDirectors_table (director_id) ;
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
