Chapter 9

The primary objective in database design is to create complete, denormalized, redundant, and fully integrated conceptual, logical, and physical database models.
Click the card to flip 👆
1 / 50
Terms in this set (50)
The primary objective in database design is to create complete, denormalized, redundant, and fully integrated conceptual, logical, and physical database models.
False
The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.
False
The SDLC traces the history of an information system.
True
The SDLC provides the big picture within which the database design and application development can be mapped out and evaluated.
True
The existing hardware and software systems are studied during the planning phase.
False
In the detailed systems design phase, the designer starts the design of the system's processes.
False
During the testing phase, the system is subjected to exhaustive testing until it is ready for use.
False
To analyze the company situation, the database designer must discover what the company's operational components are, how they function, and how they interact.
True
After the initial declarations in a study, the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.
True
Database performance is one of the least important factors in all database implementations.
False
The process of database design and implementation is ___ development.databaseThe SDLC is divided into ___ phases.fiveThe initial assessment and the feasibility study are part of the SDLC's ____ phase.planningThe detailed system specification is part of the ___ phase of the SDLC.detailed systems designInstallation and fine tuning are part of the ____ phase of the SDLC.implementationEvaluation, maintenance, and enhancement are part of the ___ phase of SDLC.maintenanceThe SDLC is most important to the ____.system designer"Should the existing system be replaced?" is a question that is asked during the ___ stage of SDLC.planning"What are the requirements of the current system's end users?" is a question asked during the ___ phase of the SDLC.analysisThe logical systems design is created during the ___ phase of the SDLC.analysisThe design of the system's processes is completed during the ___ phase of the SDLC.detailed systems designThe database is loaded during the __ phase of the SDLC.implementationThere are ___ stages in the DBLC.sixCreating the conceptual design and selecting DBMS software are part of the ___ phase of the DBLC.database designInstalling the DBMS, creating the database, and loading or converting the data are part of the ___ phase of the DBLC.implementation and loadingTesting, fine-tuning, and evaluating the database and its applications are part of the ___ phase of the DBLC.testing and evaluationThe last step in the DBLC is ___.maintenance and evolutionThe implementation and loading phase of the DBLC involves ____.installing the DBMSThe conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ___.data analysis and requirementsThe conceptual design step that defines entities, attributes, and relationships is ___.entity relationship modeling and normalizationThe conceptual design step that defines the DBMS and data model to use is ____.distributed database design____ allows physical access to areas by authorized personnel only.Physical securityOnce the data has been loaded into the database, the ___ tests and fine-tunes the database performance, integrity, concurrent access, and security constraints.database administratorThe maintenance and evolution phase of the DBLC involves ____.introducing changesThe first step in developing the conceptual model using ER diagrams is to ____.identify, analyze, and refine the business rulesThe first step in the ER model verification process is to ___.identify the ER model's central entity_____ coupling describes the extent to which modules are independent of one another.ModuleThe ___ design is the process of selecting the data storage and data access characteristics of the database.physicalThere are ___ classical approaches to database design.twoDuring decentralized design, after the ___ process has been completed, all modules are integrated into one conceptual model.verificationThe advent of very sophisticated application generators and ____ tools has substantially decreased coding and testing time.debuggingThe company ___ describes the general conditions in which a company operates, its organizational structure, and its mission.situationThe proposed system is subject to limits known as ____ which are external to the system.boundariesThe implementation of the logical design in IBM's DB2 would require that you assign the rights to use the database to a ______.database administratorThe ____ design stage used data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.conceptualThe first step in ____ design is to discover the data element characteristics.conceptualIn order to develop an accurate data ____, the designer must have a through understanding of the company's data types, extent, and uses.modelWhen selecting DBMS ____, consider processors, RAM, disc space and so on.hardwareThe ____ design goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.logical___ design could become a very technical job that affects not only the accessibility of the data in the storage device but also the performance of the system.Physical