Chat with us, powered by LiveChat Bike Stores is a small business chain that sells bicycles at stores in California, Texas, and New York. The business owners w - School Writers

Bike Stores is a small business chain that sells bicycles at stores in California, Texas, and New York. The business owners w

 

Assessment Instructions

Bike Stores is a small business chain that sells bicycles at stores in California, Texas, and New York. The business owners would like several reports to be generated that provide information on company sales. These reports will leverage data currently stored in the BikeStores database. You will install Microsoft Report Builder on the same system you have Microsoft SQL Server and SQL Server Management Studio (SSMS) installed. You will then generate column chart, bar chart, line chart, pie chart, and tabular reports presenting various views of BikeStores sales.

It is very important that you watch the Module 5 videos associated with SQL prior to completing the assessment. You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:
Microsoft SQL Server Express
Microsoft SSMS

Navigate to the Academic Tools area of this Module and select Library then Required Readings to access your texts and videos. You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course.

You must have SQL Server Express and SQL Server Management Studio (SSMS) installed to complete this assessment. The sample database for this module is called BikeStores. The database creation script, installation instructions, and database diagram can be downloaded below:

Use the BikeStores database design diagram to help address applicable assessment tasks. You will need to fully understand the BikeStores database design for this assessment.

You must also install the Microsoft Report Builder application. The following document provides instructions on how to install Microsoft Report Builder:

Provide your assessment task responses in a Microsoft® Word® report document. Also, incorporate a screenshot of each completed Microsoft Report Builder report into the assessment document as proof of completed work.

Task 1 – Generate a Column Chart Report

You are tasked to generate a column chart report showing the top five bike sales. Use the following guidance document to generate the column chart report:

Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.

Examine the generated column chart report. What information can be drawn from this report? What assertions can be made from this report?

Task 2 – Generate a Pie Chart Report

You are tasked to generate a pie chart report showing the sales percentage for each bike category. Use the following guidance document to generate the pie chart report:

Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.

Examine the generated pie chart report. What information can be drawn from this report? What assertions can be made from this report? 

Task 3 – Generate a Bar Chart Report

You are tasked to generate a bar chart report showing monthly sales for each BikeStores location in the year 2017. Use the following guidance document to generate the bar chart report:

Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.

Examine the generated bar chart report. What information can be drawn from this report? What assertions can be made from this report? 

Task 4 – Generate a Line Chart Report

You are tasked to generate a line chart report showing monthly sales for each bike category in the year 2016. Use the following guidance document to generate the line chart report:

Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.

Examine the generated line chart report. What information can be drawn from this report? What assertions can be made from this report? 

Task 5 – Generate a Tabular Report

You are tasked to generate a tabular report showing bike category sales by year. Use the following guidance document to generate the tabular report:

Describe how the query contained in the common table expression (CTE) works. Are correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how are the results filtered? Are table joins used in the query? If yes, what tables are linked together? Are aggregate functions leveraged in the query? If yes, describe what results are being sought along with the applicable grouping parameters.

Examine the generated tabular report. What information can be drawn from this report? What assertions can be made from this report?

BikeStores Database Design Diagram

,

Instructions for Establishing the BikeStores Database

[1] Download the BikeStores database creation script (Create-BikeStores-Database.sql) to

an accessible location on the computer system hosting the Microsoft SQL Server

software.

[2] Open the Microsoft SQL Server Management Suite (SSMS) application. In the top

menu, select FILE → OPEN → FILE.

[3] The OPEN FILE window will appear. Navigate to the computer folder/directory that

contains the database creation script. Select the script file and then click on the OPEN

button.

[4] A query window will appear containing the contents of the database creation script.

Click on the tab for the window to ensure it is the active window. Then click on the

EXECUTE button to execute the database creation script. It may take one or more

minutes for the script to complete.

[5] A script completion message will appear in the lower window pane of the Microsoft

SSMS application. This will confirm that the BikeStores database has been installed.

FIRST, CLICK

ON THIS TAB

THEN EXECUTE

THE SCRIPT

[6] In the Object Explorer pane, click on the refresh button ( ) to refresh the list of database

objects.

[7] Expand the Databases item in the Object Explorer window pane. The BikeStores

database should now appear in the expanded list of databases.

,

MICROSOFT REPORT BUILDER INSTALLATION INSTRUCTIONS

[1] Access the following site in your web browser:

https://www.microsoft.com/en-us/download/details.aspx?id=53613

Download and install the Microsoft Report Builder application on the same computer

system that is running your Microsoft SQL Server Express application.

[2] The Microsoft Report Builder download site will be presented. Click on the

DOWNLOAD button to download the installation program.

[3] The installation program should download by default to your DOWNLOADS folder on

your system. However, you may receive a prompt similar to that below asking for a

download location. Place the file in an accessible folder on your system.

[4] Located the file in your system using the Windows File Explorer application. Double-

click on the installation program to begin the Microsoft Report Builder installation

process.

[5] The welcome screen will appear. Click on the NEXT button to continue.

[6] You’ll then see the License Agreement screen. Click on the “I accept the terms ….”

option and click on the NEXT button to continue

[7] The Feature Selection screen will then appear. Accept the default options and click on

the NEXT button to continue.

[8] The Default Target Server screen will then appear. Leave the entry blank and click on

the NEXT button to continue.

[9] The Ready screen will then appear. Click on the INSTALL button to commence the

installation process.

[10] You may receive a User Account Control prompt like that presented below. Click on the

YES button to continue the installation process.

[11] You’ll see the installation completion screen after the install finishes. Click on the

FINISH button to close out the installation process.

[12] To start the Microsoft Report Builder application, access the Windows Start menu and

select the Microsoft Report Builder folder.

[13] You’ll then see the Getting Started screen in Microsoft Report Builder. You are now all

set to generate reports.

,

CREATING A BIKESTORES COLUMN CHART REPORT

[1] To start the Microsoft Report Builder application, access the Windows Start menu and

select the Microsoft Report Builder folder.

[2] You’ll then see the Getting Started screen in Microsoft Report Builder. Click on the

Chart Wizard option.

[3] You’ll be presented with the New Chart screen. Click on the “Create a dataset” option

and click the NEXT button to continue.

[4] You will then see a screen asking for you the “Choose a connection to a data source.”

Click on the NEW button.

[5] You will then see the Data Source Properties screen. You can leave the Name value as

is or provide a preferred name. In the Connection String field, enter the following value:

Data Source=localhostSQLEXPRESS

Click on the TEST CONNECTION to verify the connection string. You should receive

a “Connection created successfully” message. Click on the OK button close out the

prompt. Then click on the OK button on the Data Source Properties screen to complete

the data source specification.

[6] You’ll be returned to the “Choose a connection to a data source screen.” Make sure the

new data source entry is highlighted and then click on the NEXT button to continue.

[7] You’ll then see the “Design a query” screen. Click on the “Edit as Text” option in the

top left portion of the screen.

[8] In the provided text field area, enter the following SQL statements:

USE BikeStores;

WITH BikeStores_Sales_CTE (BikeName, BikeSales, BikesSold)

AS(

SELECT product_name,

(SELECT SUM(SOI1.quantity*SOI1.list_price)

FROM Sales.Order_Items SOI1

WHERE SOI1.product_id = PR.product_id) AS TotalSales,

(SELECT SUM(SOI2.quantity)

FROM Sales.Order_Items SOI2

WHERE SOI2.product_id = PR.product_id) AS BikesSold

FROM Production.Products PR

)

SELECT TOP 5 BikeName, BikeSales

FROM BikeStores_Sales_CTE

ORDER BY BikeSales DESC;

[9] Click on the exclamation point ( ) to execute and test the entered SQL code. A total

of 5 records should be returned from the SQL statements. Then click on the NEXT

button to continue.

[10] You will then see the “Choose a chart type” screen. Select the Column option and then

click on the NEXT button.

[11] You will then be presented with the “Arrange fields” screen. Double-click on the

BikeName and BikeSales entries in the “Available fields” list. The items will

automatically populate the “Categories” and “Values” areas. Click on the NEXT button

to continue.

[12] You’ll then see the “Preview” screen. Click on the FINISH button.

[13] The configured report screen will then be presented in the main Report Builder window.

You can add a title as specified on the screen. Click on the RUN button in the upper left

corner of the window to test out the report.

[14] The generated report should look similar to what is provided below. Take a screenshot of

your generated report as proof of report completion for the assignment. Incorporate the

screenshot into your assignment document. Then click on the DESIGN button in the

upper left corner of the window to return to the main Report Builder screen.

[15] Save the Report Builder file via FILE–>SAVE AS from the top menu. Provide an

applicable file name for the Report Builder file. You can then exit from the Report

Builder application.

,

CREATING A BIKESTORES LINE CHART REPORT

[1] To start the Microsoft Report Builder application, access the Windows Start menu and

select the Microsoft Report Builder folder.

[2] You’ll then see the Getting Started screen in Microsoft Report Builder. Click on the

Chart Wizard option.

[3] You’ll be presented with the New Chart screen. Click on the “Create a dataset” option

and click the NEXT button to continue.

[4] You will then see a screen asking for you the “Choose a connection to a data source.”

Click on the NEW button.

[5] You will then see the Data Source Properties screen. You can leave the Name value as

is or provide a preferred name. In the Connection String field, enter the following value:

Data Source=localhostSQLEXPRESS

Click on the TEST CONNECTION button to verify the connection string. You should

receive a “Connection created successfully” message. Click on the OK button close out

the prompt. Then click on the OK button on the Data Source Properties screen to

complete the data source specification.

[6] You’ll be returned to the “Choose a connection to a data source screen.” Make sure the

new data source entry is highlighted and then click on the NEXT button to continue.

[7] You’ll then see the “Design a query” screen. Click on the “Edit as Text” option in the

top left portion of the screen.

[8] In the provided text field area, enter the following SQL statements:

USE BikeStores;

WITH BikeStores_Monthly_Bike_Category_Sales_CTE (BikeCategory,

SalesMonth, SalesYear, SalesAmount) AS

(

SELECT category_name AS BikeCategory, MONTH(order_date) AS SalesMonth,

YEAR(order_date) AS SalesYear, SUM(OI.quantity*OI.list_price*(1-

OI.discount)) AS SalesAmount

FROM Production.Categories CT INNER JOIN Production.Products PR

ON CT.category_id = PR.category_id

INNER JOIN Sales.Order_Items OI

ON OI.product_id = PR.product_id

INNER JOIN Sales.Orders OD

ON OD.order_id = OI.order_id

GROUP BY category_name, MONTH(order_date), YEAR(order_date)

)

SELECT BikeCategory, SalesMonth, SalesAmount

FROM BikeStores_Monthly_Bike_Category_Sales_CTE

WHERE SalesYear = 2016

ORDER BY BikeCategory, SalesMonth;

[9] Click on the exclamation point ( ) to execute and test the entered SQL code. A total

of 71 records should be returned from the SQL statements. Then click on the NEXT

button to continue.

[10] You will then see the “Choose a chart type” screen. Select the Line option and then

click on the NEXT button.

[11] You will then be presented with the “Arrange chart fields” screen. Left-click on the

BikeCategory item with your mouse and drag it to the Series area. Left-click on the

SalesMonth item with your mouse and drag it to the Categories area. Left-click on the

SalesAmount item with your mouse and drag it to the Values area. The item placement

should look like what is presented below. Click on the NEXT button to continue.

[12] You’ll then see the “Preview” screen. Click on the FINISH button.

[13] The configured report screen will then be presented in the main Report Builder window.

Click on the RUN button in the upper left corner of the window to test out the report.

[14] The generated report should look similar to what is provided below. Take a screenshot of

your generated report as proof of report completion for the assignment. Incorporate the

screenshot into your assignment document. Then click on the DESIGN button in the

upper left corner of the window to return to the main Report Builder screen.

[15] Save the Report Builder file via FILE–>SAVE AS from the top menu. Provide an

applicable file name for the Report Builder file. You can then exit from the Report

Builder application.

,

CREATING A BIKESTORES PIE CHART REPORT

[1] To start the Microsoft Report Builder application, access the Windows Start menu and

select the Microsoft Report Builder folder.

[2] You’ll then see the Getting Started screen in Microsoft Report Builder. Click on the

Chart Wizard option.

[3] You’ll be presented with the New Chart screen. Click on the “Create a dataset” option

and click the NEXT button to continue.

[4] You will then see a screen asking for you the “Choose a connection to a data source.”

Click on the NEW button.

[5] You will then see the Data Source Properties screen. You can leave the Name value as

is or provide a preferred name. In the Connection String field, enter the following value:

