There are three tables: CUSTOMER, MOVIE, and RENTAL. The RENTAL table stores: the customer’s primary key as a foreign key (customer_id) the movie’s primary key as a foreign key (movie_id) The relationship between CUSTOMER and MOVIE is  _____________.

What clause sorts the rows in a SELECT statement?

Which of the following returns a list of employee names, formatted as “LAST_NAME, FIRST_NAME” from the EMPLOYEE table, sorted by last name, then first name?

Write a SQL query that will return the PRODUCT_ID, DESCRIPTION, INVENTORY_QTY, and UNIT_PRICE for all products (PRODUCT table) with a unit price of at least $10 (data type of field is DECIMAL) and inventory quantity of more than 100 (data type is INTEGER), sorted by inventory quantity from largest to smallest.

What symbol is used to select all columns from a table?

What keyword is used to eliminate any duplicate rows in a SELECT statement?

Complete the SQL statement to modify the balance in the CUSTOMER table by adding 250 to the existing balance for customers with customer_id values of 5, 10, and 23. customer balance + customer_id (5, 10, 23);

Complete the SQL statement to create a new record in the person table.   person (person_id, fname, lname, gender, birth_date)                   (5, ‘William’, ‘Turner’, ‘M’, ‘1972-05-27’);

A primary key that uses two or more fields is known as a __________.

Explain how transactions work and why they are useful in terms of ACID (minimum 50 words). [10 pts] After your explanation, write out the basic syntax using two examples, making up table and field names as needed: demonstrate a transaction that permanently saves all changes [8 pts] Your choice of two INSERTs, an INSERT+UPDATE or two UPDATEs demonstrate a transaction that returns the database back to its pre-transaction state, assuming at least one of the DML operations failed [8 pts] Your choice of two INSERTs, an INSERT+UPDATE or two UPDATEs Feel free to make up table and field names for your CRUD/DML operations as needed.