Scribd
Upload
13 views31 pages

Advanced Database Development Process Guide

The document outlines the advanced database development process, emphasizing structured stages such as requirement gathering, data modeling, implementation, and performance testing to meet organizational needs. It highlights the importance of accurate requirements and documentation for ensuring data security, scalability, and informed decision-making. Real-world applications are mentioned, including banking and e-commerce, illustrating the relevance of this process in various sectors.

Uploaded by

Princess Lyka Santos
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views31 pages

Advanced Database Development Process Guide

The document outlines the advanced database development process, emphasizing structured stages such as requirement gathering, data modeling, implementation, and performance testing to meet organizational needs. It highlights the importance of accurate requirements and documentation for ensuring data security, scalability, and informed decision-making. Real-world applications are mentioned, including banking and e-commerce, illustrating the relevance of this process in various sectors.

Uploaded by

Princess Lyka Santos
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Unit I.

Advanced Database
Development Process
IT IM01 (Advanced Database System)
Content:
•
•
•
•
•
•
•
•
•
Intended Learning Outcomes
Intended Learning Outcomes
Introduction

The advanced database development process is a structured


approach to designing and building systems that meet the complex
needs of modern organizations. It covers key stages such as
requirement gathering, data modeling, implementation, and
performance testing to ensure efficiency and reliability. Real-world
applications include banking transactions, hospital records, and e-
commerce operations. A well-executed process ensures data
accuracy, security, scalability, and proper documentation, enabling
organizations to make informed decisions and adapt to future
challenges.
Understanding DDLC
✓

✓
DDLC Stages
DDLC Stages
Types of Requirements

➢
Types of Requirements

➢
Sample Data Requirements Specification

Requirement Type Description Priority

Functional Allow customers to search products by category High

Functional Store order history for each customer High

Non-Functional Database must support 10,000 concurrent users High

Non-Functional Encrypt all payment details Critical


Importance of Requirements Gathering and Analysis

✓
Database Design Documentation (DDD)

➢
DDD Key Components

✓
DDD Key Components

✓
✓

Sample of Data Dictionary for Residents’ Table


DDD Key Components

Sample of Schema Table for PROGRAM


DDD Key Components

•
•
• ₱
Importance of DDD

✓
Developing a Preliminary Design Document(PDD)
Contents in PDD
Importance of PDD

✓
Evaluating Design Documentation

✓
Evaluation Criteria (Checklist)
Key Takeaways
✓

✓
Key Takeaways
✓

✓
Q&A
Seatwork
Case Study Analysis
✓
✓
✓
✓
✓

You might also like