Database Development Activities During the Systems Development Life Cycle (SDLC)

Flashcards covering key vocabulary and concepts related to database development activities during the Systems Development Life Cycle (SDLC), including models, design phases, and development approaches.

Systems Development Life Cycle (SDLC)

A process for planning, creating, testing, and deploying an information system.

Enterprise Data Model

An integrated view of the data produced and consumed across an entire organization.

Conceptual Data Model

A high-level representation of data requirements for a proposed information system.

Logical Database Design

Involves analyzing transactions, forms, displays, and inquiries to integrate database views into a conceptual data model and identifying data integrity and security requirements.

Physical Database Design and Definition

Defining the database to the DBMS, deciding on the physical organization of data, and designing database processing programs.

Logical Data Model (LDM)

Includes entities (tables), attributes (columns/fields), and relationships (keys) using business names and is independent of technology platform.

Physical Data Model (PDM)

Includes tables, columns, keys, data types, validation rules, database triggers, and access constraints using specific names and requires knowledge of the specific DBMS.

Database Implementation

Coding and testing database processing programs, completing documentation and training materials, and installing the database.

Database Maintenance

Analyzing the database to ensure evolving needs are met, tuning the database, and fixing errors.

Waterfall Approach

An SDLC approach where the outcome of one phase acts as the input for the next phase following a detailed, well-planned development process.

Rapid Application Development (RAD)

An iterative process of rapidly repeating analysis, design, and implementation steps until they converge on the system the user wants.

Agile Software Development

Focuses on satisfying customers, developing projects with inspired contributors, in-person interactions, working software, and continuous reflection and adaptation.

Prototyping

A popular Rapid Application Development (RAD) method that repeats implementation and maintenance activities with new prototype versions.