BIS 345 Lab 6

Student Name:

Using Lab 6, provide copies of your SQL Statements, results, reports and interpretation as listed below

Part A: Product Cost History dataset (7 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part B: Product Cost History report (10 points)

a. Paste your report here:

Part C: Yearly Sales by Category Dataset (10 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part D: Yearly Sales by Category Chart (10 points)

a. Paste your report here:

Part E: Yearly Sales by Category Interpretation (10 points)

Provide an interpretation of the results. The interpretation must be a minimum of one paragraph with no spelling or grammatical errors. Your interpretation should answer the following questions: What information is presented in the chart? Is the chart based on adequate data? Is there something lacking? Can you make meaningful deductions? Based on these results, what other data would you recommend that should be considered for further analysis?

Copyright © 2010 by DeVry Educational Development Corporation.

All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation.

.

Lab 6 Student Answers.docx Page 1 of 1