1. Describe what makes a relational database "relational". Define "primary key" and "foreign key" and how they work together.

2. Which keyword is used to query data from the database?

--SELECT

--EXTRACT

--EXPORT

--INSERT INTO QUERY

3. Which keyword is used to add new records to the database?

--STORE

--INSERT

--CREATE RECORD

--ADD

4. Which keyword is used to change existing data in the database?

--CHANGE

--UPDATE

--MODIFY

--INSERT

5. Which keyword is used to remove records from the database?

--REMOVE

--DESTROY

--DELETE

--DROP

6. What is the SQL to select all fields from a table called 'users' where the value of the column 'first_name' is 'Jonathan'?

7. What is the SQL to select all fields from a table called 'users' where the value of the column 'first_name' starts with the letter 'A'?

8. What is the SQL to select the columns 'first_name' and 'last_name' from the 'customers' table along with their related 'appointment_date' from the 'appointments' table with a single query? Both tables have a primary key of 'id' and the 'appointments' table has a foreign key of 'customer_id'.

9.What is the SQL to add a record to the 'users' table for the user 'Michael Beck' with the username 'beckmd' if the fields are 'first_name', 'last_name', and 'username'?

10. What is the SQL to update a record in the 'users' table if the field to update is 'username' and the new value is 'mbeck' for the user whose id is 5.