ITGS Review Questions: Database

page 259

2)What is the difference between a file amamger and a database management system?
A database management system allows to more easily navigate through data. It is more effient, quick, and eay to use becasue it uses spreadshets and tables that are linked together to locate and organize files, unlike a file system.

3)Describe the structure of a simple database.
Each database is made up of tables, each record is basically a record. Each record is made up of fields containing information.

4)What is a query? GIve examples of kinds of questions that might be answered with a query.
A query is a request for any kind of information, usually asked on an internet search engine. There are many search engiens such as google, yahoo, bing,etc. A query can be virtually anything one wants to know. For example, looking up the information and reviews on a movie, or finding recipes or information on a program you are interested in.

5)What steps are involved in producing a standard multicolumn business report with a database?
One can design and program a spreadsheet to simply calculate and keep track of monthy sales and so on, all they have to do after designing the spreadhseet in the way they think is best fit, and programming certain cells to calculate, all they need to do is input information when they want to updatet eh report and allt eh numbers and calculations will automatically be doen on the spreadsheet without any extra effort.

6)What are the advantages of personal information management software over paper notebook organizers? What are the disadvantages?
Having personal information management software makes it easier to track through information because it is well organized and easy to search. Finding and entering information is a mroe effiecnet process, and you can easily share it with whoever you please. You can also keep it on a PDA, or phone and easily open and access it wherever you are.