a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

Question

Want to see the full answer?

Answer 1

Question

Chapter 4, Problem 12CATC

To determine

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

To determine

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

To determine

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

List out various user authorization to modify the database Schema

Use SQL to make the following changes to the Colonial Adventure Tours database (Figures 1-4 through 1-6 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output or save it to a document. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task. Create a view named MAINE_TRIPS. It consists of the trip ID, trip name, start location,distance, maximum group size, type, and season for every trip located in Maine (ME). a. Write and execute the CREATE VIEW command to create the MAINE_TRIPS view.b. Write and execute the command to retrieve the trip ID, trip name, and distancefor every Biking trip.c. Write and execute the query that the DBMS actually executes.d. Does updating the database through this view create any problems? If so, whatare they? If not, why not

How can the key and foreign key constraints be enforced by the DBMS?

Answer 2

Question

Chapter 4, Problem 12CATC

To determine

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

To determine

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

To determine

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 4, Problem 12CATC

To determine

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

To determine

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

To determine

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 4, Problem 12CATC

To determine

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

To determine

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

To determine

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 4, Problem 12CATC

To determine

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

To determine

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

To determine

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Answer 6

Chapter 4, Problem 12CATC

To determine

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

Answer 7

Chapter 4, Problem 12CATC

To determine

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

Answer 8

To determine

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

Answer 9

To determine

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

Answer 10

To determine

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Answer 11

To determine

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Answer 12

Expert Solution & Answer

Answer 13

Expert Solution & Answer

Answer 14

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 15

Ch. 4 - Prob. 1RQ Ch. 4 - Prob. 2RQ Ch. 4 - Prob. 3RQ Ch. 4 - Prob. 4RQ Ch. 4 - Prob. 5RQ Ch. 4 - Prob. 6RQ Ch. 4 - Prob. 7RQ Ch. 4 - Prob. 8RQ Ch. 4 - Prob. 9RQ Ch. 4 - Prob. 10RQ

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

Solution Summary: The author explains how to modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table.

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Want to see the full answer?

Chapter 4 Solutions

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

Solution Summary: The author explains how to modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table.

a. To modify the table Customer to include a column PreviousTrip and create and run totals query on reservation table to get number of reservations by customer and update the location table with these values manually.

b. To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

c. To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.

Want to see the full answer?

Chapter 4 Solutions

b.

To create and check data macro for the after-insert event for reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the reservation table.

c.

To create and check data macro for the after-delete event for reservation table to decrement the PreviousTrip field value for the appropriate customer when deleting a row from the reservation table.