Project Management Database
- Year
- 2023
- Role
- Database design & web app
- Stack
- ASP.NET Web Forms, C#, Oracle SQL, SQL Data Modeler
Overview
LS Corporation runs many projects at once, with users spread across them and each project broken into tasks, milestones and subtasks. The tracking for that had outgrown whatever was holding it. I designed the database for it from scratch.
The work started as textual analysis of the relationships. A user belongs to zero or more projects; a task cannot exist without one. That became an ER diagram and then a normalisation pass taking the records through 1NF, 2NF and 3NF to eliminate the partial and transitive dependencies. Twelve final tables, each with a data dictionary.
On top of it I built an ASP.NET Web Forms application for the CRUD operations, plus a dashboard summarising progress across projects, milestones and tasks. The documentation covers the whole path: analysis, normalisation, DDL scripts, the queries behind the complex forms, and test tables for each operation including the cases that failed first.
- ASP.NET Web Forms
- C#
- Oracle SQL
- SQL Data Modeler