Chapter 8

download report

Transcript Chapter 8

JORGE DIAZ PORRAS,FRANCISCO GARZA,NESTOR DOMINGUEZ.

CHAPTER 8

Chapter Outline

      Lesson 8-1 The Essentials of a database Lesson 8-2 Types of Database Programs Lesson 8-3 Database techniques

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.

What is a database?

 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 idea tool for making use of huge amounts of existing data.

What is database

 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!

Chapter 8-1 Vocabulary

 

table

the underlying structure of a relational database characterized by rows and columns.

record

 a part of a database that holds data about a particular individual or item.

Vocabulary

     

field

part of a database that holds an individual piece of data.

data type

settings applied to a database field, which allow the field to store only information of a specific type and/or format.

garbage in, garbage out (GIGO)

a phrase that stresses the importance of inputting accurate data in a database.

8-2 vocabulary

     

object-oriented database

a database that stores objects, such as sound, video, text, and graphics.

key field

an element that links tables in a relational database.

relational database

a database in which shared key fields link data among tables.

8-2 vocabulary

     

sort

to arrange data in a specific order.

flat-file database

a database that can work with only one table at a time.

database management system (DBMS)

a software program used to manage the storage, organization, processing, and retrieval of data in a database.

Chapter 8-3

   Give examples of how to manage information in databases.  Compare and contrast browsing, sorting, and querying data in a database. Describe the features of a report template.

Chapter 8-3

 Summarize : As you read the lesson, use a chart to help you summarize techniques for using databases effectively.

Chapter 8-3

   

information overload

the result of a computer user being overwhelmed by the amount of information generated by his or her computer  

browse

to find information in a database by looking at records one at a time

ascending order

the sorting of data by increasing value

Chapter 8-3

     

descending order

the sorting of data by decreasing value

report

an ordered list of selected database records and fields in an easy-to-read format

report template

a pattern that controls how data will be displayed in a database report

CHAPTER 8

How is a computerized database organized? 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.

Chapter 8

1.Which of the following is not a part of a database? :worksheets

Chapter 8 answers and questions

 2.In a database, a is a unit of information about one individual or item. :record

Chapter 8

 3. Which of the following is not an advantage of a computerized database? :the ability to create worksheets

Chapter 8

  4.What does the term GIGO stand for? : garbage in, garbage out

Chapter 8

5.Which type of database allows you to work with data in only one table?

Chapter 8

 6.

This kind of database can be used to store all kinds of items, such as documents or video clips. :object oriented database

Chapter 8

 7.The same in multiple tables requires the computer to store more information and increases the chance of errors. :data

Chapter 8

 8.This means finding data by looking at all the records in a database. :browsing

Chapter 8

 9. If you sort data in order of increasing value, such as A–Z or 1–9, what sort order are you using? :ascending

Chapter 8

 10. This is a user-created direction that tells the database to find specific records. :query