1. The process of creating an information system is known as ____ development.
A) systems
B) database
C) network
D) transformation
2. The process of database design and implementation is ____ development.
B) databse
3. The primary objective of database design is ____
A) to create the most efficient database possible
B) to create complete, normalized, non-redundant, and fully integrated conceptual, logical, and physical database models.
C) to create the fastest queries
D) to be able to add data quickly
4. The traditional SDLC is divided into ____ phases.
A) two
B) three
C) four
D) five
5. The initial assessment and the feasibility study are part of the SDLC's ____ phase
A) planning
B) analysis
C) detailed systems design
D) implementation
6. User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.
7. A detailed system specification is part of the ____ phase of the SDLC.
8. Coding, testing, and debugging are part of the ____ phase of the SDLC.
D) implemetnation
9. Installation and fine tuning are part of the ____ phase of the SDLC.
10. Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC.
B) maintenance
11. The SDLC is most important to the ____.
A) programmer
B) manager
C) system designer
D) database administrator
12. “Should the existing system be replaced?” is a question that is asked during the ____ stage of the SDLC.
C) implementation
D) maintenance
13. “What are the requirements of the current system’s end users?” is a question asked during the ____phase of the SDLC.
14. The logical systems design is created during the ____ phase of the SDLC.
15. The design of the system’s processes is completed during the ____ phase of the SDLC.
16. The database is loaded during the ____ phase of the SDLC.
A) analysis
B) detailed systems design
17. There are ____ stages in the DBLC.
A) four
B) five
C) six
D) seven
18. The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.
A) database
B) network
C) CASE
D) design
19. Analyzing the company situation is part of the ____ phase of the DBLC.
A) database initial study
B) database design
C) implementation and loading, testing, and evaluation
D) operation
20. Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC.
C) implementation and loading
D) testing and evaluation
21. Installing the DBMS, creating the database, and loading or converting the data are part of the ____phase of the DBLC.
22. Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.
23. Producing the required information flow is part of the ____ phase of the DBLC.
C) operation
24. The last step in the DBLC is ____.
A) maintenance and evolution
B) operation
C) testing and evaluation
D) implementation and loading
25. The first step in the DBLC is ____
A) operation
B) database initial study
C) database design
26. The database initial study phase of the DBLC involves ____.
A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS
27. The implementation and loading phase of the DBLC involves ____.
A) defining objective
28. The conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ____.
A) data analysis and requirements
B) entity relationship modeling and normalization
C) data model verification
D) distributed database design
29. The conceptual design step that defines entities, attributes, and relationships is ____.
A) database analysis and requirements
30. The conceptual design step that identifies ER modules and validates insert, update, and delete rules is____.
B) ER modeling and normalization
C) data-model verification
31. The conceptual design step that defines the DBMS and data model to use is ____.
A) database analysis and reuiqrements
C) data-model verifiction
32. ____ allow(s) physical access to areas by authorized personnel only.
A) physical security
B) password security
C) access rights
D) data encryption
33. Once the data has been loaded into the database, the ____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.
C) database administrator
D) systems administrator
34. The maintenance and evolution phase of the DBLC involves ____.
35. The first step in developing the conceptual model using ER diagrams is to ____.
A) normalize the entities
B) complete the initial ER diagram
C) identify, analyze, and refine the business rules
D) define the attributes, primary keys, and foreign keys for each of the entities
36. The first step in the ER model verification process is to ____.
A) identify each module and its components
B) identify the ER model's central entity
C) verify all processes against the ER model
D) identify each module's internal transaction requirements
37. ____ coupling describes the extent to which modules are independent of one another.
A) verification
B) process
C) module
D) cohesive
38. The ____ design is the process of selecting the data storage and data access characteristics of the database.
A) time
C) logical
D) physical
39. There are ____ classical approaches to database design.
40. During decentralized design, after the ____ process has been completed, all modules are integrated into one conceptual model.
A) initial
B) verification
C) conceptual
D) logical
