Discount Get BIS 445 ALL WEEKS Solution ONLY $95.94
BIS 445 Lab 1 - an Original and A++ Work !!! [$15.99]
BIS 445 Lab 2 - an Original and A++ Work !!! [$15.99]
BIS 445 Lab 3 - an Original and A++ Work !!! [$15.99]
BIS 445 Lab 4 - an Original and A++ Work !!! [$15.99]
BIS 445 Lab 5 - an Original and A++ Work !!! [$15.99]
BIS 445 Lab 6 - an Original and A++ Work !!! [$15.99]
Get Selected Weeks Solution with ONLY NOT Add Selected Tutorials To Cart
BIS445 - BIS 445 iLab 1 - BIS 445 Lab 1 - Part A and Part B - an Original and A++ Work !!!
    BIS445 - BIS 445 iLab 1 - BIS 445 Lab 1 - Part A and Part B - an Original and A++ Work !!! BIS445 - BIS 445 iLab 1 - BIS 445 Lab 1 - Part A and Part B - an Original and A++ Work !!! BIS445 - BIS 445 iLab 1 - BIS 445 Lab 1 - Part A and Part B - an Original and A++ Work !!!

BIS445 - BIS 445 iLab 1 - BIS 445 Lab 1 - Part A and Part B - an Original and A++ Work !!!

$15.99

iLab 1, Part a: Using action queries in SQL
You have been requested to import a comma delimited text file into an existing SQL 2008 database. Using the SQL 2008 Import
Utility, you will create field mappings for a new SQL 2008 table and then upload your text file into this new table. After you
upload your text file, you will perform some action queries to add, delete, and modify data in your new table.
Upon completing this lab, you will be able to:
Import text file data into an existing SQL 2008 database and create a 1. new SQL 2008 table.
2. Use action queries to add, delete, and modify data.
Submit the YourName_Lab1A_Questions.docx to the Week 1 iLab Dropbox.
Section Deliverable Points
Part A Import comma delimited text file. 6
Part B Review uploaded data. 6
Part C Add records into a table. 6
Part D Delete records in a table. 6
Part E Modify records in a table. 6
Download the Lab1A_Questions.docx from Doc Sharing. You will answer the questions and provide screen prints as
required for each part of the iLab.
1.
2. Create a folder on your C drive named Transfer.
Print
Submit your assignment to the Dropbox located on the silver tab at the top of this
page.
(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)
i L A B O V E R V I E W
Scenario and Summary
Deliverables
i L A B S T E P S

Preparation Back to Top
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
1 of 20 9/7/2014 3:07 PM
Download the CustomerData.txt file from Doc Sharing to your folder 3. named Transfer.
Login to the Citrix remote lab.
a. Follow the login instructions located in the iLab tab in Course Home.
Upload your txt file to your Citrix drive using the instructions provided in the iLab tab in Course Home. Pay
particular attention to the Saving from Citrix video.
b.
4.
Part A: Import CustomerData.txt File into a SQL 2008 Database
Import a comma delimited file into an existing SQL 2008 database. You will need to include the column headers, map the
comma delimited data to an appropriate data type, and then upload the data into a new table in a pre-existing SQL 2008
database. If at any point you receive a Client File Security pop up window, select Full Access and then click OK.
Open your Citrix Laboratory, click the SQL 2008 Import Utility and then click Next to get to the Choose a Data Source
screen.
a.
b. On the Choose a Data Source screen select from the Data Source pull down the Flat File Source.
Click the Browse button and navigate to your Transfer folder, select your CustomerData text file and then click Open to
select your CustomerData.txt file for the File Name.
c.
d. Check Column names in the first data row on the Choose a Data Source screen.
e. Your screen should look similar to the following:
STEP 1: Problem Description Back to Top
STEP 2: Label Title Back to Top
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
2 of 20 9/7/2014 3:07 PM
Click Next twice to get to the Choose f. A Destination screen.
g. Leave the default SQL Server Native Client 10.0 for Destination.
h. Insert into the Server Name combo box your server: BIS445SQL2008
In the Database combo box area select BIS445_CoffeeMerchant for your Database. You do not have the access rights
in the Citrix Lab area to create a New database.
i.
j. Your screen should look similar to the following:
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
3 of 20 9/7/2014 3:07 PM
Click Next to get to the Select Source Tables k. and Views screen.
Click Edit Mappings on the Select Source Tables and Views screen. Change the Type column to get more meaningful
SQL field types.
l.
Note: This is only necessary for first-time use. If this is not your first-time through this process simply click Next.
m. Your field type selections should look similar to the following:
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
4 of 20 9/7/2014 3:07 PM
Click OK on the Column Mappings screen n. and then click Next.
o. Scroll down in the Review Data Type Mapping screen until you see for the Source column CreditLimit.
Scroll to the right until you see the On Error Column. Click in the On Error cell for CreditLimit to activate the combo box
and then select Ignore.
p.
Click the next cell to the right, On Truncation column in the CreditLimit cell, and change the combo box entry to
ignore.
q.
r. Your Review Data Type Mapping screen should look like the following:
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
5 of 20 9/7/2014 3:07 PM
Click Next twice and then Finish until you see the end of the SQL s. 2008 Import wizard.
Your results at the end of the import wizard should look similar to this.
STEP 3: Sample Output Back to Top
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
6 of 20 9/7/2014 3:07 PM
Using the Lab1A_Questions, answer the questions for Part A and paste a copy of your import wizard execution results.
Click the Close button to end your import wizard.
Part B: Review uploaded data
After importing your comma delimited text file into a new temporary table in an existing SQL 2008 database, you will need to
create new dimension tables and a fact table.
Click the SQL 2008 Server a. Management Studio.
b. Select Full Access for the Citrix File Security screen as follows:
STEP 4: Deliverable Back to Top
Problem Description Back to Top
STEP 2: Create the dimension and fact tables for your star schema data warehouse. Back to Top
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
7 of 20 9/7/2014 3:07 PM
On the Connect to Server screen, Server type should be Database Engine, Server Name should be BIS445SQL2008,
Authentication is Windows Authentication.
c.
Click Connect to see the Object Explorer in your Microsoft SQL Server Management d. Studio area.
e. Expand your Databases node, the BIS445_CoffeeMerchant node, and then the Tables node.
f. You should see a new CustomerData table in your Tables node area.
g. Right click your dbo.CustomerData node and select Design.
h. Inspect your table for field types.
i. Create a new Project.
j. Create a new SQL Query.
Create a SQL query using the following to show your uploaded data. You will need to insert the appropriate script in the
‘??’ position to make the query run:
k.
l. Save your query as SQLQuery1A-B and execute your SQL script.
m. Take a screen shot of your query results.
Your screen shot should look similar to this:
STEP 3: Sample Output Back to Top
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
8 of 20 9/7/2014 3:07 PM
Using the Lab1A_Questions, answer the questions for Part B.
Part C – Use action queries to insert data into a SQL 2008 table.
After reviewing your uploaded data, you will need to add records to your new table.
Create a new SQL script to insert the following information into the 1. CustomerData table.
2. Save the SQL as SQLQuery1A-C. Execute the SQL Statement.
3. Take a screen shot of your query results.
STEP 4: Deliverable Back to Top
STEP 1: Problem Description Back to Top
STEP 2: Write a SQL query to insert a record into your CustomerData table. Back to Top
ConsumerID: 45678
FirstName: Mary
LastName: Alvarez
Street: 123 A Street
City: Los Angeles
State: CA
Zipcode: 91234
Phone: (123) 456-7890
Fax: (987) 654-3210
CreditLimit: 500
Your new script should look similar to the following:
Step 3: Sample Output Back to Top
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…
9 of 20 9/7/2014 3:07 PM
Your results should look similar to this:
Using the Lab1A_Questions, answer the questions for Part C.
Part D – Use SQL Statements to delete data from a SQL 2008 table
Your CustomerData table needs to be maintained so you have been asked to delete some records based on different criteria.
You have been asked to write a SQL statement that will delete a. ConsumerID 45678.
b. Save your SQL query as SQLQuery1D1 and execute the statement.
c. Create a SQL statement that will delete all records that are from the state of California or Texas.
d. Save you SQL query as SQLQuery1D2 and execute the statement.
e. Make a note of many records that were deleted.
Write 1 SQL query that will prove that no records exist for ConsumerID 45678 or the Consumer is from California or
Texas.
f.
g. Save you SQL query as SQLQuery1D3 and execute the statement.
h. Take a screen shot of your query results.
Your results should look similar to this:
Step 4: Deliverable Back to Top
STEP 1: Problem Description Back to Top
Step 2: Enhance SQL script and execute it Back to Top
STEP 3: Sample Output Back to Top
iLab https://devry.equella.ecollege.com/file/a30186d7-8d7b-436e-82d8-cda7f…

Here is complete solution for BIS445 lab 1

If you have more questions, please contact me via email support@extutorials.com

I will help you any time

Thank you

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad           Good

Enter the code in the box below:



PURCHASE SAVE
2 Tutorials 10%
3 Tutorials 13%
4 Tutorials 16%
5 Tutorials 19%
6 Tutorials 22%
7 Tutorials 25%
8 Tutorials 28%
9 Tutorials 31%
10 Tutorials 34%
add url more

9MZQASHWN73B