Description
SQL assignment with tutorials......................................................................................
Unformatted Attachment Preview
IDS 521 – Fall 2018
Assignment #3
Assigned date: October 8, 2018
Due date: October 22, 2018
For this third assignment, you can form a group of one to four students. For this assignment, you need
to do both Tutorial 1 and Tutorial 2. You can download the tutorial files from the IDS 521 Blackboard
site. They are located on the Content page. Be sure you follow the instructions in the tutorial files. In
particular, type each object name (i.e., project name, table name, column name, etc.) as shown in the
tutorials – uppercase, lowercase, and spaces in object names do matter.
To do this assignment, you should have installed the SQL Server 2014 Evaluation edition (which includes
the SQL Server Management Studio and Analysis Server) as well the SQL Server Data Tools. I have posted
on the IDS 521 Blackboard site a PowerPoint file that shows you how to install both the SQL Server 2014
Evaluation edition and the SQL Server Data Tools. This PowerPoint file is located on the Assignments
page on Blackboard.
Tutorial 1 shows you how to create a data mart (data warehouse) for a hypothetical company called
Maximum Miniatures Manufacturing. This data mart is a dimensional data model that is implemented in
a relational database management system (SQL Server 2014). At the end of Tutorial 1, you should have a
data mart called MaxMinManufacturingDM. This data mart has one fact table and nine dimension
tables. All tables are initially empty. You will populate these tables in subsequent tutorials.
Tutorial 2 shows you how to extract data from a transactional database called MaxMinAccounting (you
need to download this database from an external website that is mentioned in Tutorial 2), transform the
extracted data, and then load the data to eight of the nine dimension tables in the
MaxMinManufacturingDM data mart that you created in Tutorial 1. The 9th dimension table (dimBatch),
will be populated in the subsequent tutorial. At the end of Tutorial 2, eight of the nine dimension tables
in the MaxMinManufacturingDM data mart should have been populated.
To complete Assignment 3, you need to do the following:
1. Complete both Tutorial 1 and Tutorial 2.
2. Compress the Integration Services project folder (folder name: MaxMinManufacturingDMLoad)
that you created in Tutorial 2 into a single zip file. On my computer, the Integration Services
project folder is located at C:\Users\\Documents\Visual Studio 2013\Projects.
On your computer, the Integration Services project folder could be located at a similar location.
3. Upload the compressed file to the Blackboard by 11:59PM on October 22, 2018.
Note 1: You do not need to submit the data mart MaxMinManufacturingDM that you created in Tutorial
1 and populated in Tutorial 2. I have a copy of that data mart (an empty data mart).
Note 2: When grading this assignment, your Integration Services project that you created in Tutorial 2
will be tested and executed. It should populate an empty data mart that was created in Tutorial 1.
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Kindly check on the attached zipped f...
Completion Status:
100%
Review
Review
Anonymous
Very useful material for studying!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
CS 1050 DnD Monster Scores Project Program
Description
For the prelab assignment, you need to read a text file. The input data file will be called “DnDMonsterScor ...
CS 1050 DnD Monster Scores Project Program
Description
For the prelab assignment, you need to read a text file. The input data file will be called “DnDMonsterScores.csv”. This
type of file can be opened by spreadsheet programs such as Microsoft Excel, but you can also open it with a text editor like
VIM or Notepad. Of course, you can open it and read it with your program too!
The data file consists of a name followed by numbers on each line (except the first line – the first line is a “header” and has
the word “Name” followed by the word “AC” followed other words representing the name of each “field”, all separated by
commas). All of these “fields” are separated by commas. For example:
Name,AC,HP,STR,DEX,CON,INT,WIS,CHA
Frog,11,1,1,13,8,1,8,3
Sea Horse,11,1,1,12,8,1,10,2
Shrieker,5,13,1,1,10,1,10,3
The file is meant to represent the name of a “monster” in the game Dungeons and Dragons followed by the “armor class”
and then the “hit points”, etc. for that monster.
To get started on this prelab, type the following while logged in to tc.rnet.missouri.edu:
cs1050start prelab11
This command will create a directory called prelab11. Go into that directory (“cd prelab11”) and get a list of the files there
(“ls -la”). Notice that there is a file called prelab11.c. You can start editing this file to do your prelab (but you probably
want to change the header since it says it was written entirely by me ). Notice that the data file (DnDMonsterScores.csv)
is also in this directory.
Your program should read in all of the data (ignoring the “header”), count how many monsters are in the file, and calculate
the average armor class (AC) as well as the average hit points (HP) for the monsters in this file. As you process the file, you
should output the number (count) of the current monster, its name, its armor class, and its hit points (see sample output).
You can read in the other fields as you go or find a way to ignore them
4 pages
Shock Concept Map
Figure 1. Shock concept map. Information on etiology, pathophysiology, assessments, and nursing diagnosis from Medlineplus ...
Shock Concept Map
Figure 1. Shock concept map. Information on etiology, pathophysiology, assessments, and nursing diagnosis from Medlineplus.gov (2017), Schlag and Redl ...
17 pages
Proposal
Before developing the source code, it is important to recognize which are the attributes and the methods that are going to ...
Proposal
Before developing the source code, it is important to recognize which are the attributes and the methods that are going to be part of the class. In ...
CMIT 350 UMUC Network Infrastructure Design Diagram Project
Background: Kamehameha Institute is an organization that provides educational offerings to non-traditional students. The o ...
CMIT 350 UMUC Network Infrastructure Design Diagram Project
Background: Kamehameha Institute is an organization that provides educational offerings to non-traditional students. The organization has tailored its unique educational offerings into the groups shown in Table 1 below:Table 1. Kamehameha Educational Offerings.GroupOfferingKamehameha BrandedFocused on the general public/provides services directly to its studentsCo-BrandedProvides the same services as Kamehameha Branded but resold by a third party and labeled as “…. Kamehameha Strong”White Label BrandedWhile the service offering is the same, these services are labeled solely with the third parties’ informationThe State of Hawai’i regulates the educational sector, driving the need to ensure Kamehameha follows the State’s strict security and regulatory requirements. Kamehameha's leadership is also very concerned with the threat posed by the online theft of their unique intellectual property. Additionally, the number of Hawai’ian entities breached by threat actors is on the rise. Thus, security, privacy, and compliance are all important considerations for the Kamehameha network architecture.Your boss, the Kamehameha Institute's Chief Operating Officer (COO) has tasked you to design a network infrastructure for three facilities located in the Hawaiian Islands of Honolulu, Hilo, and Lihue. The COO stipulated that you must separate the three group offerings in Table 1 and provide for strengthened defenses to protect Kamehameha’s cultural heritage. After meeting with the COO, the two of you drafted the following set of requirements for your network design:Each of the facilities has three floors:The first and second floor of each building requires 150 network connections eachThe third floor of each building houses a data center and requires 75 network connectionsThe Honolulu location requires additional network connections for failover purposesThe Hilo location will be the primary data center and house redundant database serversThe Lihue location will serve as a failover data center and house the primary web servers (including the primary application and primary database servers)A constant connection between the three locations, carrying at least 75 Mbps of dataAll servers at all locations must have redundancyProtection from intrusions is required and should be documentedA plan to verify security and failover measures is requiredSubmission: Using the free tool, daw.io available at https://draw.io (no sign-in or registration required), create a network diagram (drawing) specific to the organization that encompasses the three facilities and also depicts ant necessary interconnections. Figure 1 shows the draw.io ‘new network diagram’ dialog window:Figure 1. Draw.io New File Dialog Showing the Network Diagramming TemplatesYour diagram should include enough detail to show the topology interconnections. The viewer should be able to understand the Kamehameha Institute’s network environment and be able to implement the architecture you develop. Ensure that you properly cite any external sources.One of the keys to producing a viable network diagram is labeling the objects consistently and descriptively. Think about what you would want to know about a network device if you logged into it with little prior information. Consider location, floor number, or other pertinent information. At a minimum, include the following elements:IMPORTANT: Your network diagram must include an identifying label (e.g., callout box) that includes your class and section, assignment title, your name, and the date. Edit the items in italics. Your assignment will not be accepted if this element is missing:Table 2. Example Network Diagram Callout Box.CMIT 350 6980Project #1 Network DiagramStudent Name: NameDate: 6/22/2010Any necessary hardwareSite-to-Site (WAN) connections (e.g., leased line connectivity, satellite, etc.)Annotate the following values for each of the Sites:Network IDUseable RangeSubnet MaskCIDR ValueBroadcast AddressAll devices require hostnames complying with the following naming conventions:Routers: Rx; where x is the site number incremented by a value of 1 for each routerSwitches: Sx; where x is the site number incremented by a value of 1 for each switchServers: SRVx where x is the server number incremented by a value of 1 for each serverFor each site router, implement a private ip addressing scheme using a range suitable for corporate infrastructure and include the following:management vlanproduction vlanHigh availabilityWhen finished, export the diagram as a PDF document (Note: You will need to use this diagram again in Project 3, so ensure you save the xml source file!) and submit it to the Assignment folder. Figure 2 demonstrates how to export your draw.io diagram as a PDF document:Figure 2. Draw.io ‘Export’ as Function to PDFHow Will My Work Be Evaluated?1.1.3: Present ideas in a clear, logical order appropriate to the task.2.2.2: Evaluate sources of information on a topic for relevance and credibility.10.1.1: Identify the problem to be solved.10.1.2: Gather project requirements to meet stakeholder needs.10.1.3: Define the specifications of the required technologies.13.1.1: Create documentation appropriate to the stakeholder.13.2.1: Evaluate vendor recommendations in the context of organization requirements.
11 pages
Failed Organizational Change
Many organizational changes are occurring every day around the world. Some of these organizational changes are successful, ...
Failed Organizational Change
Many organizational changes are occurring every day around the world. Some of these organizational changes are successful, while others are ...
University of Connecticut R Script Project
#REMEMBER THE DATA IS NAMED cdc, don't forget to run the link first!#Don't forget to use $ to separate the name of the dat ...
University of Connecticut R Script Project
#REMEMBER THE DATA IS NAMED cdc, don't forget to run the link first!#Don't forget to use $ to separate the name of the dataset and the column for some questions below ex: mean(cdc$weight) OR attach data with the code attach()#INSTRUCTIONS#Type the codes for each question#Include answers to ALL questions in the script as a comment (with a #).#Questions with a * next to it will ALSO require you to input the answer in Canvas.#Lastly, upload this R script AND input the corresponding answers to Canvas.#If you are missing codes or answers in this script, points will be deducted.source("http://www.openintro.org/stat/data/cdc.R")# 1 View the data# *2 How many observations and variables are there?# 3 Find the names of the variables#Use summary code to view a summary of the age variable *Don't forget to use $ if you didn't attach data# *4 What is the median age? What is the age of the youngest person in the data?# *5 What is the height of the tallest and shortest person *Don't forget to use $ if you didn't attach data# 6 Show the first 3 observations in the dataset# 7 Show the last 5 observations in the dataset# 8 Use the mean code to find the mean of the wtdesire column and save it as av_wtdesire *Don't forget to use $ if you didn't attach data# *9 Run your item, av_wtdesire that you just created# *10 Find the standard deviation of age and the variance of height# 11 View a histogram of height# *12 What class is genhlth# 13 Create a table of hlthplan# *14 What is the 3rd quantile of height and what does it mean? Hint: Use summary code# 15 Find the first 3 observations of the weight column###Normal Distribution#### *16 Let's assume the age a person buys their first house is normally distributed with a mean of 28 years old and a standard deviation of 7 years.#a What is the probability that a person buys their first home younger than 24 years old?#b What is the probability that a person buys their first home older than 35?#c What is the probability that a person buys their first home between 20 and 37 years old?#d What age is the cuttoff value corresponding to the top 20%?#e What age is the cutoff value corresponding to the bottom 30%?
Similar Content
Programming II critical thinking
IMPORTANT NOTE: THIS IS A JAVA APPLICATION AND WE USE ECLIPSE IDECreate a simple GUI Bank Balance application that will ob...
Rutgers University Public Class Year Program
Year Program
Write a program that uses main and two user-defined methods. Both methods use dates, but neither method...
Hudson County Community College Casewell Catering C++ Programming Worksheet
The Casewell Catering and Convention Service have asked you to write a computer program to produce customer’s bill. The...
Website Plan Outline for Italy Visit Website Creation Assignment
- Create a multipage website. The topic of your choice, If no idea, pick country of interest. (like Switzerland or Italy)...
JNTU NA34 Java Code Advanced Data Structures Paper
Assignment 3
Advanced Data Structures
MSCS502
Goal
Building on your GitHub Java project from previous assignments, implem...
ICS 2020 University of California Calculation of Inner Loop Initial Value Questions
Please help me the high school java assignmentThere are almost 10 questions,Thank you!...
Security Within It
Security is among the most discussed topics globally, especially when considering the increase in cyber-attacks over the y...
Sdlc Research Paper 1
This paper has the implementation of the Spiral SDLC model in a web design project. Baidu, Facebook, Google, YouTube, and ...
Description
The first algorithm is used to validate the user. The system prompts the user to enter their credentials and compares them...
Related Tags
Book Guides
Steppenwolf
by Hermann Hesse
The Sun Is Also a Star
by Nicola Yoon
Little Women
by Louisa May Alcott
The Aftermath
by Rhidian Brook
Milkweed
by Jerry Spinelli
Alice in Wonderland
by Lewis Carroll
Their Eyes Were Watching God
by Zora Neale Hurston
The Metamorphosis
by Franz Kafka
All the Kings Men
by Robert Penn Warren
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
CS 1050 DnD Monster Scores Project Program
Description
For the prelab assignment, you need to read a text file. The input data file will be called “DnDMonsterScor ...
CS 1050 DnD Monster Scores Project Program
Description
For the prelab assignment, you need to read a text file. The input data file will be called “DnDMonsterScores.csv”. This
type of file can be opened by spreadsheet programs such as Microsoft Excel, but you can also open it with a text editor like
VIM or Notepad. Of course, you can open it and read it with your program too!
The data file consists of a name followed by numbers on each line (except the first line – the first line is a “header” and has
the word “Name” followed by the word “AC” followed other words representing the name of each “field”, all separated by
commas). All of these “fields” are separated by commas. For example:
Name,AC,HP,STR,DEX,CON,INT,WIS,CHA
Frog,11,1,1,13,8,1,8,3
Sea Horse,11,1,1,12,8,1,10,2
Shrieker,5,13,1,1,10,1,10,3
The file is meant to represent the name of a “monster” in the game Dungeons and Dragons followed by the “armor class”
and then the “hit points”, etc. for that monster.
To get started on this prelab, type the following while logged in to tc.rnet.missouri.edu:
cs1050start prelab11
This command will create a directory called prelab11. Go into that directory (“cd prelab11”) and get a list of the files there
(“ls -la”). Notice that there is a file called prelab11.c. You can start editing this file to do your prelab (but you probably
want to change the header since it says it was written entirely by me ). Notice that the data file (DnDMonsterScores.csv)
is also in this directory.
Your program should read in all of the data (ignoring the “header”), count how many monsters are in the file, and calculate
the average armor class (AC) as well as the average hit points (HP) for the monsters in this file. As you process the file, you
should output the number (count) of the current monster, its name, its armor class, and its hit points (see sample output).
You can read in the other fields as you go or find a way to ignore them
4 pages
Shock Concept Map
Figure 1. Shock concept map. Information on etiology, pathophysiology, assessments, and nursing diagnosis from Medlineplus ...
Shock Concept Map
Figure 1. Shock concept map. Information on etiology, pathophysiology, assessments, and nursing diagnosis from Medlineplus.gov (2017), Schlag and Redl ...
17 pages
Proposal
Before developing the source code, it is important to recognize which are the attributes and the methods that are going to ...
Proposal
Before developing the source code, it is important to recognize which are the attributes and the methods that are going to be part of the class. In ...
CMIT 350 UMUC Network Infrastructure Design Diagram Project
Background: Kamehameha Institute is an organization that provides educational offerings to non-traditional students. The o ...
CMIT 350 UMUC Network Infrastructure Design Diagram Project
Background: Kamehameha Institute is an organization that provides educational offerings to non-traditional students. The organization has tailored its unique educational offerings into the groups shown in Table 1 below:Table 1. Kamehameha Educational Offerings.GroupOfferingKamehameha BrandedFocused on the general public/provides services directly to its studentsCo-BrandedProvides the same services as Kamehameha Branded but resold by a third party and labeled as “…. Kamehameha Strong”White Label BrandedWhile the service offering is the same, these services are labeled solely with the third parties’ informationThe State of Hawai’i regulates the educational sector, driving the need to ensure Kamehameha follows the State’s strict security and regulatory requirements. Kamehameha's leadership is also very concerned with the threat posed by the online theft of their unique intellectual property. Additionally, the number of Hawai’ian entities breached by threat actors is on the rise. Thus, security, privacy, and compliance are all important considerations for the Kamehameha network architecture.Your boss, the Kamehameha Institute's Chief Operating Officer (COO) has tasked you to design a network infrastructure for three facilities located in the Hawaiian Islands of Honolulu, Hilo, and Lihue. The COO stipulated that you must separate the three group offerings in Table 1 and provide for strengthened defenses to protect Kamehameha’s cultural heritage. After meeting with the COO, the two of you drafted the following set of requirements for your network design:Each of the facilities has three floors:The first and second floor of each building requires 150 network connections eachThe third floor of each building houses a data center and requires 75 network connectionsThe Honolulu location requires additional network connections for failover purposesThe Hilo location will be the primary data center and house redundant database serversThe Lihue location will serve as a failover data center and house the primary web servers (including the primary application and primary database servers)A constant connection between the three locations, carrying at least 75 Mbps of dataAll servers at all locations must have redundancyProtection from intrusions is required and should be documentedA plan to verify security and failover measures is requiredSubmission: Using the free tool, daw.io available at https://draw.io (no sign-in or registration required), create a network diagram (drawing) specific to the organization that encompasses the three facilities and also depicts ant necessary interconnections. Figure 1 shows the draw.io ‘new network diagram’ dialog window:Figure 1. Draw.io New File Dialog Showing the Network Diagramming TemplatesYour diagram should include enough detail to show the topology interconnections. The viewer should be able to understand the Kamehameha Institute’s network environment and be able to implement the architecture you develop. Ensure that you properly cite any external sources.One of the keys to producing a viable network diagram is labeling the objects consistently and descriptively. Think about what you would want to know about a network device if you logged into it with little prior information. Consider location, floor number, or other pertinent information. At a minimum, include the following elements:IMPORTANT: Your network diagram must include an identifying label (e.g., callout box) that includes your class and section, assignment title, your name, and the date. Edit the items in italics. Your assignment will not be accepted if this element is missing:Table 2. Example Network Diagram Callout Box.CMIT 350 6980Project #1 Network DiagramStudent Name: NameDate: 6/22/2010Any necessary hardwareSite-to-Site (WAN) connections (e.g., leased line connectivity, satellite, etc.)Annotate the following values for each of the Sites:Network IDUseable RangeSubnet MaskCIDR ValueBroadcast AddressAll devices require hostnames complying with the following naming conventions:Routers: Rx; where x is the site number incremented by a value of 1 for each routerSwitches: Sx; where x is the site number incremented by a value of 1 for each switchServers: SRVx where x is the server number incremented by a value of 1 for each serverFor each site router, implement a private ip addressing scheme using a range suitable for corporate infrastructure and include the following:management vlanproduction vlanHigh availabilityWhen finished, export the diagram as a PDF document (Note: You will need to use this diagram again in Project 3, so ensure you save the xml source file!) and submit it to the Assignment folder. Figure 2 demonstrates how to export your draw.io diagram as a PDF document:Figure 2. Draw.io ‘Export’ as Function to PDFHow Will My Work Be Evaluated?1.1.3: Present ideas in a clear, logical order appropriate to the task.2.2.2: Evaluate sources of information on a topic for relevance and credibility.10.1.1: Identify the problem to be solved.10.1.2: Gather project requirements to meet stakeholder needs.10.1.3: Define the specifications of the required technologies.13.1.1: Create documentation appropriate to the stakeholder.13.2.1: Evaluate vendor recommendations in the context of organization requirements.
11 pages
Failed Organizational Change
Many organizational changes are occurring every day around the world. Some of these organizational changes are successful, ...
Failed Organizational Change
Many organizational changes are occurring every day around the world. Some of these organizational changes are successful, while others are ...
University of Connecticut R Script Project
#REMEMBER THE DATA IS NAMED cdc, don't forget to run the link first!#Don't forget to use $ to separate the name of the dat ...
University of Connecticut R Script Project
#REMEMBER THE DATA IS NAMED cdc, don't forget to run the link first!#Don't forget to use $ to separate the name of the dataset and the column for some questions below ex: mean(cdc$weight) OR attach data with the code attach()#INSTRUCTIONS#Type the codes for each question#Include answers to ALL questions in the script as a comment (with a #).#Questions with a * next to it will ALSO require you to input the answer in Canvas.#Lastly, upload this R script AND input the corresponding answers to Canvas.#If you are missing codes or answers in this script, points will be deducted.source("http://www.openintro.org/stat/data/cdc.R")# 1 View the data# *2 How many observations and variables are there?# 3 Find the names of the variables#Use summary code to view a summary of the age variable *Don't forget to use $ if you didn't attach data# *4 What is the median age? What is the age of the youngest person in the data?# *5 What is the height of the tallest and shortest person *Don't forget to use $ if you didn't attach data# 6 Show the first 3 observations in the dataset# 7 Show the last 5 observations in the dataset# 8 Use the mean code to find the mean of the wtdesire column and save it as av_wtdesire *Don't forget to use $ if you didn't attach data# *9 Run your item, av_wtdesire that you just created# *10 Find the standard deviation of age and the variance of height# 11 View a histogram of height# *12 What class is genhlth# 13 Create a table of hlthplan# *14 What is the 3rd quantile of height and what does it mean? Hint: Use summary code# 15 Find the first 3 observations of the weight column###Normal Distribution#### *16 Let's assume the age a person buys their first house is normally distributed with a mean of 28 years old and a standard deviation of 7 years.#a What is the probability that a person buys their first home younger than 24 years old?#b What is the probability that a person buys their first home older than 35?#c What is the probability that a person buys their first home between 20 and 37 years old?#d What age is the cuttoff value corresponding to the top 20%?#e What age is the cutoff value corresponding to the bottom 30%?
Earn money selling
your Study Documents