LAB6 - IT 3233 Database Design and Implementation Lab SQL...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
IT 3233 – Database Design and Implementation Lab – SQL Server Security Part 1 Dr. Cheryl Aasheim Instructions: Download and attach the file with the sample database from Georgia View. Create SQL/TSQL code to do each of the following tasks listed below. When you successfully complete a query, cut & paste the SQL code into a Word document and label the query according to the problem number to which it corresponds. Name the Word document LastName_Lab6.docx . 1. Create and test views: a) Create a view of the employee table for each department that only has the employees for that department. Do not use the WITH CHECK OPTION clause. Name the views v_emp_research, v_emp_accounting, and v_emp_marketing. CREATE VIEW v_emp_research AS SELECT emp_no , emp_fname , emp_lname, dept_no FROM employee WHERE dept_no = 'd1' ; CREATE VIEW v_emp_accounting AS SELECT emp_no , emp_fname , emp_lname, dept_no FROM employee WHERE dept_no = 'd2' ; CREATE VIEW v_emp_marketing AS SELECT emp_no , emp_fname , emp_lname, dept_no FROM employee WHERE dept_no = 'd3'
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/13/2012 for the course IT 3233 taught by Professor Aashiem during the Fall '11 term at Georgia Southern University .

Page1 / 4

LAB6 - IT 3233 Database Design and Implementation Lab SQL...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online