Question: SUBJECT: Bus Intelligence & Data Whse Create a relational database structure - no more than 3 tables with 5 records each 1. Based on your
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 post table too which you created.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
