Question: Create a view that lists the ISBN and title for each book in inventory along with the name and phone number of the person to

Create a view that lists the ISBN and title for each book in inventory along with the name
and phone number of the person to contact if the book needs to be reordered. Name the
view REORDERINFO.
6. Try to change the name of a contact person in the REORDERINFO view to your name.
Was an error message displayed when performing this step? If so, what was the cause
of the error message? 7. Select one of the books in the REORDERINFO view and try to change its ISBN. Was an error
message displayed when performing this step? If so, what was the cause of the error message?
8. Delete the record in the REORDERINFO view containing your name. (If you werent able to
perform #6 successfully, delete one of the contacts already listed in the table.) Was an error
message displayed when performing this step? If so, what was the cause of the error message?
9. Issue a rollback command to undo any changes made with the preceding DML operations.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Create a view that lists the ISBN and title for each book in inventory along with the name and phone number of the person to contact if the book needs to be reordered. Name the view REORDERINFO.

Q:

im doing this on oracle apex and the information isnt showing up when i type the commands. This work project focuses on adding join conditions involving queries that combine data from more than one...

Q:

Please answer with queries according to the database table above CPAN 121 Assignment 2 - Joins (100 points) You are to use SQL Developer to perform the requested operations based on tables. You are...

Q:

You are to use SQL Developer to perform the requested operations based on tables. I need to see your SQL command followed immediately by the result. You are to use comments to record your name, the...

Q:

Write the SQL statements to satisfy the requests below. Use either the 'Traditional' or 'JOIN' method: 1) Create a list that displays the title of each book and the name and phone number of the...

Q:

Database SQL To perform the following assignments, refer to the tables in the JustLee Books database. Create a view that lists the name and phone number of the contact person at each publisher. Don't...

Q:

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 2. Change the CONTACT view so that...

Q:

Lab 1 3 To perform the following assignments, refer to the tables in the JustLee Books database. Create a view that lists the name and phone number of the contact person at each publisher. Don't...

Q:

Database SQL Hands-on Assignments To perform the following assignments, refer to the tables in the JustLee Books database. 1. Create a view that lists the name and phone number of the contact person...

Q:

1. What happens to the data displayed by a view if the view is deleted? The following tables form a Library database held in an RDBMS: Borrower (card_no , last_name, first_name , address, city ,...

Q:

What are some basic guidelines for designing brochures? Web pages?

Q:

Why does sellers require higher price to be paid for acquiring "net sales" than "stocks"? Why does IRS treat stock purchase and tangible and intangible assets purchase differently in acquisition?

Q:

CA16.4 (LO 2) (Equity Investments) The IASB issued accounting guidance to clarify accounting methods and procedures with respect to debt and equity investments. An important part of the statement...

Q:

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Q:

3 What kinds of presentations do you think would work best as podcasts? What kinds would not work well? Are podcasts useful outside academia?

Q:

Consider your specific speech purposewhat are your objectives for your informative speech? Now consider what types of presentation aids might help you achieve your purpose. How might you use aids to...

Q:

2 Imagine that you have to give an informative speech about a sexual topic in front of your nursing class. How would you approach the subject? Would you handle it differently if you were speaking in...