Data Source=localhostSQLEXPRESS

Click on the TEST CONNECTION to verify the connection string. You should receive

a “Connection created successfully” message. Click on the OK button close out the

prompt. Then click on the OK button on the Data Source Properties screen to complete

the data source specification.

[6] You’ll be returned to the “Choose a connection to a data source screen.” Make sure the

new data source entry is highlighted and then click on the NEXT button to continue.

[7] You’ll then see the “Design a query” screen. Click on the “Edit as Text” option in the

top left portion of the screen.

[8] In the provided text field area, enter the following SQL statements:

USE BikeStores;

WITH BikeStores_Bike_Category_Sales_CTE (BikeCategoryName, BikeSales,

BikesSold) AS

(

SELECT category_name,

(SELECT SUM(SOI1.quantity*SOI1.list_price)

FROM Sales.Order_Items SOI1 INNER JOIN Production.Products PR1

ON SOI1.product_id = PR1.product_id

WHERE PR1.category_id = CT.category_id) AS TotalSales,

(SELECT SUM(SOI2.quantity)

FROM Sales.Order_Items SOI2 INNER JOIN Production.Products PR2

ON SOI2.product_id = PR2.product_id

WHERE PR2.category_id = CT.category_id) AS BikesSold

FROM Production.Categories CT

)

SELECT BikeCategoryName, BikeSales

FROM BikeStores_Bike_Category_Sales_CTE

ORDER BY BikeCategoryName;

[9] Click on the exclamation point ( ) to execute and test the entered SQL code. A total

of 7 records should be returned from the SQL statements. Then click on the NEXT

button to continue.

[10] You will then see the “Choose a chart type” screen. Select the Pie option and then click

on the NEXT button.

[11] You will then be presented with the “Arrange fields” screen. Double-click on the

BikeCategoryName and BikeSales entries in the “Available fields” list. The items will

automatically populate the “Categories” and “Values” areas. Click on the NEXT button

to continue.

[12] You’ll then see the “Preview” screen. Click on the FINISH button.

[13] The configured report screen will then be presented in the main Report Builder window.

You can add a title as specified on the screen. Right-click on the pie item in the chart and

select the Show Data Labels item in the right-click menu.

[14] Right-click on one of the data labels contained within the pie chart. Select the Series

Label Properties item from the right-click menu.

DATA LABELS

[15] In the General section of the Series Label Properties window, enter #PERCENT into

the Label Data text field. Then click on the OK button to apply the change.

[16] In the main Report Builder screen, click on the RUN button in the upper left corner of the

window to test out the report.

[17] The generated report should look similar to what is provided below. Take a screenshot of

your generated report as proof of report completion for the assignment. Incorporate the

screenshot into your assignment document. Then click on the DESIGN button in the

upper left corner of the window to return to the main Report Builder screen.

[18] Save the Report Builder file via FILE–>SAVE AS from the top menu. Provide an

applicable file name for the Report Builder file. You can then exit from the Report

Builder application.

,

CREATING A BIKESTORES TABULAR REPORT

[1] To start the Microsoft Report Builder application, access the Windows Start menu and

select the Microsoft Report Builder folder.

[2] You’ll then see the Getting Started screen in Microsoft Report Builder. Click on the

Table or Matrix Wizard option.

[3] You’ll be presented with the New Table or Matrix screen. Click on the “Create a

dataset” option and click the NEXT button to continue.

[4] You will then see a screen asking for you the “Choose a connection to a data source.”

Click on the NEW button.

[5] You will then see the Data Source Properties screen. You can leave the Name value as

is or provide a preferred name. In the Connection String field, enter the following value:

Data Source=localhostSQLEXPRESS

Click on the TEST CONNECTION to verify the connection string. You should receive

a “Connection created successfully” message. Click on the OK button close out the

prompt. Then click on the OK button on the Data Source Properties screen to complete

the data source specification.

[6] You’ll be returned to the “Choose a connection to a data source screen.” Make sure the

new data source entry is highlighted and then click on the NEXT button to continue.

[7] You’ll then see the “Design a query” screen. Click on the “Edit as Text” option in the

top left portion of the screen.

[8] In the provided text field area, enter the following SQL statements:

USE BikeStores;

WITH BikeStores_Store_Performance_CTE (BikeCategory, SalesYear,

SalesAmount) AS

