Database Development (Sequence Objects)

Watch this video: https://www.youtube.com/watch?v=FsVpkamX–Q&t=166s
Complete the following tasks using DDL & DML commands,  NOT THE GUI in the Microsoft SQL Server Management Studio. SHOW YOUR WORK!
1. Create a sequence for populating the Customer# column of the DB1.CASTEEL.CUSTOMERS table. When setting the start and increment values, keep in mind that data already exists in this table. The options should be set to not cycle the values and not cache any values, and no minimum or maximum values should be declared.
Sequence Goes Here.
Screen Shot Goes Here
2. Add a new customer row to the DB1.CASTEEL.CUSTOMERS table by using the sequence created in Question 1. The only data currently available for the customer is as follows:
· last name = Shoulders
· first name = Frank
· zip = 23567
Query Goes Here.
Screen Shot Goes Here
3. Create a sequence that generates integers starting with the value 5. Each value should be three less than the previous value generated. The lowest possible value should be 0, and the sequence shouldn’t be allowed to cycle. Name the sequence MY_FIRST_SEQ.
Sequence Goes Here.
Screen Shot Goes Here
4. Issue a SELECT statement that displays NEXTVAL for MY_FIRST_SEQ three times. What causes the error on the third SELECT?
Select Goes Here.
Select Goes Here.
Select Goes Here.
Screen Shot Goes Here
5. Change the setting of MY_FIRST_SEQ so that the minimum value that can be generated is –1000.
Alter Sequence Goes Here.
Screen Shot Goes Here

Place your order
(550 words)

Approximate price: $22

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
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
error: Content is protected !!
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 3234125597

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 20% with the discount code CLASS