Lab6_DB_F09

Lab6_DB_F09 - Lab 6: Introduction to Databases Definitions...

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

Page1 / 10

Lab6_DB_F09 - Lab 6: Introduction to Databases Definitions...

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