module.2.session.1.slides

module.2.session.1.slides - BUSMIS 1060 Module 2 Data...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style  9/22/09 BUSMIS 1060 Module 2: Data Management Dr. Russ Robbins
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/22/09 Describe what a [relational] database is… Explain how a database can be helpful to an  organization Know when to use a database versus a  spreadsheet Have some ideas about how data is accessed  from a database using a particular technique  known as SQL  After today’s lecture you will be 
Background image of page 2
 9/22/09 We will discuss importance of data and what you  should think about when using and managing data I will demonstrate similar activities using  a  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. Agenda
Background image of page 3

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

View Full DocumentRight Arrow Icon
 9/22/09 Let’s discuss the  importance of data 
Background image of page 4
 9/22/09 What are some examples of valuable or important  data? What do you think is a company’s most  important   asset?  Why? How important is data?
Background image of page 5

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

View Full DocumentRight Arrow Icon
 9/22/09 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 and Managing Data
Background image of page 6
 9/22/09 When should I use a  database?
Background image of page 7

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

View Full DocumentRight Arrow Icon
 9/22/09 Two ways of storing/analyzing  Database Spreadsheet 1. Good for large  Good for lists
Background image of page 8
 9/22/09 Relational Database vs.  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: 1. Total Orders by Product. 2. Total Sales of each Product in the Asia-Pacific  Region. Can we do the same using a spreadsheet such  as EXCEL?
Background image of page 9

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

View Full DocumentRight Arrow Icon
 9/22/09 Databases Are…  Collections of information Created with logical structures With logical ties within the information With built-in integrity constraints 
Background image of page 10
 9/22/09 Collections of information That have no guaranteed structure that can be  depended upon by anyone working with any 
Background image of page 11

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

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

Page1 / 34

module.2.session.1.slides - BUSMIS 1060 Module 2 Data...

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

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