Could you please answer those questions for me? thank you 1.Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in I_INVOICE_NUM to the date currently found in I_INVOICE_DATE. 2.Create the DELETE_INVOICE procedure to delete the invoice whose number is stored in I_INVOICE_NUM

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: Owner Sims Haydon contacted the Colombia City (ID: 1) office and informed them that the monthly rent…

A: Kent drive problem Task: updating the montly rent for the property at Kent Drive

Q: Task 7: Create a view named INVOICE_TOTAL. It consists of the invoice number and invoice total for…

A: Actually, database is a used to stores the data\information.

Q: Display all data contained in one of the tables in the JustLee Books database. Retrieve two columns…

A: Introduction Database: A database is a collection of organized data that is electronically stored…

Q: Which of the following functions can be used to determine how many months a book has been available?…

A: Functions to determine the number of months available The MONTH is not a valid function in SQL. It…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

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

Q: Set up a Google Cloud Platform account. Create a BigQuery dataset named “order_entry_dataset” in…

A: Copying Tables:To copy tables from another data set, you can use the CREATE TABLE statement as…

Q: The Developers team also wants you to ensure that emails are converted to lowercase after an update…

A: A collected information or structured data in the form of table that are stored electronically which…

Q: User name is “user1_app” b. Authentication uses SQL Based Authentication c. User password is never…

A: WideWorldImporters : -  It is the database for Transaction and Analytics processing.

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table:   INSERT INTO OWNER…

Q: Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL.…

A: An SQL procedure is a combination of SQL and procedural statements. A procedure have two types of…

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: Some rows of a User table are shown below:   User ucode name phone scode 7 Alex 847 - 3902…

A: Names and phone numbers are among the details about different users that are included in the User…

Q: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in…

A: It enables to save query with a name so that it can be executed whenever required rather than…

Q: Create a trigger named trg_cust_balance that automatically updates the CUSTOMER table’s CUS_BALANCE…

A: Syntax for creating a trigger: CREATE TRIGGER name{AFTER|BEFORE|INSTEAD OF} {DELETE|INSERT|UPDATE}…

Q: Task 8: Write and execute the command to retrieve the average square footage and average monthly…

A: Since table name is not mentioned, I am using table name as "PROPERTY" Query: SELECT AVG(SQR_FT),…

Q: I have the following SQL Script: CREATE OR REPLACE TRIGGER SCSP_VIEW_UPDATE INSTEAD OF UPDATE ON…

A: We have to create   How to add logic so that blanks and empty strings cannot be used to update…

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: 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 the ADD_INVOICE procedure to add rows to the INVOICE table. (

A: A SQL Procedure is created by writing the keyword "CREATE PROCEDURE" then procedure name i.e.,…

Q: The Car Maintenance team wants to update the price of Oil Change to 75. In addition, they will no…

A: In most cab companies, drivers have predefined schedules. We’ll know the exact times when the driver…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: 2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted…

A: SQL: SQL is defined as Standard Query Language it is mainly used for the manipulation of the…

Q: What index would you recommend, and what command would you use? SELECT P_CODE, P_DESCRIPT, P_QOH,…

A: Indexes: Indexing is a technique that is used in SQL (Structured query Language) to optimize the…

Q: Which of the following creates a new table in a database and also copies the records into the new…

A: Required: Which of the following creates a new table in a database and also copies the records into…

Q: In which of the following situations is using a subquery suitable? (refer to the tables in the…

A: Situations suitable for using a subquery: User can find the titles of all books shipped on the same…