User Account

All Pages

Generate a database diagram for all the tables

Assignment Help Management Information Sys
Reference no: EM131644003

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 here to 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:

For 32-bit operating systems: copy the files into the folder:

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.

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.

Display all columns and all rows from the Customer table.

Display the ProductID, ProductNumber and ListPrice for all rows in the Product table.

Modify query 2 so that the column headings are as follows:

"ID," "Number," and "List Price"

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.

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.

Reference no: EM131644003

Questions Cloud

Describe patient education strategies : Describe patient education strategies. Describe follow-up and any referrals that may be necessary.
Determine angelos foreign tax offset : HI3042 Taxation Law Assignment. All of Angelo's foreign income amounts have been converted to Australian dollars. Determine Angelo's foreign tax offset
Economic growth and incumbent vote share in the election : What do these data imply about the relationship between economic growth and incumbent vote share in the election?
Discuss among them difficulty with mobility : A nurse is employed at a long-term care facility where many elderly residents have multiple complex health issues, among them difficulty with mobility
Generate a database diagram for all the tables : Generate a database diagram for all the tables in the database - Display all columns and all rows from the Customer table
Define nephew who lives nearby and has asthma : During your visit to Urgent Care, A mother tells you that she is worried about her nephew who lives nearby and has asthma
Discuss the role of data dictionaries : Discuss the role of data dictionaries. Identify the information that should be stored in the data dictionary repository
Define the patient about alcohols effects : the patient questions the nurse regarding alcohol consumption. What would the nurse be correct in telling the patient about alcohol's effects
Describe how business uses information systems : Describe how business uses information systems and provide some examples for each information system - Transaction processing systems

Reviews

Write a Review

Management Information Sys Questions & Answers

  Create a business impact analysis on sangrafix

Create a business impact analysis on SanGrafix a video game design company. The BIA should include a descriptive list of the organization's key business areas. The BIA helps to identify and prioritize critical IT systems and components. A template..

  Advantage and disadvantages of microsoft bitlocker

Create document that outlines the advantage and disadvantages of Microsoft BitLocker. How it is implemented and what the alternatives are in providing security

  Identify the data components of each object

Identify all the (relevant) nouns and verbs. From the list of nouns, select the objects. Identify the data components of each object.

  Activity normal crash and event

Activity Normal Crash and Event - CPM: Network diagram - The subsequent data have been collected for a certain project

  What aspects of ethical relativism do you identify

What aspects of ethical relativism do you identify and agree with? What aspects do you disagree with? Give a personal example that illustrates your stance on ethical relativism, describing how you made a moral decision in an ethical dilemma. Inc..

  Discuss the different methods by which you can analyze

Excel provides many different ways in which to analyze data.  Discuss the different methods by which you can analyze data in your spreadsheet.  Assume the role of a Regional Manager for a retail organization looking at ways to analyze the large amoun..

  Research an open source software project

Research an open source software project.create a presentation with slides that describe the open source software and how it works.

  Development specialist to develop these functionalities

The mobile application side of this solution will require secure and encrypted connections. Please work with your Security and Network Specialists to develop an appropriate solution for wireless communication in the mobile application. Include the..

  Describe knowledge network cycle that transforms knowledge

describe the knowledge network cycle that transforms individual knowledge into organizational knowledge. Be sure to identify any key transformations.

  Create an argument for the hims development method

Create an argument for the HIMS development method you think would be the most effective in a health care organization

  Analyze system vulnerabilities exploited by hackers

Analyze system vulnerabilities exploited by hackers. Design plans that remove Trojans, backdoors, and malware from infected systems.

  Define governance of information within organizations

Examine the principles requiring governance of information within organizations. Use technology and information resources to research legal issues in information security.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd