Thank you for the quick reply.
I uploaded the needed information to http://www.ge.tt/2nMe9wZ?c
The tables should match as closely as possible my ERD and metadata; however, I know there is room for improvement as I didn't know all the possible data types when I generated the outline.
Would you be able to complete this so it functions as required by project 2 today?
Thank you again
Whatever you modify, as long as it doesn't seem to advanced as this is my first SQL class ever. Just give me a basic explanation why and what is different from my initial turn in and I will write something explaining myself.
Looks good so far. I'm getting ready to load it into SQL. The only part I didn't catch yet was the failed input (step 2 in the project description document). Could you write the two failing statements also?
I will be gone for a couple hours, then be able to run through everything and test it out.
Thank you again for the fast help
I'm sorry, I did not notice that I didn't add that. But I am very happy so far, and will be depositing a little more than originally posted. I was half asleep and meant to mention that there was more detailed info in the projected document.
Thank you. It will be a couple hours till I get back to my computer. I'll load everything up as soon as I can.
Hello again!How is it going? Do you require additional assistance? All of the queries work in Oracle. Have you had an opportunity to run through them?
Make sure that you run them in order.
Also, the last one has to be run one query at a time because they are select queries. It doesn't really make sense to run them all at once, unless you are spooling.
And make certain you refer to the original docx file I sent for my comments in red.
Just let me know if you have any additional questions or you have any difficulty. I'm here to help.Please remember to rate my answer. Thank you so much!
Just got back and managed to run the scripts.
Script 3 posted 40 errors, I uploaded a CSV of the results at http://www.ge.tt/1OoVnzZ/v/0?c
Everything else seemed just fine
No, didn't change any of it. Loaded all the scripts in Application Express and ran them in order.
How do I unload the database? I even set a new account and re-ran all without any changes, same errors though
After running that line I was only able to add one extra line of code (line 10).
Why am I getting an error with MOVIE.FK saying parent key not found?
I do believe you. I really don't know anything about the interface or how to run any of this as we never went over it in the material.
Would you mind doing me one favor? Could you write me a statement according to this question?
From your project 1 metadata, write a query to return the number of times a movie with a pk value of 10 has been rented within the last month. You must use either your project 1 table metadata - or if you had to make corrections - your corrected metadata
I know that isn't part of the original request, but I would really appreciate it. You are getting an excellent rating no matter what, I will finalize it in 15 minutes.
Thank you again for your help