w5_2_Lab 3 Databse_Sp12

w5_2_Lab 3 Databse_Sp12 - Databases1 Agenda 1. 2. 2.8.12...

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

View Full Document Right Arrow Icon
Databases1 Agenda 1. Review 2. Databases 3. Lab#3 this Th is on Database IE 332 2.8.12
Background image of page 1

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

View Full DocumentRight Arrow Icon
What is a Database? Database An organized collection of logically related data Organized : data are structured so as to be easily stored, manipulated, and retrieved by users Related : data describe a domain of interest to a group of users and the users can access the data to answer questions/make decisions concerning that domain What do databases do? Databases help organize related data in a logical fashion for easy access and retrieval 2
Background image of page 2
Why Database? 1. 2. 3. 4. 5. 6. Why computer-based database? 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Traditional File Processing Systems Databases did not exist in the beginning of computer-based data processing (~1960-70s) Computer file processing systems were developed to store, manipulate, and retrieve large volumes of data in files Focus was on the data processing needs of individual departments Responded to users requests by developing new computer programs, with their own files Each application program or system was designed to meet the needs of the particular requesting department or user group 4
Background image of page 4
Example of Traditional File Processing Systems Sales Department Customer File Inventory File Order File Accounting Department Order Pricing File Customer File Payroll Department Employee File 5 Do you notice any problem?
Background image of page 5

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

View Full DocumentRight Arrow Icon
DBMS A Database Management System (DBMS) stores and retrieves information in a database Storing data in a precise, known format enables a database management system to turn the data into useful information through open-ended, flexible output DBMS also handles data maintenance, physical
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 29

w5_2_Lab 3 Databse_Sp12 - Databases1 Agenda 1. 2. 2.8.12...

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

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