EBK CONCEPTS OF DATABASE MANAGEMENT
8th Edition
ISBN: 8220100706004
Author: Last
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 11TDE
To determine
(a)
To create and test data macro for the after-insert event for the customer table to add the customer's balance multiplied by the rep's commission rate to the commission for the corresponding rep when adding a customer.
To determine
(b)
To create and check data macro for the after-update event for the customer table to add the difference between the new balance and the old balance multiplied by the rep's commission rate to the commission for the corresponding rep when updating a customer.
To determine
(c)
To create and check data macro for the after-delete event for the customer table to subtract the balance multiplied by the rep's commission rate from the commission for the corresponding rep when deleting a customer.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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
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?
Write the following queries in SQL, using the university schema. (We suggestyou actually run these queries on a database, using the sample data that weprovide on the web site of the book, db-book.com. Instructions for setting upa database, and loading sample data, are provided on the above web site.). Find the maximum enrollment, across all sections, in Fall 2017
Chapter 4 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
Ch. 4 - Prob. 1RQCh. 4 - Prob. 2RQCh. 4 - Prob. 3RQCh. 4 - Prob. 4RQCh. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Prob. 8RQCh. 4 - Prob. 9RQCh. 4 - Prob. 10RQ
Ch. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Prob. 15RQCh. 4 - Prob. 16RQCh. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - Prob. 1TDECh. 4 - Prob. 2TDECh. 4 - Prob. 3TDECh. 4 - Prob. 4TDECh. 4 - Prob. 5TDECh. 4 - Prob. 6TDECh. 4 - Prob. 7TDECh. 4 - Prob. 8TDECh. 4 - Prob. 9TDECh. 4 - Prob. 10TDECh. 4 - Prob. 11TDECh. 4 - Prob. 12TDECh. 4 - Prob. 13TDECh. 4 - Prob. 1CATCCh. 4 - Prob. 2CATCCh. 4 - Prob. 3CATCCh. 4 - Prob. 4CATCCh. 4 - Prob. 5CATCCh. 4 - Prob. 6CATCCh. 4 - Prob. 7CATCCh. 4 - Prob. 8CATCCh. 4 - Prob. 9CATCCh. 4 - Prob. 10CATCCh. 4 - Prob. 11CATCCh. 4 - Prob. 12CATCCh. 4 - Prob. 13CATCCh. 4 - Prob. 14CATCCh. 4 - Prob. 1SCGCCh. 4 - Prob. 2SCGCCh. 4 - Prob. 3SCGCCh. 4 - Prob. 4SCGCCh. 4 - Prob. 5SCGCCh. 4 - Prob. 6SCGCCh. 4 - Prob. 7SCGCCh. 4 - Prob. 8SCGCCh. 4 - Prob. 9SCGCCh. 4 - Prob. 10SCGCCh. 4 - Prob. 11SCGCCh. 4 - Prob. 12SCGC
Knowledge Booster
Similar questions
- use the sql to answer the floowing two question (data base code had been given below) To perform below tasks, refer to tables in the City Jail database. List all criminals along with the crime charges files. The report needs to include Criminal ID, name, Crime Code, and fine amount List all criminals along with crime status and appeal status (if applicable – sounds like an Outer join). The reports needs to include the Criminal ID, name, crime classification ,date charges , appeal filing date and appeal status. Show all criminals, regardless of whether they have filed an appeal or not.arrow_forwardIf we think about it in terms of SQL, why can indexing cause updates and deletions to take longer? Due to the difficulty of reading handwriting, please be as specific as possible and write your responses in text. [Please accept my thanks in advance for your time.]arrow_forwardTo perform these activities, refer to the JustLee database tables. During an afternoon at work, you receive various requests for data stored in the database. As you fulfill each request, you decide to document the SQL statements you used to find the data to assist with future requests. The following are two of the requests that were made: A manager at JustLee Books requests a list of the titles of all books generating a profit of at least $10.00. The manager wants the results listed in descending order, based on each book’s profit. A customer service representative is trying to identify all books in the Computer or Familylife categories published by Publisher 1 or Publisher 3. However, the results should not includeany book selling for less than $45.00.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr