Tracking Pledge Payment Activity The Do Good Donor organization wants to track all pledge payment activity. Each time a pledge payment is added. changed, or removed, the following information should be captured in a separate table: username logon), current date, action taken (INSERT. UPDATE). And the Id which made the payment and the payment record. Create a table named OD_PATTRACK to hold this information. Create a single trigger for recording the requested information of track pledge payment activity, and test the trigger.

Tracking Pledge Payment Activity The Do Good Donor organization wants to track all pledge payment activity. Each time a pledge payment is added. changed, or removed, the following information should be captured in a separate table: username logon), current date, action taken (INSERT. UPDATE). And the Id which made the payment and the payment record. Create a table named OD_PATTRACK to hold this information. Create a single trigger for recording the requested information of track pledge payment activity, and test the trigger.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001',…

A: Name of the procedure - ADD_INVOICE Name of relation - INVOICES Suppose datatype of INVOICE_NUM,…

Q: Create a view named myView_757 (last 3 digits of your student number) That view should display…

A: create table and insert all the data CREATE TABLE employees ( employee_id NUMBER GENERATED BY…

Q: CREATE TABLESPACE user_tbspace DATAFILE 'user.dbf' SIZE 2m; create user mary identified by mary;…

A: Given that, CREATE TABLESPACE user_tbspace DATAFILE 'user.dbf' SIZE 2m; create user mary identified…

Q: Create a procedure to allow an employee in the shipping department to update an order status to add…

A: CREATE OR REPLACEPROCEDURE STATUS_SHIP_SP(p_bask_id IN BB_BASKETSTATUS.IDBASKET%TYPE,p_ship_date IN…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Question 1: Modify the select statement in this section to display the hire_date column in the…

A: SQL which refers to the domain specific that are used for the language and in the programming and…

Q: WEEK 9 ASSIGNMENT#5 This assignment contains two parts, you must complete Part I before you can…

A: As per Bartleby rules, we have answered only the first part, creating the tables and inserting 5…

Q: Task 1: Create a LARGE_PROPERTY table with the structure shown below. 1 LARGE_PROPERTY table…

A: TASK 01: CREATE TABLE LARGE_PROPERTY ( OFFICE_NUM DECIMAL(2) NOT NULL,…

Q: I am super confused at why nothing is being accepted when I submit my work for a check. This MindTap…

A: The error that is coming is that it says a table named REP already exists in the database.

Q: Requirement 2 Write SQL DROP statements that will drop all the tables. Add these statements to the…

A: Approach Start Create a table worker Add columns in the worker table Create a table task Add…

Q: 3 Create a COLOMBIA_CITY_PROPERTY VIEW to filter the properties managed by the Columbia City office…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Create a trigger called Trig_Enroll_BI on the ENROLLMENT table that fires before an INSERT…

A: Solution:Create the trigger with name of “Trig_Enroll_BI” for ENROLLMENT table.The followings…

Q: 1) Create a view named CustomerSummary with details of each customer, the number of equipment…

A: Query:

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: Create relationships between the tables. Create Form to enter, update, delete user data from the…

A: /* one-to-one: User has one address */ CREATE TABLE addresses ( user_id int, -- Both a primary…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: When should you use the %ROWTYPE attribute in creating a record variable? Answers: a. when using…

A: Required: when use %ROWTYPE

Q: Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of…

A: Views in SQL correspond to a virtual table consisting of rows and columns. It represents result set…

Q: task 1: Create a COLOMBIA_CITY_PROPERTY VIEW to filter the properties managed by the Columbia City…

A: Effectively handling property data is essential for real estate organizations to maintain smooth…

Q: Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of…

A: We need to Create a view named MONTHLY_RENTS from PROPERTY table CREATE VIEW MONTHY_RENTS AS…

Q: After converting the ERD to a table design, what fields will be present in the Contracts table?…

A: An Entity-Relationship (ER) diagram is a visual representation of the data model that represents the…

Q: Alter the PROPERTY table by changing the OWNER_NUM field to refer to the OWNER table. Retrieve the…

A: In this question we have been given some database task related to SQL database Let's query out the…

Q: Matching Drag the letter from the list on the right to its matching term in the list on the left.…

A: A database is a structured collection of organized data that is stored and managed electronically.…

Concept explainers

Elements of Tables

In HyperText Markup Language (HTML), a table element displays data in tabular format. A table is made up of rows and columns consisting of data. A table can have multiple columns and rows.

Question

Tracking Pledge Payment Activity The Do Good Donor organization wants to track all pledge
payment activity. Each time a pledge payment is added. changed, or removed, the following
information should be captured in a separate table: username logon), current date, action taken
(INSERT. UPDATE). And the Id which made the payment and the payment record. Create a
table named OD_PATTRACK to hold this information. Create a single trigger for recording the
requested information of track pledge payment activity, and test the trigger.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1(--Creating Sequence_DD table:)

VIEW

Step 2(Creating Sequence_PTRACK:)

VIEW

Step 3(Creating a Trigger:)

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Assignment 6: Creating the Babbage Bookkeeping Database Create a relationship between two tables. Specify referential integrity between the Bookkeeper table (the one table) and the Client table (the many table). Save the Relationships. Create the following queries. Create a query for the Client table. The query must display Client Number, Client Name, and Balance fields for all clients located in Empeer with a balance greater than $300.00. Do not display City field. Save the query as “Q21-Client-Empeer Query.” Create a query to display the Client Number, Client Name, and Address fields for all clients with an address on Maum. Save the query as “Q22-Client-Maum Query.” Create a query that will allow the user to enter the city to search when the query is run. The query results should display the Client Number, Client Name, and Bookkeeper Number. Test the query by searching for those records where the client is located in Portage. Save the query as “Q23-Client-City…
1. Create a SELECT statement that returns the order number and date for all records in the ORDERS table. Using an inner join, include the customer name and email address associated with each order.
I am working on Task 7. Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. Here is Tasks 1-7 and what I wrote for Task 8. When I input Task 8, I am not getting results at all. Expected Results Tables_in_StayWell Table_type MONTHLY_RENTS VIEW
1. Use Design view to create a new table. Add AccountType as the first field name, with data type Short Text and field size 10. Ensure AccountType is set as the primary key. Save the table and name it AccountTypes. Add three records: Platinum, Silver, and Gold. Close the table.2.Open the Customers table in Design view. Set the PhoneNumber and AccountType fields to Required. Save the table. Close the table.3.Open the Loans table in Design view. Establish a validation rule for the InterestRate field that requires the value to be greater than or equal to 2.5 but less than or equal to 10. Create validation text for the InterestRate: Value must be between 2.5 and 10 (no period). Save the table. Change the InterestRate in the first record to 2. The validation text appears. Press ESC to restore the original value. Close the Loans table.4.Open the Customers table in Design view. Add a phone number input mask for the PhoneNumber field, storing the symbols with the data.5.Change the Data Type of…
The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
Task 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.
Task 7: The development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT. Task Alter the RESIDENTS table and change the ID field to an auto-incremented field. 1 Task 8: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table. Task Add Yigit Yilmaz to the RESIDENTS table. 1 Task 9: The StayWell property management team wants to add two additional properties and run some simulation tests relating to market coverage. Add the following properties to the PROPERTY table: PROPERTY_ID OFFICE_NUM ADDRESS SQR_FT BDRMS FLOORS OWNER_NUM 14 1 9 Houston Drive 1,100 2 1 MO100 15 1 11 Village Drive 1,300 3 1…
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
please use the picture to answer the following question Normalize below user view to the third normal form. Show all steps (UNF, 1NF, Dependencies, 2NF, 3NF).
Create a new query in Design View that is based on the tblCoach and tblLevel table Add the LevelName field from the tblLevel table to the query design. Add the CoachFirst, CoachLast, BGCExp, and CertificationExp fields, in that order, from the tblCoach table. Use qryCoachBGCExpirations to save query. Add criteria to the BGCExp field to select records with BGCExp dates that occur on or before 12/31/2019. Save and run the query, and then close it.