10 sql statements | Computer Science homework help

 

Write 10 SQL statements athwart the STUDENT schema you created for performance lab 1. Your statements should run error-free and should be powerful. Submit two disunited rasps: one open quotation rasp (.txt or .sql rasp) delay your statements simply; and the other muniment (doc/docx/pdf) embrace twain your statements and your interrogation developments (delineation and paste quotation or harbor shots). The educator and TA should be conducive to run your open quotation rise rasp as script and propagate the identical output as pompn in your development muniment.

Attached is Lab 1

1. Evidence all notification encircling all directions that entertain no prerequisite
2. Add yourself as a new ward to the Ward tconducive (use conconsequence STUDENT_ID_SEQ.NEXTVAL as Student_ID and 07070 as zip)
3. List all wards (evidence Student_ID, primeval designate and conclusive designate) who subsist in zip 07070
4. Pomp how multifarious wards who entertain phone area jurisprudence 212 (HINT: use the SUBSTR character)
5. List all ward designates who toil for Electronic Engineers and registered on or following Feb. 3, 2007
6. List all directions that entertain "Intro to Notification Systems" as prerequisite (HINT: use a subquery)
7. For all wards who entertain phone area jurisprudence 212, exexchange the jurisprudence to 202 suitableness maintenance the identical phone estimate (HINT: ponder using characters such as SUBSTR and LENGTH)
8. Delete your own ward annals acquired for interrogation 2
9. Lower require of all directions by 300
10. List all direction requires (pomp direction cognomen and require simply) by the dispose of require from last to foremost (pomp directions delayout require primeval)

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency