Question: SQL Adventure Tours database is shown below. You need to archive all Reservations if trips occurred before Jan-1, 2016. Similarly, if a Customer's last Reservation

SQL

Adventure Tours database is shown below. You need to archive all Reservations if trips occurred before Jan-1, 2016.

Similarly, if a Customer's last Reservation occurred before Jan-1, 2016 , archive them as well. Assume the Trips and Guides remain current, and don't need archiving.

Guide (GuideNum, LastName, Firstname)

Trip (TripID, TripName, Location, State, Type, Season)

Customer (CustomerNum, CustomerName)

Reservation (ReservationID, TripID, TripDate, NumPersons, TripPrice, CustomerNum)

TripGuides (TripID, GuideNum)

Questions:

1. Create a view that will be used to archive Reservation table

2. Create a view that will be used to archive Customer table

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!

solve this ms access queeries and show the steps how to do each question Colonial Adventure Tours Case The owner of Colonial Adventure Tours knows that being able to run queries is one of the most...

need help For this assignment I do not want a MS Access file but rather a snapshot of the QBE. Also, show the result of the query after it is executed. -Complete a QBE design grid using MS Access for...

need help In the following exercise, you will use the Access Files located in the Files section of your Canvas shell. For this assignment I do not want a MS Access file but rather a snapshot of the...

Please helps! PLEASE DO QUESTION 1- 6. Thank you! The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises,...

The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

QUESTION 4 [ 3 0 marks ] NOTE: All SQL syntax must be correct, missing characters will be penalized! BTEE Adventure Tours is a small business that organizes daylong, guided trips to South Africa. To...

BTEE Adventure Tours is a small business that organizes daylong, guided trips to South Africa. To support the company s growing business, management uses a database to ensure that the company s data...

Multiple Choice Questions 1. If a company uses the direct write-off method of accounting for bad debts, a. It is applying the matching principle. b. It will record bad debt expense only when an...

Manitoba Peat Moss (MPM) was the first Canadian company to provide a reliable supply of high-quality peat moss to be used for greenhouse operations. Owned by Paul Parker, the company's founder and...

Assuming Roundtree would like to sell . 8 million shares in its IPO, what will be the winning auction offer price?

JT Company purchased land as a factory site. An old building on the property was demolished, and construction began on a new building. Costs incurred during the first year are listed below: JT...

2. KMPG LLP

5. Wyeth Pharmaceuticals

2. Go to www.quality.nist.gov, the Web site for the National Institute of Standards and Technology (NIST). The NIST oversees the Malcolm Baldrige Quality Award. Click on Criteria for Performance...