Database Design Flashcards
Systems Development
The process of creating an information system.
Systems Development Life Cycle's Planning Phase
The initial assessment and the feasibility study.
Systems Development Life Cycle's Analysis Phase
Discovery of user requirements, existing system evaluation, and logical system design.
Systems Development Life Cycle's Implementation Phase
Coding, testing, and debugging
Systems Development Life Cycle Detailed Systems Design Phase
The design of the system's process
Database Life Cycle Database Initial Study Phase
Analyzing the company situation
Database Life Cycle Database Design Phase
Selecting database management system (DBMS) software
Database Life Cycle Implementation and Loading Phase
Installing the DBMS, creating the database, and loading or converting the data.
Database Life Cycle Operation Phase
Producing the required information flow.
Virtualization
A technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.
Data Analysis and Requirements
In the context of the database design process, the conceptual design step that determines end-user views, outputs, and transaction-processing requirements.
Data Model Verification
In the context of the database design process, the conceptual design step that identifies ER modules and validates insert, update, and delete rules.
Distributed Database Design
In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy.
Physical Design
The process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.
Database
A carefully designed and constructed repository of facts that is a part of a larger whole known as an information system.
Systems Analysis
The process that establishes the need for, and the extent of, and information system.
Conceptual Design
A stage that uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.
Business Rule
A brief and precise narrative of a policy, procedure, or principle within a specific organization's environment.
Module
An information system component aht handles a specific business function, such as inventory, orders, or payroll.
Cohesivity
The strength of the relationships found among a module's entities.