week four IT330 help

Now that you have your design elements in place, start on the implementation phase. Refer to the attached Lab 4: Intro SQL document to complete this lab exercise.

1. Confirm the AdventureWorks2012 database is attached. If the database is not attached, follow these steps to place the database in the engine::

a. Create a new folder called DBs on the C: drive

b. Go to: http://msftdbprodsamples.codeplex.com/releases/view/55330

c. Locate and download the “AdventureWorks2012_Data.zip” file

d. Decompress the downloaded file. The will create a folder called “AdventureWorks2012_Data” that contains the following files:

1. <AdventureWorks2012_Data.mdf

2. AdventureWorks2012_log.ldf

e. Copy both of the above files into the following location: C:\DB

f. Grant permissions for BOTH files to users following these instructions

2. Write DML commands such as: INSERT, SELECT, COMMIT, UPDATE, ROLLBACK, DELETE

3. Submit screenshots, SQL codes, and answers

For additional details, please refer to the Lab Rubric document in the Assignment Guidelines and Rubrics section of the course