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

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.

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