Exam 9: Database Design

The traditional Systems Development Life Cycle (SDLC)is divided into phases.

Data integrity is enforced by the database management system (DBMS)through the proper use of primary and foreign key rules.

The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

The term "database development" is used to describe the process of database design and implementation.

The Systems Development Life Cycle (SDLC)is a sequential process rather than an iterative process.

A designer must have a thorough understanding of the company's data types,extent,and uses in order to develop an accurate _____.

In the context of the database design process,the conceptual design step that determines end-user views,outputs,and transaction-processing requirements is .

A is an information system component that handles a specific business function,such as inventory,orders,or payroll.

Discovery of user requirements,existing system evaluation,and logical system design are part of the phase of the Systems Development Life Cycle (SDLC).

The analysis phase of the Systems Development Life Cycle (SDLC)involves a cycle of coding,testing,and debugging.

Database performance is one of the least important factors in all database implementations.

are usually provided by the database management system (DBMS)to check for access violations.

The advent of very sophisticated application generators and has substantially decreased coding and testing time.

The process of creating an information system is known as .

Programmers use database tools to the applications during coding of the programs.

A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).

The implementation of applications tends to prolong the operational life of systems by making them easier to update and maintain.

Producing the required information flow is part of the phase of the Database Life Cycle (DBLC).

In the context of the database design process,the conceptual design step that defines the fragmentation and allocation strategy is .

In a(n),only the objects that have been updated or modified since the last full backup are backed up.