The Process of creating an information system is known as a _________ development
Systems Development
(SDLC)
Systems Development Life Cycle
The traditional Systems Development Life Cycle (SDLC) is divided into ________ phases.
5 phases
What are the phases for the Systems Development Life Cycle
Planning, Analysis, Detailed systems design, Implementation, Maintenance
What is the primary objective of database design?
To create complete, normalized, and nonredundant database models
Should the existing system be replaced?" is a question that is asked during the ________ stage of the Systems Development Life Cycle (SDLC).
Planning Phase
What phase are the initial assessment and feasibility part of in the SDLC?
Planning Phase
The ________ phase of the SDLC should result in a better understanding of functional areas, actual and potential problems, and opportunities of the current system.
The Analysis Phase
The ________ must specify the appropriate conceptual data model, inputs, processes, and expected output requirements.
Detailed systems design
Coding, testing, and debugging of a system are part of the ________ phase of the Systems Development Life Cycle (SDLC).
Implementation Phase
The ________ phase of database development includes creating a database storage structure, loading data into a database, and providing for data management.
The Implementation and Loading Phase
The phases of the Database Life Cycle (DBLC)
Database initial study, database design, implementation and loading, testing and evaluation, operation, maintenance and evolution
________ is generally composed of a graphical representation as well as textual descriptions of the main data elements, relationships, and constraints.
conceptual design
What are the requirements of the current system's end users?" is a question asked during the ________ phase of the Systems Development Life Cycle (SDLC).
analysis
The logical systems design is created during the ________ phase of the Systems Development Life Cycle (SDLC).
planning
The design of a system's processes is completed during the ________ phase of the Systems Development Life Cycle (SDLC).
Logical
The implementation of ________-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.
CASE
The last phase in the Database Life Cycle is ________.
Maintenance and evolution
The ________ phase of the DBLC leads to the process of system evolution.
Operation
The second phase of the DBLC focuses on ________.
Design of the database model
In the process of ________, one must concentrate on the data characteristics required to build the database model.
database initial study
Which of the following is the first step of the implementation and loading phase of the DBLC?
Installing the DBMS
The ________ phase occurs in conjunction with application programming.
testing and evaluation
Producing the required information flow is part of the ________ phase of the DBLC.
operation
The database initial study phase of the DBLC involves ________.
analyze company situation, defining problems, constraints, objective, scope, and boundaries
Which of the following conceptual design steps determines end-user views, outputs, and transaction-processing requirements?
Database analysis and requirements
Which of the following conceptual design steps defines entities, attributes, and relationships among the entities?
Entity relationship modeling and normalization
Which of the following conceptual design steps identifies the main processes and the insert, update, and delete rules?
Data model verification
________ defines the optimum allocation strategy for database fragments to ensure database integrity, security, and performance.
Distributed database design
The first step in developing the conceptual model using ER diagrams is to ________.
identify, analyze, and refine the business rules
During the Entity Relationship modeling process, the designer must ________.
make decisions about adding derived attributes to satisfy processing requirements
________ coupling describes the extent to which modules are independent of one another.
Module
The first step in the ER model verification process is to ________.
identify the ER model's central entity
The term ________ describes the strength of relationships found among the module's entities
cohesivity
________ design requires that all objects in the conceptual model be mapped to the specific constructs used by the selected database model.
Logical
________ design is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.
Physical
Once the data have been loaded into the database, the ________ tests and fine-tunes the database to ensure that it performs as expected.
database administrator
________ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources
Virtualization
________ allows physical access to specific areas by authorized personnel only.
Physical security
________ allows the assignment of access rights to specific authorized users
Physical security
The assignment of ________ may restrict operations on predetermined objects such as databases, tables, views, queries, and reports.
access rights
________ are usually provided by the DBMS to check for access violations.
Audit trails
________ can be used to render data useless to unauthorized users who might have violated some of the database security layers.
Data encryption
At which of the following stages of DBLC, integration issues and deployment plans are refined, user training is conducted, and system documentation is finalized?
Evaluating the database and its application programs
Once the database has passed the evaluation stage, it is considered to be ________
Operational
Adaptive maintenance includes ________.
enhancing performance
Which of the following activities in the SDLC is parallel to implementation and loading in the DBLC?
coding
Which of the following is a classical approach to database design?
Top-down design
________ design first identifies the data elements (items), then groups them together in data sets.
Bottom-up
ER models constitute a(n) ________ process.
. top-down
________ design is productive when the data component is composed of a relatively small number of objects and procedures.
Centralized
________ design is likely to be employed when the problem itself is spread across several operational sites and each element is a subset of the entire data set.
Decentralized
An entity ________ might be viewed as a separate entity by one or more departments
subtype