DBMS and SDLC Lecture Review

Comprehensive vocabulary flashcards covering Database Management Systems (DBMS) and the Systems Development Life Cycle (SDLC) based on lecture notes.

Database Management System (DBMS)

Software designed to create, manage, and interact with databases, handling data definition, storage, retrieval, and security in a structured environment.

DBMS (Interface Role)

Acts as the interface between users or applications and the database itself.

Three Core Assurances of DBMS

Ensures that data can be organized properly, accessed quickly, and manipulated safely.

PEMS

A mnemonic for the four key objectives of DBMS: Provide easy and efficient access to data, Maintain data integrity and consistency, Enforce data security, and Support concurrent data access.

Provide Easy and Efficient Access to Data

The key DBMS objective represented by 'P' in PEMS, ensuring fast and smooth data retrieval for users.

Maintain Data Integrity and Consistency

The key DBMS objective represented by 'M' in PEMS, preserving accurate and consistent data even when accessed by multiple users.

Enforce Data Security

The key DBMS objective represented by 'E' in PEMS, controlling who is permitted to access or modify database records.

Support Concurrent Data Access

The key DBMS objective represented by 'S' in PEMS, allowing simultaneous multi-user access without causing conflicts or data loss.

DRR BBC

A mnemonic for the six core functions of DBMS: Data Definition, Data Manipulation, Data Retrieval, Backup and Recovery, Data Security and Integrity, and Concurrency Control.

Data Definition

A core DBMS function that specifies how data is structured, including schemas, tables, and fields.

Data Manipulation

A core DBMS function responsible for data insertion, updating, deletion, and querying.

Data Retrieval

A core DBMS function that enables the execution of complex queries using SQL or other query languages.

Data Security and Integrity

A core DBMS function that protects the database from unauthorized access and data corruption.

Backup and Recovery

A core DBMS function that retains copies of data for system restoration following failures.

Concurrency Control

A core DBMS function that coordinates and manages simultaneous data access by multiple users.

Hierarchical DBMS

A type of DBMS where data is organized in a tree-like parent-child structure (Parent -> Child).

Network DBMS

A type of DBMS where data elements are connected through network-like relationships with multiple links (many connections).

Relational DBMS (RDBMS)

The most common DBMS type, which stores data in tables and uses SQL.

Object-Oriented DBMS

A DBMS type combining object-oriented programming with database features, guided by the principle Object = Code + Data.

NoSQL DBMS

A DBMS type designed for large-scale, unstructured, and distributed data systems ('Not only SQL' for Big Data).

RDBMS Examples

Relational database management systems highlighted for exams, specifically MySQL and Oracle.

NoSQL DBMS Applications

Large-scale platforms handling big, unstructured data mentioned as examples, specifically Facebook and Instagram.

BEHET

A mnemonic for the five real-world applications of DBMS: Banking Systems, E-commerce Platforms, Healthcare Systems, Educational Institutions, and Telecommunications.

Banking Systems (DBMS Application)

A real-world DBMS application used to track customer accounts, transactions, and balances securely.

E-commerce Platforms (DBMS Application)

A real-world DBMS application used to manage product listings, customer orders, and payments (e.g., Shopee, Lazada).

Healthcare Systems (DBMS Application)

A real-world DBMS application used to store patient data, lab results, and medical records.

Educational Institutions (DBMS Application)

A real-world DBMS application used to organize student information, grades, and schedules.

Telecommunications (DBMS Application)

A real-world DBMS application used to handle call logs, billing systems, and subscriber data.

Foundation of Data-Driven Operations

The overarching purpose of DBMS, ensuring every piece of information is structured, secure, and readily available whenever needed.

Systems Development Life Cycle (SDLC)

A structured framework and process that guides organizations and developers to effectively build, manage, and maintain information systems.

"Life Story" of a System

The conceptual journey of a system governed by SDLC, spanning from its initial idea until it is retired or replaced.

Two Core Assurances of SDLC

Ensures that the system meets user and business needs, and that it is developed in a cost-effective and timely way.

PAD D TIM

A mnemonic for the 7 phases of SDLC: Planning, Analysis, Design, Development, Testing, Implementation, and Maintenance.

Planning (SDLC Phase 1)

The SDLC phase that defines objectives, scope, resources, and timeline, setting the foundation (Keyword: FOUNDATION).

Analysis (SDLC Phase 2)

The SDLC phase dedicated to gathering and documenting requirements to understand what users need (Keyword: WHAT users need).

Design (SDLC Phase 3)

The SDLC phase that translates user requirements into a system blueprint, covering architecture, database models, and user interfaces (Keyword: BLUEPRINT).

Development (SDLC Phase 4)

The SDLC phase where actual coding and system construction take place based on the approved design (Keyword: CODING).

Testing (SDLC Phase 5)

The SDLC phase that ensures the system functions correctly, detects bugs, and verifies expectations (Keyword: BUG CHECK).

Implementation (SDLC Phase 6)

The SDLC phase focused on deploying the system into a live environment, training users, and transitioning from the old system to the new one (Keyword: GO LIVE).

Maintenance (SDLC Phase 7)

The SDLC phase that provides continuous support by fixing issues, updating features, and ensuring system reliability (Keyword: SUPPORT).

Better Project Management and Control

An SDLC benefit that supplies a clear operational structure for managing tasks, resources, and project timelines.

Transparency and Clear Communication

An SDLC benefit where every development phase is documented to keep all stakeholders informed.

Clear and Well-Defined Requirements

An SDLC benefit that prevents confusion and ensures all team members understand project goals.

Predictable and Measurable Outcomes

An SDLC benefit that enables project teams to accurately estimate time, costs, and deliverables.

Reduced Risks and Better ROI

An SDLC benefit in which a structured development cycle minimizes errors, eliminates wasted effort, and delivers higher quality.

Lack of Flexibility (SDLC Disadvantage)

A drawback of certain SDLC models that are rigid and difficult to modify once the development process has begun.

Uncertain Cost Estimation (SDLC Disadvantage)

A drawback reflecting the challenge of forecasting total expenditures at the beginning of large-scale projects.

Risk of Increased Time and Cost (SDLC Disadvantage)

A drawback where inaccurate assumptions or defective components cause project delays and extra expenses.

Delays Caused by Late Testing (SDLC Disadvantage)

A drawback occurring when testing takes place near the end of the cycle, causing major discovered errors to slow down overall progress.

Importance of SDLC

The fourfold value of SDLC: simplifying complex processes, transforming ideas into functional systems, improving planning and decision-making, and elevating quality and user experience.