SQL Queries

CLICK HERE TO DOWNLOAD THIS TUTORIAL INSTANTLY $9.99 Only

Using the relational database that you created for your Assignments 2 and 3 add the following:
1. A calculated column “annual bonus” to the table “WorksFor” ( annual bonus equals 12% of the salary)

2. A view that provides information on every store’s managers, employees, and their salaries, per city.

3. A new table “Vendor” associated with the table “Company”

4. Add at least one secondary index to the non-key attribute of your choice.
When you’ve finished, generate the script, copy & paste it to Notepad document, and submit it as an email attachment.
Note: When scripting the database, be sure to check that the “Script Indexes” option is set to “True” (to check, click the “Advanced” button on the “Scripting Options” tab and look under “Table/View Options”) – SQL script files should be attached as text file.