Reference no: EM13324918
For this project, you will set up a database and populate the tables with data to explore theSELECT statement and retrieve data from the tables. Ensure that the SQL Server Management Studio is set up and installed.
Task #1
Install the Northwind Database into the environment. Clickhere to install the database.
Note that this link does link to the SQL Server 2000 Sample Databases, but after downloading it, the ZIP file can be extracted and contained inside the package as a file named "instnwnd.sql." This file can be opened and executed inside of Microsoft SQL Server Management Studio.
Task #2
Generate a database diagram.
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. Make sure to include the statement execution, including the resulting data.
Display all columns and all rows from the Employees table.
9 rows returned
-Display the regionid, regiondescription for all rows in the Regions table.
4 rows returned
-Modify query 2 so that the column headings are as follows:
"ID" and"Description"
4 rows returned
-Display the customer ID, customer name, and region for all customers.
91 rows returned
-Display the customer ID, customer name, and region for all customers.
Name the columns "ID," "Name," and "Region" (respectively), and sort the data by the company name.
91 rows returned
|
Explain a mitochondrion is producing atp at a constant rate
: A mitochondrion is producing ATP at a constant rate and, then, a chemical uncoupler is added. Compared to before the uncoupler was added
|
|
How long will it take her to run a mile at this speed
: While running a marathon, a long-distance runner uses a stopwatch to time herself over a distance of 100. How long will it take her to run a mile at this speed
|
|
How to calculate the ph of sodium formate solution
: Given 217 mL of a buffer solution that is 0.46 M formic acid and 0.27 M sodium formate, calculate the pH of this solution after the addition of 2.8 mL of 6.3 M hydrochloric acid. The Ka of formic acid is 1.8x10-4
|
|
With what temperature does the air emerge
: The rear end of an air conditioner dumps 1.2 * 10^7 J/hr of waste heat into the air outside a building. A fan assists in the removal of this heat. With what temperature does the air emerge
|
|
Generate a database diagram
: For each of these statements, include a screenshot of the SQL. Make sure to include the statement execution, including the resulting data. Display all columns and all rows from the Employees table.
|
|
Explain what is the path these electrons use
: What is the path these electrons use in the Electron Transport Chain? Answer A. Complex I, Complex II, Complex III, Complex IV, O2 to H2O B. Complex II, Complex III, Complex IV, O2to H2O C.
|
|
Prepare a scenario diagram for problem
: Write a PhoneContact class that gets initialized with a phone number and a label. The phone number should follow one of the formats of the Phone class from the previous assignment - Prepare a scenario diagram for Problem 1, Brief discussion for Pro..
|
|
Compute the ph of a solution made by dissolving of sodium
: Calculate the pH of a solution made by dissolving 2.89 g of sodium fluoride and 17.1 mL of 0.309 M hydrofluoric acid in enough water to make 177 mL of solution.
|
|
Most influential architecture is michaelangelo
: In my opinion, the most influential architecture is Michaelangelo, the work titled "the Creation of Adam." Explain why. The most influential architecture in Nashville is the state capitol building? Explain why. Who was the architect.
|