Here you go! It is due on Wednesday.http://wikisend.com/download/182916/Lab.zip
Programming Language: SQL
hithanks for requesting mewhen is due this
hiok i will do this
Is this ready yet?
hii will send soon
This assignment was due yesterday. R u finished?
hihere is the answer link below http://wikisend.com/download/470046/main.sql]main.sqlhttp://wikisend.com/download/722266/Queries.sql]Queries.sqlhope these helps
#3 is missing...
hijust wait let me check it
#3 is missing. Also,when you run the sql file......it contains errors. Please correct it and add in #3.
hihere is the link below http://wikisend.com/download/782488/Queries.sql]Queries.sql
#4, #5, & #7 all contains errors. Please correct it.
hionce you executed it, didn't drop the sequence and viewshttp://wikisend.com/download/270852/Queries.sql]Queries.sql
That help take out the error for #4. But #5 and #7 still has an error.
hii didn't get any errorsyou save these queries in LeeBooks.sqland run it
The lab explicity states to create a clean script file. Also, It states do not use LeeBooks.sql as part of this script. So there is not reason to save these queries in LeeBooks.
But here is the output file to show you the errors that I am getting for #5 and #7.
hiyou check with the last published idthen start the sequence with next CREATE SEQUENCE pubnum_seq 2 START WITH 7change the 7 with next to the last one
Here is the errors for #5 & #7:
SQL> --5SQL> INSERT INTO publisher VALUES(pubnum_seq.nextval,'Double Week','Jennifer Close','XXX-XXX-XXXX');INSERT INTO publisher VALUES(pubnum_seq.nextval,'Double Week','Jennifer Close','XXX-XXX-XXXX')*ERROR at line 1:ORA-00001: unique constraint (D02865865.PK_PUBLISHER) violated
SQL> INSERT INTO publisher VALUES(pubnum_seq.nextval,'Specific House','Freddie Farmore','XXX-XXX-XXXX');INSERT INTO publisher VALUES(pubnum_seq.nextval,'Specific House','Freddie Farmore','XXX-XXX-XXXX')*ERROR at line 1:ORA-00001: unique constraint (D02865865.PK_PUBLISHER) violated
SQL> --7SQL> CREATE INDEX boo_order_idx 2 ON book_order (orderid,customerid);CREATE INDEX boo_order_idx *ERROR at line 1:ORA-00955: name is XXXXX XXXXX by an existing object
hiwhen you first execute this query, it already created a new record with publisherid 9, next when you execute this same query ,it starts with 7 , so it becomes 9, so it violated the primary keyfor resolving this, you first execute LeeBooks.sql;then you run Queries.sqlyou will get the correct one
OMG! I am so stupid. That worked! Thank you for being patient with me.
hiok then no problem if you are ok, don;t forget to click on Accept button
Master of Computer Application plus 5+ year experience in Software development