The Car Maintenance team wants to add Tire Change (ID: 1) maintenance task for all cars with the due date of 1 September, 2020. However, the team also wants to know chat if an error occurs the updates will rollback to their previous state. Create a script or them to first add all tasks and then rollback the changes.

2. An instructor created a submission folder for coding submissions from students. The instructor wants to maintain all access to the folder for herself, but wants to give the grading assistants 'read' and 'execute' permission to the folder. However, the grading assistants cannot change anything in the folder. She adds a group 'grader' with the grading assistants for the folder. Nobody else should have any access to the submission folder. The instructor should use : chmod ________ to set the access permission for the submission folder to achieve the above goal.   Hint: Indicate the decimal number corresponding to the permission.

6 DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Thank you!

Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task   Retrieve the mailing address (first name, surname, and address) for each resident.   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.     Alter the RESIDENTS table and change the ID field to an auto-incremented field. 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…

In this lab, you are to create ONE project that contains TWO forms for this assignment. The form and all controls should be named using VB standards. Within the code, using meaningful variable names that meet the VB standards and appropriate data types. Comments are always encouraged. Form 1: Working with Loops - The first form will have two button click events: First Button Click Event: Using a Do Loop with a Sentinel value of−1ask the user to type in the list of courses they have completed (ex: CIS115). As they enter the courses, display the courses in a listbox. Second Button Click Event: Once the course listbox has been populated, the user will select a course from the listbox that will be converted into a new string using the guidelines given below. This event must validate that a course has been selected from the listbox before the process of generating the new string coded name can be done. (Hint: see page 274.) If a course has been selected, that name should be read into the…

Q2:Write a row-level trigger that executes before updating a project's location in the project table. The trigger changes the department number of the project to 4 if the location is in 'Stafford'. COL

Execute a command that undoes the change in Step 7.

Lab 8-1: KimTay Pet Supplies Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer ID, first and last names of the customer, and the invoice date for the invoice whose number currently is stored in I_INVOICE_NUM. Place these values in the variables I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE respectively. When the procedure is called it should output the contents of I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE. IN SQL CODE. CUSTOMER CUST_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL EMAIL BALANCE CREDIT_LIMIT REP_ID 125 Joey Smith 17 Fourth St Cody WY 82414 jsmith17@example.com 80.68 500.00 05 182 Billy Rufton 21 Simple Cir Garland WY 82435 billyruff@example.com 43.13 750.00 10 227 Sandra Pincher 53 Verde Ln Powell WY 82440 spinch2@example.com 156.38 500.00 15 294 Samantha Smith 14 Rock Ln Ralston WY 82440 ssmith5@example.com 58.60 500.00 10 314 Tom Rascal 1 Rascal Farm Rd Cody WY 82414 trascal3@example.com 17.25 250.00 15 375 Melanie Jackson 42…

Note:- Don't  copy from other contents if any wrong i will downvote

Task 1: The InstantRide received some traffic violation tickets from the government. The Legal team of InstantRide requires the travel information of the respective drivers along with corresponding Driving License IDs to proceed further. In addition, the team wants to include the drivers without travel information in the system yet for the completion of driver list. Therefore, you need to return DRIVER_FIRST_NAME, DRIVER_LAST_NAME, DRIVER_DRIVING_LICENSE_ID, TRAVEL_START_TIME, TRAVEL_END_TIME information from the DRIVERS and TRAVELS data connected by LEFT JOIN. Task: Query all drivers with and without travel data. (SQL Database Test)