for Njosh

capocheers1

Main
Similar Questions

Home >Homework Answsers >Computer Science homework help

A SQL server was installed during unit 1. The installation included SQL Server Management Studio Express. This tool is used to create and manage your database. The next step is to ensure that the installed software was configured correctly. An existing database is available for this purpose. Using an existing database will also enable you experiment with querying a database.

For this project, you will access a database to ensure your software was installed and configured properly. You will explore the SELECT statement by populating the tables with data and retrieve the data from the database tables.

Task 1
- Click hereto download and install the AdventureWorks LT2012 database into the SQL environment. Unzip the file and store the data file and the log file into the Data folder within the folder Program Files (x86)/Microsoft SQL Server as follows:
  - For 64-bit operating systems: copy the files into the folder:
    C:/Program Files/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA
  - For 32-bit operating systems: copy the files into the folder:
    C:/Program Files (x86)/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA
  - The folder listed above will already exist. This is where you installed the SQL software to in DB1.
  - When trying to open the DATA folder, you may receive a message about concerns on accessing the folder. Click ‘continue’ or ‘ok’
- After the files are saved, the database needs to be attached.
  - Open Microsoft SQL Server Management Studio. In the Object Explorer window, right click on Databases, and select Attach.
  - On the Attach Databases window, click the Add button.
  - The Locate Files window will default to the DATA folder, where you just copied the files to. Select the AdventureWorksLT2012_Data.mdf file and click OK.
  - Back in the Attach Databases window, just click OK.
  - The AdventureWorksLT2012 database will now display in Object Explorer under Databases.
Task 2
- Generate a database diagram for all the tables in the database.
  - Include a screenshot of this diagram in your Word document.
Task 3
- Write SELECT statements for the following questions:
  - For each of these statements, include a screenshot of the SQL statements and results. Make sure to include the statement execution, including the resulting data.
    1. Display all columns and all rows from the Customer table.
    2. Display the ProductID, ProductNumber and ListPrice for all rows in the Product table.
    3. Modify query 2 so that the column headings are as follows:
      - "ID," "Number," and "List Price"
    4. Display the CustomerID, full customer name, and Company Name for all customers in the Customer table. The full customer name would be shown by displaying the values separately from the necessary columns. Another optional, and more advanced, approach to show full customer name would be to combine the necessary columns and associate an alias.
    5. Display the CustomerID, full customer name, and Company Name for all customers in the Customer table.
      - Name the columns "ID," "Name," and "Company Name" (respectively), and sort the data by the company name.

Combine all of the screenshots into a single Word document, and submit this for grading.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.

Reference

Code Plex. (2012). AdventureWorks Databases – 2012, 2008R2 and 2008. Retrieved from http://msftdbprodsamples.codeplex.com/releases/view/93587

Grading Rubric

Project Criteria	Exceeds: 90%–100%	Very good: 80%–89%	Meets: 70%–79%	Needs Improvement: Below 70%
Content (75%)	Response covers all topics indicated in the assignment and adds additional content.	Response covers most topics indicated in the assignment.	Response covers many of the topics indicated in the assignment.	Response covers none to some of the topics indicated in the assignment.
Effective Communication (10%)	Demonstrates outstanding or exemplary application of written, visual, or oral skills. Demonstrates outstanding expression of topic, main idea, and purpose. Audience is addressed appropriately. Language clearly and effectively communicates ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are minimal. Organization is clear. Format is consistently appropriate to assignment. Presentation and delivery are confident and persuasive (where applicable). The writing was of collegiate level with no errors in spelling or grammar.	Demonstrates very good written, visual, or oral skills. Demonstrates sound expression of topic, main idea, and purpose. Audience is usually addressed appropriately. Language does not interfere with the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are present, but do not distract from the message. Organization is apparent and mostly clear. Format is appropriate to assignment, but not entirely consistent. The writing was of collegiate level with two or less errors in spelling or grammar.	Demonstrates acceptable written, visual, or oral skills. Demonstrates reasonable expression of topic, main idea, and purpose. Sometimes, audience is addressed appropriately. Language does not interfere with the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are present and may distract from the message. Organization is a bit unclear. Format is inconsistent. The writing was of collegiate level with several errors in spelling or grammar.	Demonstrates inadequate or partially proficient application of written, visual, or oral skills. Demonstrates inadequate or partial expression of topic, main idea, and purpose. Audience is often not addressed appropriately. Language often impedes the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are frequent and often distract from meaning or presentation. Organization is inadequate, confusing, and distracting. Format is inadequate and obscures meaning. The writing was less than collegiate level with numerous errors in spelling or grammar.
Supporting Analysis (15%)	Analysis exceeds minimum requirements. Sources are used to support analysis, are appropriate, and are properly referenced.	Basic analysis provided to support assertions. Sources are cited, appropriate, and properly referenced.	Limited analysis provided to support assertions. Some sources are cited, appropriate, and properly referenced.	No or inaccurate analysis, no sources are cited when needed, analysis and/or sources are not appropriate. When sources used, are not properly referenced.