(

SELECT category_name, YEAR(OD.order_date) AS SalesYear,

SUM(OI.quantity*OI.list_price*(1-OI.discount)) AS SalesAmount

FROM Production.Categories CT INNER JOIN Production.Products PR

ON CT.category_id = PR.category_id

INNER JOIN Sales.Order_Items OI

ON PR.product_id = OI.product_id

INNER JOIN Sales.Orders OD

ON OD.order_id = OI.order_id

GROUP BY category_name, YEAR(OD.order_date)

)

SELECT BikeCategory, SalesYear, SalesAmount

FROM BikeStores_Store_Performance_CTE

ORDER BY BikeCategory, SalesYear;

[9] Click on the exclamation point ( ) to execute and test the entered SQL code. A total

of 20 records should be returned from the SQL statements. Then click on the NEXT

button to continue.

[10] You will then be presented with the “Arrange fields” screen. Left-click on the

BikeCategory item with your mouse and drag it to the Row Groups area. Left-click on

the SalesYear item with your mouse and drag it to the Column Groups area. Left-click

on the SalesAmount item with your mouse and drag it to the Values area. The item

placement should look like what is presented below. Click on the NEXT button to

continue.

[11] You’ll then see the “Choose the layout” screen. Enter a checkmark for the “Show

subtotals and grand totals” option. Click on the NEXT button to continue.

[12] You’ll then see the “Preview” screen. Click on the FINISH button.

[13] The configured report screen will then be presented in the main Report Building window.

You can add a title as specified on the screen. Right-click on the cell containing

Sum(SalesAmount) and select the Placeholder Properties item from the right-click

menu.

[14] In Placeholders Properties window, access the Number area and select the Currency

option in the Category section. Enter a checkmark for the Use 1000 Separator (,) item.

Click on the OK button to apply the change.

[15] Repeat Steps 13 and 14 for the other report cells that start with the term Sum.

[16] Click on the RUN button in the upper left corner of the window to test out the report.

[17] The generated report should similar to what is provided below. Take a screenshot of your

generated report as proof of report completion for the assignment. Incorporate the

screenshot into your assignment document. Then click on the DESIGN button in the

upper left corner of the window to return to the main Report Builder screen.

[18] Save the Report Builder file via FILE–>SAVE AS from the top menu. Provide an

applicable file name for the Report Builder file. You can then exit from the Report

Builder application.

,

