Week9%20-%20databases

Week9%20-%20databases - IST 195 Week 9, Lecture 1 Databases...

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

View Full Document Right Arrow Icon
IST 195 – Week 9, Lecture 1 – Databases Professor Jeffrey Rubin
Background image of page 1

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

View Full DocumentRight Arrow Icon
Why Use A Database? Managing vast amounts of information Perform quick queries Ability to make quick decisions about information
Background image of page 2
Transformation from File System to Database Physical File System Filing cabinets, folders, files File system is storing all information in text files Text File Hard to find information as files grow in size Difficult to build reports Spreadsheet Ability to Sort Problems still existed due to possible redundancy of data.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Flat File or Sequential File Tammy Jones Manager Engineering Team 335-7534 Supervises Adams and Johnson Fred Adams Worker Engineering Team 335-8392 Brenda Johnson Worker Engineering Team 335-2890 Frederick Adams Worker Engineering Team 335-8392
Background image of page 4
Goals of a Database Data Efficiency Eliminates the replication of information. One data source for the entire organization to utilize rather than many Sales Billing Marketing Support Customer Orders
Background image of page 5

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

View Full DocumentRight Arrow Icon
Goals of a Database Data Integrity Prevent inconsistent data Adding Records Editing Records Deleting Records Example: Customer calls sales to update address Sales Billing Marketing Support Customer Order
Background image of page 6
Relational Database Model Developed by E.F Codd from IBM in 1970 Allows users to design logically rather than physically
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 11/18/2011 for the course IST 195 taught by Professor Staff during the Fall '08 term at Syracuse.

Page1 / 23

Week9%20-%20databases - IST 195 Week 9, Lecture 1 Databases...

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