Database Security and Auditing Lab
This lab requires MS SQL Server and Oracle.
The requirement of the lab is listed as deliverables. The deliverable is abbreviated as "D" in this manual.
Deliverable 1-7 can be completed using either Oracle or MS SQL Server.
D1. Create table Product - include SQL script and screen shot in the lab report.
|
ProductID (primary key)
|
ProductName
|
ListPrice
|
Category
|
|
int, not null
|
Not null, length 50
|
$
|
int, not null
|
D2. Add values to table Product - include SQL script in the lab report. If you received errors, explain why and show how you corrected those errors
|
ProductID
|
Name
|
ListPrice
|
Category
|
D3. Update the name of a product whose ID is 299 to "Small Chest" - include SQL script and screen shot of successful execution in the lab report
D4. Select all unique categories from product table. - include SQL script and screenshot of successful execution in the lab report.
D5. Delete all products in category 12 - include SQL script and screenshot of successful execution in the lab report.
D6. Create view Product_Category11 that will include only products from category 11 - include SQL script and screenshot of successful execution in the lab report.
D7. Display all products from Category 11 - include SQL script and screenshot of successful execution in the lab report.
Deliverable 8 & 9 should be completed using Oracle
D8. ORACLE: Display List of all tables in Database (hint use DBA_TABLES) - include SQL script in the lab report.
D9. Display information about all columns in Customers table. (hint use OE schema and DESC) - - include SQL script in the lab report.
Deliverable 10 & 11 should be completed using MS SQL
D10. Display List of all tables in AdventureWorks database (hint use INFORMATION_SCHEMA system view) - - include SQL script in the lab report.
D11. Display information about all columns in Production.Product table (hint use INFORMATION_SCHEMA system view) - include SQL script in the lab report.