/* ——————————————————————– © 2017 sqlservertutorial.net All Rights Reserved ——————————————————————– Name : BikeStores Version: 1.0 ——————————————————————– */ — create database/ CREATE DATABASE BikeStores; GO — access database/ USE BikeStores; GO — create schemas CREATE SCHEMA production; go CREATE SCHEMA sales; go — create tables CREATE TABLE production.categories ( category_id INT IDENTITY (1, 1) PRIMARY KEY, category_name VARCHAR (255) NOT NULL ); CREATE TABLE production.brands ( brand_id INT IDENTITY (1, 1) PRIMARY KEY, brand_name VARCHAR (255) NOT NULL ); CREATE TABLE production.products ( product_id INT IDENTITY (1, 1) PRIMARY KEY, product_name VARCHAR (255) NOT NULL, brand_id INT NOT NULL, category_id INT NOT NULL, model_year SMALLINT NOT NULL, list_price DECIMAL (10, 2) NOT NULL, FOREIGN KEY (category_id) REFERENCES production.categories (category_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (brand_id) REFERENCES production.brands (brand_id) ON DELETE CASCADE ON UPDATE CASCADE ); CREATE TABLE sales.customers ( customer_id INT IDENTITY (1, 1) PRIMARY KEY, first_name VARCHAR (255) NOT NULL, last_name VARCHAR (255) NOT NULL, phone VARCHAR (25), email VARCHAR (255) NOT NULL, street VARCHAR (255), city VARCHAR (50), state VARCHAR (25), zip_code VARCHAR (5) ); CREATE TABLE sales.stores ( store_id INT IDENTITY (1, 1) PRIMARY KEY, store_name VARCHAR (255) NOT NULL, phone VARCHAR (25), email VARCHAR (255), street VARCHAR (255), city VARCHAR (255), state VARCHAR (10), zip_code VARCHAR (5) ); CREATE TABLE sales.staffs ( staff_id INT IDENTITY (1, 1) PRIMARY KEY, first_name VARCHAR (50) NOT NULL, last_name VARCHAR (50) NOT NULL, email VARCHAR (255) NOT NULL UNIQUE, phone VARCHAR (25), active tinyint NOT NULL, store_id INT NOT NULL, manager_id INT, FOREIGN KEY (store_id) REFERENCES sales.stores (store_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (manager_id) REFERENCES sales.staffs (staff_id) ON DELETE NO ACTION ON UPDATE NO ACTION ); CREATE TABLE sales.orders ( order_id INT IDENTITY (1, 1) PRIMARY KEY, customer_id INT, order_status tinyint NOT NULL, — Order status: 1 = Pending; 2 = Processing; 3 = Rejected; 4 = Completed order_date DATE NOT NULL, required_date DATE NOT NULL, shipped_date DATE, store_id INT NOT NULL, staff_id INT NOT NULL, FOREIGN KEY (customer_id) REFERENCES sales.customers (customer_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (store_id) REFERENCES sales.stores (store_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (staff_id) REFERENCES sales.staffs (staff_id) ON DELETE NO ACTION ON UPDATE NO ACTION ); CREATE TABLE sales.order_items ( order_id INT, item_id INT, product_id INT NOT NULL, quantity INT NOT NULL, list_price DECIMAL (10, 2) NOT NULL, discount DECIMAL (4, 2) NOT NULL DEFAULT 0, PRIMARY KEY (order_id, item_id), FOREIGN KEY (order_id) REFERENCES sales.orders (order_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (product_id) REFERENCES production.products (product_id) ON DELETE CASCADE ON UPDATE CASCADE ); CREATE TABLE production.stocks ( store_id INT, product_id INT, quantity INT, PRIMARY KEY (store_id, product_id), FOREIGN KEY (store_id) REFERENCES sales.stores (store_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (product_id) REFERENCES production.products (product_id) ON DELETE CASCADE ON UPDATE CASCADE ); /* DATA FOR THE BIKESTORES DATABASE */ USE BikeStores; SET IDENTITY_INSERT production.brands ON; INSERT INTO production.brands(brand_id,brand_name) VALUES(1,'Electra') INSERT INTO production.brands(brand_id,brand_name) VALUES(2,'Haro') INSERT INTO production.brands(brand_id,brand_name) VALUES(3,'Heller') INSERT INTO production.brands(brand_id,brand_name) VALUES(4,'Pure Cycles') INSERT INTO production.brands(brand_id,brand_name) VALUES(5,'Ritchey') INSERT INTO production.brands(brand_id,brand_name) VALUES(6,'Strider') INSERT INTO production.brands(brand_id,brand_name) VALUES(7,'Sun Bicycles') INSERT INTO production.brands(brand_id,brand_name) VALUES(8,'Surly') INSERT INTO production.brands(brand_id,brand_name) VALUES(9,'Trek') SET IDENTITY_INSERT production.brands OFF; SET IDENTITY_INSERT production.categories ON; INSERT INTO production.categories(category_id,category_name) VALUES(1,'Children Bicycles') INSERT INTO production.categories(category_id,category_name) VALUES(2,'Comfort Bicycles') INSERT INTO production.categories(category_id,category_name) VALUES(3,'Cruisers Bicycles') INSERT INTO production.categories(category_id,category_name) VALUES(4,'Cyclocross Bicycles') INSERT INTO production.categories(category_id,category_name) VALUES(5,'Electric Bikes') INSERT INTO production.categories(category_id,category_name) VALUES(6,'Mountain Bikes') INSERT INTO production.categories(category_id,category_name) VALUES(7,'Road Bikes') SET IDENTITY_INSERT production.categories OFF; SET IDENTITY_INSERT production.products ON; INSERT INTO production.products(product_id, product_name, brand_id, category_id, model_year, list_price) VALUES(1,'Trek 820 – 2016',9,6,2016,379.99) INSERT INTO production.products(product_id, product_name, brand_id, category_id, model_year, list_price) VALUES(2,'Ritchey Timberwolf Frameset – 2016',5,6,2016,749.99) INSERT INTO production.products(product_id, product_name, brand_id, category_id, model_year, list_price) VALUES(3,'Surly Wednesday Fram

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?