MIS Writeup - 3

MIS Writeup - 3 - Steven Beatty Database Assignment MIS Mon...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Steven Beatty Database Assignment MIS: Mon, Wed 5-6:15 Once the all the tables were linked properly within the database, queries and reports could be done to answer questions. A general overview of the data within the database was answered using queries. The first question asked, how many different vendors has the firm placed orders with so far? Firstly, I created a query (Appendix 3A) that shows all the vendors and the number of orders they have placed. To answer the question I created another query (Appendix 3A-1) that took a count of all the vendors which came to an answer of nine. The next question asked, how many unique items were ordered? I first created a query that showed all the unique items which can be seen in Appendix 3B. The second query was a count of all the items which came to an answer of sixteen unique items ordered. The next question asked how many of each item was purchased. Which item was purchased the most? The least? The answer to this question can be seen in Appendix 3C. The Airframe Fasteners and O-Rings were purchased the most while Wheel 1, 2, 3 were all purchased the least. The final question asked how many orders
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

MIS Writeup - 3 - Steven Beatty Database Assignment MIS Mon...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online