create a SQLITE database or use an existing database and create a table in the database called "Ages": CREATE TABLE Ages ( name VARCHAR(128), age INTEGER ) Then make sure the table is empty by deleting any rows that you previously inserted, and insert these rows and only these rows with the following commands: DELETE FROM Ages; INSERT INTO Ages (name, age) VALUES ('Darrius', 17); INSERT INTO Ages (name, age) VALUES ('Dustin', 25); INSERT INTO Ages (name, age) VALUES ('Aibidh', 24); INSERT INTO Ages (name, age) VALUES ('Baron', 33); INSERT INTO Ages (name, age) VALUES ('Kayden', 33); Once the inserts are done, run the following SQL command:SELECT hex(name || age) AS X FROM Ages ORDER BY X Find the first row in the resulting record set and enter the long string that looks like 53656C696E613333. Note: This assignment must be done using SQLite - in particular, the SELECT query above will not work in any other database. So you cannot use MySQL or Oracle for this assignment.

The SQLiteOpenHelper and SQLiteCursor classes are described, with a focus on how they may be used to perform create, read, update, and delete (CRUD) actions on a SQLite database.

Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals. Create a procedure to calculate the VAT. 1   Make sure you are using the following format to change the delimiter for the procedure: DELIMITER $$-- statements --END $$DELIMITER ;   Test QueryCALL VATCalculator() Expected Results TRAVEL_ID VAT 5001 1.24 5002 1.64 5003 0.99 5004 2.12 5005 0.89 5006 1.05 5007 0.30 5008 1.51 5009 1.08 5010 1.64

Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

Composite main keys have prospective keys.

Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys.   Answer in MYSQL please

The Sqlite.py file contains several very specific queries:         select_Query = "select sqlite_version()"        delete_query = "DELETE from Database where id = "+str(id)        sel = 'SELECT id FROM Database WHERE name == "{0}"'.format(value)        insert_query = """INSERT INTO Database (id, name, photo, html) VALUES (?, ?, ?, ?)"""        sqlite_select_query = """SELECT * from Database"""        table_query = '''CREATE TABLE Database (                                id INTEGER PRIMARY KEY,                                name TEXT NOT NULL,                                photo text NOT NULL UNIQUE,                                html text NOT NULL UNIQUE)'''                                Write a QueryBuilder function.  The QueryBuilder builds a generic Query to build ANY Query type (i.e. version, delete, select, insert, select, table).  The QueryBuilder parameters require:  The type of Query, the input tuple data and then constructs a query string based on the parameters.…

calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal")  , or ("description", amount, "deposit").  The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100

Go to the w3schools website’s SQL browser IDE. This is where you canwrite and test your SQL code using their databases. Once you are happywith it, paste your code in a text file named Student.txt and save it in yourtask folder.● Write the SQL code to create a table called Student. The table structure issummarised in the table below (Note that STU_NUM is the primary key):Attribute Name Data TypeSTU_NUM CHAR(6)STU_SNAME VARCHAR(15)STU_FNAME VARCHAR(15)STU_INITIAL CHAR(1)STU_STARTDATE DATECOURSE_CODE CHAR(3)PROJ_NUM INT(2)● After you have created the table in question 1, write the SQL code to enterthe first two rows of the table as below:STU_NUMSTU_SNAMESTU_FNAMESTU_INITIALSTU_STARTDATECOURSE_CODEPROJ_NUM01 Snow John E 05-Apr-14 201 602 Stark Arya C 12-Jul-17 305 11● Assuming all the data in the Student table has been entered as shownbelow, write the SQL code that will list all attributes for a COURSE_CODE of305.…

6.7 LAB - Create Vehicle and EventVehicle tables The California DMV's completed table diagram is presented in the zyBook. The following is a portion of the table di Vehicle VehicleID TypeCode R YearNumber R MakeCode R ModelName R PlateID R VehicleEvent StateCode R -restrict- • VehicleID RegistrationDate -restrict- • EventNumber