CS340 Database Web Application Project

This project is a full-stack, database-driven web application developed for
CS 340 — Introduction to Database Systems.

The project demonstrates the complete lifecycle of relational database development — from requirements analysis and data modeling to SQL implementation and web-based CRUD operations.

Project Phases Database Schema

---

What This Project Covers

• Relational Database Design

  ---

  Conceptual modeling (ER/EER), relational schema mapping, normalization, and integrity constraint enforcement.

• SQL Implementation

  ---

  Creation of tables, keys, constraints, and execution of structured queries through backend logic.

• Full-Stack Integration

  ---

  Connecting a relational database to a functional web interface supporting CRUD operations.

• Structured Documentation

  ---

  Phase-based documentation with reproducible design decisions, schema definitions, and implementation details.

---

Objectives

• Design a relational database from concept to implementation
• Enforce entity integrity and referential integrity
• Implement SQL queries within backend application logic
• Deliver a fully functional web-based CRUD system
• Apply structured, phase-based development methodology

---

Scope

This project emphasizes database correctness, integrity enforcement, and system integration rather than interface complexity.

The focus is on:

• Data modeling accuracy
• Proper schema design
• Constraint enforcement
• Query correctness
• Clean system architecture

All development follows structured academic guidelines to ensure clarity, reproducibility, and technical rigor.

---

Project Phases

• Phase I — Requirements & Architecture

  ---

  Define system scope, identify stakeholders, develop usage scenarios, and design the system architecture and UI prototype.

  Phase I Overview

• Phase II — Data Modeling

  ---

  Develop EER diagrams, relational schemas, normalization, and enforce structural integrity constraints.

  Phase II Overview

• Phase III — Implementation

  ---

  Implement the database using SQL, integrate with backend logic, and validate data operations.

  Phase III Overview

• Phase IV — Testing & Finalization

  ---

  Perform validation, query testing, system verification, and final documentation review.

  Phase IV Overview

---

Tools and Technologies

• Relational Database (MySQL)

  ---

  Used to implement structured schema with primary keys, foreign keys, and constraints.

• :material-language-sql: SQL

  ---

  Data Definition Language (DDL) and Data Manipulation Language (DML).

• Backend + Web Interface

  ---

  Database-driven CRUD operations executed through application logic.

• MkDocs (Material)

  ---

  Structured documentation framework for clean, academic project publication.

---

Team Collaboration

• GitHub + Documentation Website — Version control and structured phase access
• WhatsApp — Coordination and quick clarifications
• Google Docs — Collaborative drafting and review

---

Individual Contributions (Phase I)

Member	Contribution
Yara Albugami	Defined target users, usage scenarios, and system requirements.
Shoug Alomran	Designed system architecture and UI wireframes; aligned interface with database operations.
Rose Al Rakan	Defined core data requirements and supported documentation structure.
Raghad Abdulaziz	Assisted with requirement refinement, system review, and documentation consistency.

---