Transcript Chapter 8
JORGE DIAZ PORRAS,FRANCISCO GARZA,NESTOR DOMINGUEZ.
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
the underlying structure of a relational database characterized by rows and columns.
a part of a database that holds data about a particular individual or item.
part of a database that holds an individual piece of data.
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.
a database that stores objects, such as sound, video, text, and graphics.
an element that links tables in a relational database.
a database in which shared key fields link data among tables.
to arrange data in a specific order.
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.
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.
Summarize : As you read the lesson, use a chart to help you summarize techniques for using databases effectively.
the result of a computer user being overwhelmed by the amount of information generated by his or her computer
to find information in a database by looking at records one at a time
the sorting of data by increasing value
the sorting of data by decreasing value
an ordered list of selected database records and fields in an easy-to-read format
a pattern that controls how data will be displayed in a database report
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.
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
3. Which of the following is not an advantage of a computerized database? :the ability to create worksheets
4.What does the term GIGO stand for? : garbage in, garbage out
5.Which type of database allows you to work with data in only one table?
This kind of database can be used to store all kinds of items, such as documents or video clips. :object oriented database
7.The same in multiple tables requires the computer to store more information and increases the chance of errors. :data
8.This means finding data by looking at all the records in a database. :browsing
9. If you sort data in order of increasing value, such as A–Z or 1–9, what sort order are you using? :ascending
10. This is a user-created direction that tells the database to find specific records. :query