The following Form is same as 2nd example of lecture 17 with 2 additional button "Fetch" and "Reset" remaining button functionality remains same. Table name is product with column ID,Name and Price. User enter ID and click on Fetch button, it will get record from Database against the given ID and display Name and Price and disable ID text box and also disable Insert button. So user can update or delete the fetched record. On reset it will bring the form and fields on normal state. You have to implement all button functionality. O Form2 ID Fetch Reset Name Price Insert Update Delete

Task 5: The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation.

Task 2 Stored PL/SQL procedure Implement a stored PL/SQL procedure PARTSUPPLIER that lists information about the supplier key and supplier name supplying parts. The procedure first computes the total number of suppliers supplying the specified part. The procedure then extracts the supplier's information supplying the specified part. The information to be displayed include the part key, part name, the supplier key and the supplier's name. An example of a segment of the output for the list of suppliers supplying a specified part (part 59396) is as follow: part key: 59396, orange cream sandy lavender drab Number of suppliers supplying the part: 4 supplier Key 166 Supplier#000000166 935 Supplier#000000935 1704 Supplier#000001704 2397 Supplier#000002397 supplier Name It is up to you to decide if you want to handle exception in your procedure. Deliverables Submit your spooled file solution2.lst (or solution2.pdf) that contains your SQL script and the output from the execution of the script.…

Q7:- Choose the correct statement:- Prints the database_information connection = getDbConnection()             test1 =connection.get_server_info()             cursor = connection.cursor()             cursor.execute("select database();")             test2 = cursor.fetchone()             print(test2)             closeDbConnection(connection) Prints the records for the selected database connection = getDbConnection()             test1 = connection.get_server_info()             cursor = connection.cursor()             cursor.execute("select database();")             test2 = cursor.fetchone()             print(test1)             closeDbConnection(connection)   Both None of these

Create a table in your own database using the following statement. CREATE TABLE DateRange (DateID INT IDENTITY, DateValue DATE, DayOfWeek SMALLINT, Week SMALLINT, Month SMALLINT, Quarter SMALLINT, Year SMALLINT ); Write a stored procedure that accepts two parameters: A starting date The number of the consecutive dates beginning with the starting date The stored procedure then inserts data into all columns of the DateRange table according to the two provided parameters.

Using the WideWorldDistributors database and the Sales schema create a function that takes InvoiceID as an input parameter and returns all the rows from the table InvoiceLines for the InvoiceID value passed into the function. If the result is a NULL return a zero

Solve all parts with explanation and Don't use ai to answer

Assignment 6: Creating the Babbage Bookkeeping Database 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 Query.”   Create a query from the Client table to display the cities in ascending order. Each city should appear only once (i.e., no repeating city).  Save the query as “Q24-City-Sorting Query.”   Create a query to display the Client Number, Client Name, and Balance fields for all clients where the bookkeeper number is 24 or 34 and the balance is greater than $300.00. Save the query as “Q25-Client-Bookkeeper24-34 Query.”   Create a query to display the First Name,…

Write a stored procedure named updateUnitsOnOrder(). The updateUnitsOnOrder ()procedure should update the UnitsOnOrder field of those products that are discontinued. It should set the UnitsOnOrder field to 99 for those discontinued products. Hint: There is no need to use cursor processing for this stored procedure.

The development team of StayWell wants to ensure that all the STATE fields of the owners are uppercase in the database. Create the state_insert trigger prior to incorporation in the OWNER table to ensure that this requirement is satisfied. Task   Create the state_insert trigger prior to incorporation in the OWNER table to ensure that all the STATE fields of the owners are uppercase in the database.