Explore BrainMass
Share

SQL Database Views

Attached in the zip is the the sample database ITD640_B from the assignment. The sample database represents a company with employees and different stores. Each employee works at just one store. The employees have various jobs in different promotional activities (promotions) and may work on more than one promotion at a time.

database is attached

The following are the tables and data in the ITD640_B database:

Using the sample database, write the scripts in a file called ITD640_P3.SQL to create the following views. Remember to include a USES clause at the top of your script file to use the ITD640_B database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.

Create a view named v_stocker showing the employee number, promotion number, and start date where the job is "stocker."
Create a view called v_no_budget with all the columns of the promotion table except the budget column.
Create a view called v_count that shows the number of employees that are working on each promotion. The view should have columns for the promotion number and the count.

© BrainMass Inc. brainmass.com August 19, 2018, 11:02 pm ad1c9bdddf

Attachments

Solution Summary

The solution contains SQL script file with script to create the 3 requested views.

$2.19