SQL PROGRAMMING QUESTION:

1. Using the 'books' database (which can be found in the attached)

- Write a one to many join that will select all of the author's first and last names where their royalty share is 1.00. (authors, authors_title)

- Write the same using, but using the subquery method

2. Write the create statement for this table:

Table name: Customer

- Primary Key

- Firstname, lastname, address, email, age, gender fields

Table name: Bank Account

- Primary key

- Account "nickname" text field

- Date field with a default date value of the date the record was created

- Foreign key linked to the customer table

- "Date of last transaction" field

- Account balance

3. Define the proper constraints: nulls, uniques, primary and foreign keys.