Exam 13: Data Management Concepts

Listed below are ten examples of file organization. Required: From the following three choices,match the file organization technique with each of the ten examples listed.All techniques will be used more than once. S = Sequential IS = Indexed-sequential D = Direct access ________ 1.A large manufacturing company pays all employees once a week. ________ 2.The inventory system of a 24-hour grocery store automatically orders merchandise from vendors when the inventory level is low. ________ 3.A bank customer checking account file is online in an ATM network.The bank also uses the file each month to produce customer statements. ________ 4.An Internet retailer sells children's toys online. ________ 5.An airline reservation system answers customer inquiries about available flights and seats and makes customer reservations. ________ 6.Bookstore employees use an inventory file each week to prepare purchase orders for books. ________ 7.A plant assets file for a small manufacturer is used to prepare quarterly depreciation reports.It is used once a year to prepare a report for insurance purposes. ________ 8.Employees use a vendor application at a trucking company daily to answer questions and accrue accounts payable.The company writes checks to vendors once a week. ________ 9.A file of payables due to actors and writers is processed monthly to prepare royalty checks; it is also used once a year to prepare tax reports. ________ 10.A metropolitan branch library scans books to check them out,answers patron inquiries about available books,and mails monthly statements to patrons having overdue books.

A database management system is independent of the application software therefore permitting upgrading or modifying the eBusiness application without changing data or database software.This is referred to as database agnosticity.

OLAP is a multidimensional generalization of the 3-dimensional relational table.

The basic economics of file processing are largely determined by the activity ratio,which is the

A database is a structured collection of data stored in a computer system or network.

The "A" in ACID stands for ________.

A high activity ratio

A row in a relational database table is called a(n)________.

Related groups of fields that repeat themselves in variable-length records are called repeated groups.

Records are contiguous when they are physically next to each other on a disk.

Individual logical expressions may be combined in a FROM clause with the Boolean operator AND in SQL.

In the record format STORE (STORE_NO,CITY,VEND#1,VEND#2) Which field is repeated?

A database dictionary is defined and controlled by

Presented below is a list of terms relating to accounting information systems,followed by definitions of those terms. Required: Match the letter next to each definition with the appropriate term.Each answer will be used only once. ________ 1.DBA ________ 2.Inheritance ________ 3.Occurrence ________ 4.Branch ________ 5.Database model ________ 6.Record ________ 7.Fully inverted file ________ 8.Trailer record ________ 9.Record key ________ 10.Field A.The connection between children and parent(s)in a tree structure B.Individual who has overall responsibility for database administration C.The smallest block of data that will be stored and retrieved in the information system D.A synonym for schema E.A relationship created when an object class is divided into subclasses F.A file in which all fields are indexed G.A specific set of data values for a record H.A logical grouping of fields (data items)that concern a certain entity I.A data item or combination of data items that uniquely identify a particular record in a file J.A fixed-length extension of a master record

Fields associated with other fields in a logical grouping are known as

Database ________ permits upgrading or modifying the eBusiness application without changing data or database software.

In an entity-relationship data model,the concepts of part number,type,and cost are known as

The processing time required to maintain a fully inverted file

The purpose of the index in an ISAM file is to