Scribd
Upload
2 views14 pages

Lec 10 Databases

The document provides an overview of databases, data, and information, defining key terms such as database, data integrity, and valuable information characteristics. It explains the hierarchy of data, including characters, fields, records, and files, as well as the role of database management systems (DBMS) in managing data. Additionally, it discusses the importance of maintaining data through adding, modifying, and deleting records.

Uploaded by

dffsdgjghjtr3434566
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views14 pages

Lec 10 Databases

The document provides an overview of databases, data, and information, defining key terms such as database, data integrity, and valuable information characteristics. It explains the hierarchy of data, including characters, fields, records, and files, as well as the role of database management systems (DBMS) in managing data. Additionally, it discusses the importance of maintaining data through adding, modifying, and deleting records.

Uploaded by

dffsdgjghjtr3434566
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Discovering

Computers 2012
Your Interactive Guide
to the Digital World
Objectives Overview

Define the term,


Define the term, data
database, and explain
integrity, and describe
how a database
the qualities of valuable
interacts with data and
information
information

Discuss the terms


character, field, record,
and file

See Page 513 2


for Detailed Objectives Discovering Computers 2012: Chapter 10
Databases, Data, and Information

Database Data Information

• Collection of • Collection of • Processed data


data organized unprocessed • Documents
in a manner items • Audio
that allows • Text • Images
access, • Numbers
retrieval, and • Video
• Images
use of that
data • Audio
• Video

Page 514 3
Discovering Computers 2012: Chapter 10
Databases, Data, and Information

Pages 514 – 515 4


Discovering Computers 2012: Chapter 10
Figure 10-1
Databases, Data, and Information

• Database software, often called a database


management system (DBMS), allows users to:

Create a computerized Add, modify, and


database delete data

Create forms and


Sort and retrieve data
reports from the data

Page 515 5
Discovering Computers 2012: Chapter 10
Databases, Data, and Information

• Data integrity identifies the quality of the data


• Garbage in, garbage out (GIGO) points out the
accuracy of a computer’s output depends on the
accuracy of the input

Page 516 6
Discovering Computers 2012: Chapter 10
Databases, Data, and Information

• Valuable information should have the following


characteristics:

Accurate Verifiable Timely Organized

Cost-
Accessible Useful
effective

Pages 516 - 517 7


Discovering Computers 2012: Chapter 10
The Hierarchy of Data

• A character is one byte


– Numbers, letters, space,
punctuation marks, or
other symbols
• A field is a combination
of one or more related
characters
– Field name
– Field size
– Data type

Page 518 8
Discovering Computers 2012: Chapter 10
Figure 10-3
The Hierarchy of Data

• Common data types include:

Text Numeric AutoNumber Currency

Date Memo Yes/No Hyperlink

Object Attachment

Page 518 9
Discovering Computers 2012: Chapter 10
The Hierarchy of Data

• A record is a group of related fields


– A primary key uniquely identifies each record
• A data file is a collection of related records

Page 519 10
Discovering Computers 2012: Chapter 10
Figure 10-4
Maintaining Data

• File maintenance refers to the procedures that


keep data current

Adding Modifying
records records

Deleting
records
Page 520 11
Discovering Computers 2012: Chapter 10
Maintaining Data

• Users add new records to a file when they obtain


new data

Page 520 12
Discovering Computers 2012: Chapter 10
Figure 10-5
Maintaining Data

• Users modify a record to correct inaccurate data


or update old data

Page 521 13
Discovering Computers 2012: Chapter 10
Figure 10-6
Maintaining Data

• When a record no longer is needed, a user deletes


it from a file

Page 522 14
Discovering Computers 2012: Chapter 10
Figure 10-7

You might also like