[3 points] Help the developers at ACME Random Data Company determine the candidate and 5 possible super keys on the following tables. [2 points]...

[3 points] Help the developers at ACME Random Data Company determine the candidate and 5 possible super keys on the following tables.
[2 points] They also want to know if any of these tables can benefit from implementing a surrogate key. Explain why or why not.
Refer to the Bank_table_definitions.pdf and design queries to solve the following requests.
[2 points] Retrieve the names of all branches in the states WA, OR, and CA.
[3 points] Retrieve the customer ID and Name for all customers who live in a city where the city name ends in "ville". For example, everyone who lives in Nashville or Jacksonville should be returned.
[2 points] List the names of all the employees who work at the Department named "Loan".
[3 points] List the names of bank branch and the number of checking accounts at each branch. Checking accounts have a type of "CHECKING".
[2 points] List all employees who work for John Smith in any bank branch in Oregon (OR).
[3 points] List the names of the customers who made transactions of an amount exceeding $100 any bank branch in Seattle.

Files: ?????????? 2018-10-17 ????? 12.56.01.png