Transcript 4 - BISD
By: HER AND ME What is 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 an ideal databases can be huge, containing information on millions of items. A computerized database is tool for making use of huge amounts of existing data. ◦ 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. 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! DATABASE an organized collection of information that may or may not be stored in a computer conjunto organizado de información que puede estar guardado o no en una computadora 1.Which of the following is not a part of a database? A.tables B.records C.fields D.Worksheets 3.Which of the following is not an advantage of a computerized database? A.the ability to enter information quickly B.the ability to find information quickly C.the ability to create worksheets D.the ability to organize information in different ways 2.In a database, a _____ is a unit of information about one individual or item. A.table B.field C.record D.file 4.What does the term GIGO stand for? A.get in, get out B.good information, good output C.garbage in, garbage out D.garbage input, garbage output 1-2 3-4 5.Which type of database allows you to work with data in only one table? A.relational database B.key-field database C.flat-file database D.organizational database 6.This kind of database can be used to store all kinds of items, such as documents or video clips. A.flat-file database B.object-oriented database C.multimedia database D.none of the above 7._____ the same data in multiple tables requires the computer to store more information and increases the chance of errors. A.Repeating B.Avoiding C.Formatting D.Linking 8.This means finding data by looking at all the records in a database. A.surfing B.mining C.peeking 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 B.descending C.incremental D.exponential 10.This is a user-created direction that tells the database to find specific records. A.sort order B.report template C.query D.field 11.A database is an organized collection of information. A.True B.False 12.Databases typically store all their data in one large table. A.True B.False 13.A field’s data type determines what kind of information can be stored there. A.True B.False 14.A computerized database can store millions of telephone numbers. A.True B.False 15.One disadvantage of computerized databases is that they limit your ability to arrange information. A.True B.False 16.The same features that make databases efficient tools also enable them to keep data secure. A.True 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 B.False 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 B. False 19.If you sort a database’s information chronologically, then you are sorting letters and symbols. A.True B.False 20.A query lets you speed up the browsing process by finding information that matches specific criteria. A.True B.False :) :) Tables A database has one or more tables, just as a file cabinet may have one or more drawers. Each table contains a collection of related data. Although databases can store data in one large table, it is more typical to divide databases into smaller tables. For example, your school’s database might contain separate tables for students and for teachers and staff. Records The data in each table is further split into smaller units that contain related information about one individual or item. Each of these units is called a record. For your school’s database, each unit of information, or record, is about an individual student or teacher. Fields Each separate piece of data that is stored in a record—a student’s last name, first name, and so on—is called a field. Each field is set up so that only a certain type of information, called the data type, is permitted in that field. For example, a field for date of birth allows only dates to be entered. What makes up a database? How is it organized? Picture a file cabinet. One drawer might hold information on a company’s customers, and another might have data on the company’s products. Within each drawer are folders. Each folder is dedicated to a particular person or product. Finally, each folder stores different bits of information about that person or product A computerized database is also structured in three parts: tables records fields While smaller databases might just as easily be kept on paper as on a computer, computerized databases make it easier to do the following: Enter Information You can enter information neatly, quickly, and in an organized way with your keyboard and mouse. Store Large Amounts of Information If you want to keep track of 20 or 30 phone numbers, you can easily use an address book. A computerized database, however, can hold thousands, or even millions, of telephone numbers. Tutorials Find Information Quickly A computerized database can save you time in finding information. It might take you only a minute or two to find a number in your personal address book, but a telephone directory on CD-ROM can help you find one of millions of phone numbers in even less time. Organize Information in Different Ways Paper filing systems can limit your ability to arrange information. For example, should you organize your personal phone book by listing each person’s phone number, cell phone number, or e-mail address first? With a computerized database, you can easily switch between these different methods. Update Information Database software makes it easy to change or update data. Think about adding a new name to your address book. It would be difficult to re-alphabetize the list if it existed only on paper. Think about how messy the book might look after just a few changes. With a computerized database, names and numbers can be added, deleted, or changed easily and quickly. After making these changes, you have an easy-to-read, updated version of the database. Tutorials Databases can be useful tools at home and at work. They also have many different uses at school. Administrators can use them to track student performance, payroll, and supplies. Teachers can use them to record students’ test scores and attendance. Students can use them to organize their grades or search for information for a project. However, databases are useful only if they are accurate. In other words, databases are only as good as the data they contain. The acronym GIGO explains this principle. GIGO is short for “garbage in, garbage out.” It means that if the information placed in a database is wrong, anyone using that information will get the wrong results. When adding information to a database, it is very important to do so accurately and to check your entries. Mr.Puente :thank you very much for all the support and thank you Mrs.Guerrero for helping up out in everything we need !!! :)