Lesson 13 Lab 13.docx - Anel Coralic CIST 1220 Lab 13 Hands-On Assignments 1 Create a view that lists the name and phone number of the contact person at

Lesson 13 Lab 13.docx - Anel Coralic CIST 1220 Lab 13...

This preview shows page 1 - 3 out of 3 pages.

Anel Coralic CIST 1220 4/15/2020 Lab 13 Hands-On Assignments 1.Create a view that lists the name and phone number of the contact person at each publisher. Don’t include the publisher’s ID in the view. Name the view CONTACT.Input: Output:2.3.Create a view called HOMEWORK13 that includes the columns name Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view created even if the FIRSTATTEMPT table doesn’t exist. Input: Output: 4.
Image of page 1
Anel Coralic CIST 1220 4/15/2020 Lab 13 5.Create a view that lists the ISBN and title for each book in inventory along with the name and
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture