Unit 5 DATABASES(ANSWERED)

Unit 5 DATABASES Database Ans: a software program for storing, managing, and retrieving information Query Ans: to ask a question about data Table Ans: rows and columns that are used for organizing data A spreadsheet is a software program for storing, managing, and retrieving information. Ans: False Select all actions that a database may perform. 1) Update information in more than one place at the same time. 2) Write a business letter. 3) Create data entry forms. 4) Find the average of four numbers. 5) Validate the data entered and check for inconsistencies. 6) Sort and manipulate the data in the database. 7) Conduct a query. Ans: 1 3 5 6 7 Sarah wants to calculate how much of a profit she would make on producing and selling a new product. Sarah should use a _____. 1. database 2. word processor 3. spreadsheet 4. data entry form Ans: 3 Carolyn would like to store and retrieve data about products in her catalogue. She should use a _____. 1. database 2. word processor 3. spreadsheet 4. invoice Ans: 1 Field Ans: one of the categories in a database record, such as last name. They correspond to columns in a table. File Ans: a group of records Key Field Ans: the primary field used to uniquely identify records. It may be used to sort records in alphabetical order. Record Ans: one set of data or complete entry in a database. They correspond to rows in a table Before you start creating a database, you should first use paper to plan, test, and revise. Ans: True Nicole wants to create a database to collect information about sales transactions. She would like to use the database to look up customer names and sales prices if they return a product. She would also like to retrieve their credit card number in order to reimburse them. In addition, she would like to sort the items in the database by product number. What fields should she have in her database? 1. product number, product description, and sales price 2. product description, sales price, and employee name 3. last name, first name, telephone number, and address 4. name, credit card number, product number, and sales price Ans: 4 Sort means to arrange in a certain order. Ans: true If you were looking for a record in a very large database and you knew the ID number, which of the following would be the most direct way to locate the record? 1. sort 2. find 3. locate 4. filter Ans: 2 You would like to arrange the records alphabetically. You would _____. 1. delete a record 2. locate a record 3. sort 4. update Ans: 3 If you wanted the item that cost the least at the top of the table, you would sort in descending order. Ans: False Ben keeps a database for employee contact information. One of his employee's address changed. Ben needs to _____. 1. update the record by editing the address field 2. delete the record and insert a new record 3. delete the address field 4. clear the address field Ans: 1 A wizard only allows data that matches certain conditions to pass through. Ans: False A query is a way to find answers to questions about the data. Ans: True Use comparison operators to write a question that the database will understand. Which records are more than or the same as twenty? 1. 20 2. 20 3. =20 4. =20 Ans: 3 Use comparison operators to write a question that the database will understand. Which records contain "no"? 1. =no 2. no 3. =yes 4. is no Ans: 1 If you have a database with birthdates, and you would like to find everyone who was born before June 16, 1967, what would you enter? 1. June 16, 1967 2. is June 16, 1967 3. June 16, 1967 4. June 16, 1967 Ans: 3 Export Ans: to move a file out of one application to another application Import Ans: move a file into one application from another application Mapping Ans: identifying relationships between data Text File Ans: a file that is created with a text editor and contains only printable letters, numbers, and symbols; no formatting Importing data is sending data to a new file. Ans: False Kevin needs to get his data from a database into a text file to send to another group. He needs to _____. 1. import 2. sort 3. export 4. link Ans: 3 Sharon wants to import data from an old database into a new database. She notices some of the field names are different. Sharon will need to _____. 1. link 2. export 3. merge 4. map Ans: 4 You need to provide data to your client in a format that they can read. You will need to _____ the data. 1. map 2. import 3. filter 4. export Ans: 4