Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. What does each letter in ACID stand for in the context of database transactions? Describe a concrete example (i.e. a scenario) to illustrate the
a. What does each letter in ACID stand for in the context of database transactions? Describe a concrete example (i.e. a scenario) to illustrate the property the letter "I" refers to. B. For the product ordering database practables-null.sql adapted from in Practical 7 (we now allow CUS AREACODE and P DESCRIPT to be NULL), do the following database queries in SQL. To replace your existing database, you can first just drop all the relevant tables in the right order, see the first few lines in prac Stables-null.sql, and then just run the script practables-null.sql to reconstruct a slightly modified database. For each query, take a (readable) screenshot for the query result and the screenshot is to include the SQL script/statement window as well. a. (Database Preparation) On top of those existing records prac8data.sql, enter into the database at least the following additional records additionalRecords.sql before completing the rest of the questions INSERT INTO Product VALUES ('T-101', 'Impact Drill', '03-NOV-03',8,5,109.99,0.00,NULL); INSERT INTO Cus_order VALUES (111666, NULL, '25-SEP-95'); INSERT INTO ORDER_DETAIL VALUES (111666, 'LZQ202', 1); INSERT INTO ORDER_DETAIL VALUES (111666, 'T-101', 1); INSERT INTO ORDER DETAIL VALUES (333111, 'T-101', 1); If you run into problems in the above, you can also just reconstruct the table and reload all the data by merely executing this SQL script practabledata-reload.sql. In fact, before finalising your answers, refresh your database by reloading practabledata-reload.sql. if necessary, so that the results are uniform across the board. b. List order number (ORDER CODE). order date (ORDDATETIME) and the customer's last name (CUS_LNAME) for all orders, including the orders which contain no customer names
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started