Instructions

Create a relational database structure - no more than 3 tables with 5 records each

1. Based on your database structure

a. Create a Stored Procedure to complete a single transaction.

List what the transaction is

b. Write a SQL statement using a JOIN syntax

c. Write a SQL statement to incorporate ANY of the built in Aggregate functions

d. Write a SQL statement for a View based on any or all of the tables created