BCIS FINAL Exam Study Guide With Verified Solutions.

BCIS FINAL Exam Study Guide With Verified Solutions. Batch processing - answerIn _______, data from transactions are collected over time and then processed all at once. Physical view - answerWhich view of data deals with how the data is actually formatted and located? Primary key - answerA field that uniquely identifies each record. Attribute - answerA data field that represents a description or characteristic of some entity. Attribute - answerIn the object-oriented database model, this term is the equivalent to a field in a relational model. TRUE - answerTypically, one of the duties of a database administrator is to interact with the data administration subsystem. FALSE - answerData consists of only numbers, letters, and symbols. TRUE - answerIn order to create, modify, and gain access to a database, special software, called the database management system, is required. Company - answerThe combined information presented on this type of database can be used to change the whole merchandising strategy of a store. Relational - answerThis type of database is organized into many tables with common data items (key fields) linking the tables to one another. Hierarchical - answerIn this database model, the fields or records are structured in nodes. Individual - answerIn this type of database, the data and the DBMS are stored either on the user's hard-disk drive or on a LAN file server. LexisNexis - answerThis commercial database offers news and information on legal, public records, and business issues. Record - answerA collection of related fields such as a person's name, address, and age. Data warehouse - answerInformation collected by an organization from a variety of external and internal databases is stored in this special type of database. FALSE - answerApplication software for new information systems always requires having it custom-designed to meet the needs of the organization. Prototyping - answerThis is the process of building a model that can be modified before the actual system is installed. Systems implementation - answerDuring which phase of the systems life cycle are users trained to use the new system? TRUE - answerIn the data analysis step, the idea is to learn how information currently flows and to pinpoint why it is not flowing properly. TRUE - answerIn the systems design phase of the systems life cycle, the systems design report usually concludes by recommending one of the analyzed alternatives. TRUE - answerA survey of user needs is part of the preliminary investigation phase. TRUE - answerGathering data and information in the systems analysis phase can be achieved through conducting interviews and studying documents. TRUE - answerPeriodic evaluation is part of the systems maintenance phase of the systems life cycle. FALSE - answerData about how the present system works is collected during the preliminary investigation phase in order to determine the requirements of the new system Train users - answerThis is the final step of the systems implementation phase of the systems life cycle. Modules - answerThese consist of logically related programming statements. TRUE - answerThe report at the end of the program design step typically consists of pseudocode, flowcharts, and logic structures. converts and runs the procedural language one statement at a time into machine code - answerAn interpreter _______. TRUE - answerCoding is only one of the six steps of programming. structured - answerOne of the best ways to code effective programs is to write so-called _______ programs, using the sequential, selection or repetition logic structures. program - answerA _______ is a list of instructions for the computer to follow to accomplish the task of processing data into information. FALSE - answerA condition must be met before a sequential structure can proceed to the next statement.