module.2.session.1.handouts

module.2.session.1.handouts - 9/13/2009 Module 2: Data...

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

View Full Document Right Arrow Icon
9/13/2009 1 Module 2: Data Management Session 1: Database Capabilities & Concepts: Part 1 Dr. Russ Robbins Describe what a [relational] database is… Explain how a database can be helpful to an organization Know when to use a database versus a spreadshee spreadsheet Have some ideas about how data is accessed from a database using a particular technique known as SQL Know which three database vendors own 90% of the DBMS market. We will discuss importance of data and what you should think about when using and managing data I will demonstrate similar activities using a database & a spreadsheet to show you, how in some cases, databases are the better tool. We will discuss characteristics of relational (the most common) databases. We will see an example of a portion of a relational database. We will compare spreadsheets and databases again. We will quickly review the database marketplace.
Background image of page 1

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

View Full DocumentRight Arrow Icon
9/13/2009 2 What are some examples of valuable or important data? What do you think is a company’s most important asset? Why? In your future (or current) career in what ways do you think you will be using data? How important a role will data play in what you do day-to-day? What are the challenges and issues associated with: Collecting – “Where does it come from?” Storing – “Where is it kept” Using data – “How is it accessed?”
Background image of page 2
9/13/2009 3 1. Good for large quantities of data 2. Good for shared access 3. Good for repeated access in same way 4. Good for many, many 1. Good for lists 2. Good for small amounts of data 3. Good for personal data used especially Database Spreadsheet different types of requests. 5. Good for capturing data 6. Good for 3, 4, 5 in 2 nd column just for your job. 4. Good for filtering 5. Good for sorting 6. Good for summing, averaging, etc. The following database: intl_sales.mdb contains international sales information. It is stored in two “related” tables: ORDER and COUNTRY A Sales Manager wants to “query” (i.e., ask) the database about the following the database about the following: 1. Total Orders by Product.
Background image of page 3

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

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

This note was uploaded on 09/18/2009 for the course BUSMIS 1060 taught by Professor Robbins during the Fall '09 term at Pittsburgh.

Page1 / 12

module.2.session.1.handouts - 9/13/2009 Module 2: Data...

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

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