Can you answer these ASAP please

SUBJECT: Bus Intelligence & Data Whse

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. Create a Trigger. Write a SQL statement to use the trigger

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

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