F09_class_09_DB_Ch5 - Introduction to Databases Chapter 5...

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

View Full Document Right Arrow Icon
Introduction to Databases Chapter 5 Gray & Patton MIS 301 Introduction to IT Management
Background image of page 1

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

View Full DocumentRight Arrow Icon
Class Business Class on Fri, 9/18, in MOD Lab, CBA 5.304 Know your McCombs login and ID Download Access tutorial from Blackboard Put it in your UT Webspace MSGP #2 due Fri, 9/18, hard copy in class Access1 due Mon, 9/21, on Blackboard Late assignments – read POLICY In syllabus Homework due at specific times in proper format Deliverables handed in after the due time/day but during the next 24 hours will receive half credit. Deliverables not accepted more than 24 hours late Any grade questions must be sent within 1 WEEK of the day grades are posted on Blackboard
Background image of page 2
Why Use a Database? 1. Preserve data integrity - assurance that data is consistent, correct, and accessible 2. Eliminate data redundancy unnecessary repetition of data that slows data processing 3. Limit data view (query, report) so that users only see what they need to see, as cleanly and clearly as possible
Background image of page 3

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

View Full DocumentRight Arrow Icon
Eliminate Data Redundancy Using Excel when you need a DB is like using a tennis racket to hit a golf ball – not the right tool.
Background image of page 4
Purpose of a Database Keep track of things with more than 1 theme Example: Student grades – single theme
Background image of page 5

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

View Full DocumentRight Arrow Icon
Student Data in Database When professor tries to track 3 themes, the spreadsheet doesn’t work
Background image of page 6
What is a Database? Self-describing collection of integrated records
Background image of page 7

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

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

This note was uploaded on 12/17/2010 for the course MIS 301 taught by Professor Mccleod during the Spring '08 term at University of Texas at Austin.

Page1 / 27

F09_class_09_DB_Ch5 - Introduction to Databases Chapter 5...

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

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