Transcript Chapter 8- Databases Basics

BY: Ivan Lopez and Diego
Hinojosa
 Chapter
8 Overview
Lesson 8–1 The Essentials of a Database
Lesson 8–2 Types of Database Programs
Lesson 8–3 Database Techniques
Chapter Review and Assessment


What Is a Database?
What do the following things have in
common: an address book, a
telephone directory, a list of family
birthdays, and a catalog of DVDs?
For one thing, each can be stored in
a database, or an organized
collection of information. Databases
can exist on paper or on a
computer. Computerized databases
can be huge, containing information
on millions of items. A computerized
database is an ideal tool for making
use of huge amounts of existing
data.

Databases make it easy to
store, add, organize, and
retrieve information.
Suppose a worker has to
find the account number
for a customer. Imagine
how much time that worker
saves if he or she can find
the information simply by
typing the customer’s
name instead of searching
through piles of paper!
 Database
 an
organized
collection of
information that
may or may not
be stored in a
computer
base de datos
• conjunto
organizado de
información que
puede estar
guardado o no en
una computadora
 table
 the
underlying structure of a relational
database characterized by rows and
columns
 tabla
 estructura subyacente de una base de
datos relacional caracterizada por filas y
columna
 record
a
part of a database that holds data about
a particular individual or item
 registro
 parte de una base de datos que contiene
datos acerca de un individuo o elemento
específico
 field
 part
of a database that holds an
individual piece of data
 campo
 parte
de una base de datos que contiene
un dato individual
 data
type
 settings applied to a database field,
which allow the field to store only
information of a specific type and/or
format
 tipo de datos
 parámetros que se aplican a un campo
de base de datos, que permiten al campo
almacenar información de un solo tipo
y/o formato específico
 garbage
in, garbage out (GIGO)
 a phrase that stresses the importance of
inputting accurate data in a database
 entra basura, sale basura
 frase que destaca la importancia de
introducir datos precisos en una base de
datos
1.Which of the following is not a part of a database?
D. worksheets
2.In a database, a _____ is a unit of information about one individual
or item.
C. Record
3.Which of the following is not an advantage of a computerized
database?
C. The ability to create worksheets
4.What does the term GIGO stand for?
C. Garbage in, garbage out
5.Which type of database allows you to work with data in only one
table?
C. flat-file database
6.This kind of database can be used to store all kinds of item such
as documents or video clips.
C. Multimedia database
7._____ the same data in multiple tables requires the computer to
store more information and increases the chance of errors.
B. Avoiding
8. This means finding data by looking at all the records in a
database.
D. browsing
9.If you sort data in order of increasing value, such as A–Z or 1–9,
what sort order are you using?
A.
Ascending
10.This is a user-created direction that tells the database to find
specific records.
C. query
11.A database is an organized collection of
information.
A.
True
12.Databases typically store all their data in one large table.
B. False
13.A field’s data type determines what kind of information can be
stored there.
A.
True
14.A computerized database can store millions of telephone
numbers.
A.
True
15.One disadvantage of computerized databases is that they limit
your ability to arrange information.
B. False
16.The same features that make databases efficient tools also
enable them to keep data secure.
B. False
17.Instead of storing the same data in multiple tables, it is more
efficient to store the data in one table and link it to other tables.
A.
True
18.The people who create databases can avoid causing
information overload by summarizing information so that it
does not overwhelm the databases’ users.
A.
True
19.If you sort a database’s information chronologically, then you
are sorting letters and symbols.
B. False
20.A query lets you speed up the browsing process by finding
information that matches specific criteria.
A. True
 The
end
 The
 The
end
 THE
I
end
am telling u it’s the end!!!
 FIN
END