Database Planning

When selecting a DBMS, which of the following would be considered a transactions criterion?

Backup and recovery capabilities

Why is the support of embedded SQL statements critical when determining the programming environment in which to create an application interface to the database?

Because most of the data manipulation operations will be performed from the user interface, not from the DBMS

Why can the failure to ascertain all the requirements of a database system in a database requirements document lead to an inadequate or incomplete system?

Because the database requirements document is used as a blueprint from which the database design is derived

As you attempt to collect information that will be used to prepare the database requirements document, why should you interview management personnel separately from users?

Because these two groups have different perspectives of the organization

Which of the following is a fundamental activity in creating a database requirements document?

Conducting interviews with the principal people involved with the database

Which of the following should you perform if an old database system is being replaced by a new one?

Convert legacy data and load it into the new system.

During the database development process, in which step would you determine the type of data that the database will be handling, and document the existing strengths of the current system?

Creating the database strategy

Which of the following are used to create the tables and views of a database?

DDL statements

Which of the following represent the transaction functionality built into database application programs?

DML statements

Which of the following statements is consistent with the development of an efficient and easy-to-use GUI to a database?

Data entry fields should be constructed so that users can logically move from field to field using the TAB key, arrow or mouse pointer.

Regarding the creation of a database system, which of the following would include data requirements, data processing requirements, design constraints, and a set of user-defined objectives?

Database requirements document

What is the term for a formal definition of the specifications for a database that include the required features of the database?

Database requirements document

What does a database requirements document typically contain?

Database specifications

In which database design life cycle step would you designate the data and the data relationships required by the users, and present a data model that delineates the transactions required on the data?

Designing the database

When selecting a DBMS, which of the following would be considered a data definition functionality criterion?

Enforcement of primary keys

At which stage of the database design life cycle should menus, data entry forms, report generating programs, and user logon screens be set up?

Implementation

When selecting a DBMS, which of the following would be considered an access criterion?

Interface capabilities with other systems and programming languages

Which of the following is a main reason why many software development projects fail or are abandoned?

A lack of a suitable development methodology

In a database requirements document, what is an operational scenario?

A proposed specific use of the database system that describes one or more beginning-to-end transactions involving the database system and its environment

As you attempt to collect information that will be used to prepare the database requirements document, what should you do when conducting interviews?

Record the interviews or take extensive notes so that none of the information gathered from the interviews is lost.

The programming language used to create the functional interface to the database must support the inclusion of ___________ embedded within the program code.

SQL statements

Who should conduct a black-box test of the database and database application?

Someone who has no knowledge of the code, or any predetermined notions of how the application is supposed to perform

When selecting a DBMS, which of the following would be considered a physical criterion?

Support for encryption

Which of the following is true of database planning and design?

System requirement information should be collected before the design phase of a database project is begun.

What should you do before and after the implementation of your database system to locate and fix errors in both the database and the database's application?

Test the database and database application

Which of the following database design life cycle tasks should you perform before the implementation of the database system, and after the system goes live?

Test the database and database application

Why should you create working prototypes of both the database and the application that accesses the database before the system goes live?

To allow the database designers to refine the users' requirements and to review the system design for usability and feasibility

For which of the following would you use DDL statements?

To create the tables and views of a database

For which of the following would you use DML statements?

To represent the transaction functionality built into database application programs

Which of the following database components would have the most direct effect on a user's inclination to access and use a database?

User interface

When is it necessary to convert legacy data and load it into a new database system?

When you are replacing an old database system with a new one

When someone other than the database designer who has access to the code and is authorized to make changes to the code tests the database and the application accessing the database, then the testing is known as _______ .

White-box testing

You want to allow individuals to test the database system, to identify features that work well and features that may need more work, or to suggest needed features that may have been left out of the original design phase. To accomplish this, you should:

create a working prototype of both the database and the application that accesses the database.

One of the most important aspects of database design is the data model, which:

delineates the transactions required on the data.

Someone who conducts a glass-box test of the database and the application accessing the database:

has knowledge of and access to the code, and is authorized to make changes to the code.

When you define the scope of a database application, you are defining:

the users of the database and its corresponding application.

In a database requirements document, which of the following would define the specific purpose of the database in broad terms?

Mission statement

When selecting a DBMS, which of the following would be considered a utilities criterion?

Performance and use monitoring

Someone other than the database designer or developer tests the database and the application accessing the database by concentrating on all areas of user input, user interface and data output in an effort to "break" the application. What type of test is this?

A black-box test