Lab6_DB_F09

Lab6_DB_F09 - Lab 6 Introduction to Databases •...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Lab 6: Introduction to Databases • Definitions • Databases and traditional file Databases and traditional file processing systems • RDBMS: Microsoft Access • Objects: – Tables 1 – Queries – Forms – Reports IE332 Fall 09 Definitions • Data – Facts, text, graphics, images, sound, and video segments that have meaning in the video segments that have meaning in the users’ environment • Information – Data that have been processed in such a way as to increase the knowledge of the person who uses the data 2 who uses the data • Metadata – Data that describe the properties or characteristics of other data IE332 Fall 09 Example of Data Class Roster Course: IE332 Computing in Industrial Engineering Semester: Fall 2009 Section: 2 Name ID Major GPA Bajerm Jebbetg D, 0024917171 IE 4 3 Doyle, Joan E. 0056789321 ME 3.3 McFerran, Debra R. 0094165823 EE 2.8 . . . . . . . . . . . . IE332 Fall 09 Example of Metadata Data Item Value Name Type Length Min Max Description Course Alphanumeric 30 Course ID and name Section Integer 1 1 9 Section number Semester Alphanumeric 10 Semester and year Name Alphanumeric 30 Student name ID Integer 10 Student ID 4 Major Alphanumeric 4 Student major GPA Decimal 3 4 Student grade point average . . . . . . . . . . . . . . . . . . IE332 Fall 09 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 use the data to answer questions concerning that domain • What does a database do?...
View Full Document

This note was uploaded on 01/19/2012 for the course IE 230 taught by Professor Xangi during the Spring '08 term at Purdue.

Page1 / 10

Lab6_DB_F09 - Lab 6 Introduction to Databases •...

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