Management Information Systems (MIS) > QUESTIONS & ANSWERS > MIS 341 RELATIONAL DATABASE DESIGN 1, L. STEWART MIS 341 - Lab 6. All Answers (All)

MIS 341 RELATIONAL DATABASE DESIGN 1, L. STEWART MIS 341 - Lab 6. All Answers

Document Content and Description Below

MIS 341 RELATIONAL DATABASE DESIGN 1, L. STEWART ....There are two parts to the lab. You will need to complete each section of this document. Save your document with the following naming convention:  Course_Lab Number_First Initial Last Name (Example: MIS341_Lab6_LStewart.docx) Complete Chapter 13 (Cengage Text) Problem: 1 all parts a-g, 5, 6, 7, 8, and 9 Pg. 639-644 For problem 1, use the “Ch13_P1_SQL.txt” script file. For problems 5-9, use the “Ch13-SaleCo-DW_SQL.txt” script file. Be sure you’re using the appropriate database in SQL Server when running these scripts. My Guitar Shop Exercises – Managing Database Security (Chapter 17 Murach) In these activities, you’ll use SQL Server Management Studio to enter SQL statements and run them against the MyGuitarShop database. In addition to providing screen prints,. 1. Write a script that:  Creates a user-defined database role named OrderEntry in the MyGuitarShop database  Give INSERT and UPDATE permission to the new role for the Orders and OrderItems table  Give SELECT permission for all user tables. 2. Write a script that:  Creates a login ID named “RobertHalliday” with the password “HelloBob”  Sets the default database for the login to the MyGuitarShop database  Creates a user named “RobertHalliday” for the login  Assigns the user to the OrderEntry role you created in Exercise 1. 3. Write a script that:  Uses dynamic SQL and a cursor to loop through each row of the Administrators table  Create a login ID for each row in that consists of the administrator’s first and last name with no space between  Set a temporary password of “temp” for each login  Set the default database for the login to the MyGuitarShop database  Create a user for the login with the same name as the login  Assign the user to the OrderEntry role you created in Exercise 1. 4. Using the Management Studio:  Create a login ID named “RBrautigan” with the password “RBra9999”  Set the default database to the MyGuitarShop database  Grant the login ID access to the MyGuitarShop database  Create a user for the login ID named “RBrautigan”  Assign the user to the OrderEntry role you created in Exercise 1. Note: If you get an error that says “The MUST_CHANGE option is not supported”, you can deselect 5. Write a script that removes the user-defined database role named OrderEntry. (Hint: This script should begin by removing all users from this role.) 6. Write a script that (1) creates a schema named Admin, (2) transfers the table named Addresses from the dbo schema to the Admin schema, (3) assigns the Admin schema as the default schema for the user named RobertHalliday that you created in exercise 2, and (4) grants all standard privileges except for REFERENCES and ALTER to RobertHalliday for the Admin schema.hhdh

[Show More]

Last updated: 3 years ago

Preview 1 out of 7 pages

Buy Now

Instant download