.png)
StayWell Student
Accommodation SQL Project
This project represents a collection of work from the CTS 2433 - SQL Database Design & Programming course, completed from May to August 2025. It demonstrates a comprehensive, hands-on understanding of SQL by developing a functional database for the StayWell Student Accommodation company.
​
The database integrates property, owner, resident, and service request data, enabling efficient management, scalable growth, and reliable decision-making. It demonstrates core SQL skills in database design, queries, procedural programming, and data security while addressing real-world business challenges.
Key Metrics
-
Designed and created relational tables with primary/foreign keys, data types, and integrity constraints.
-
Wrote single- and multi-table queries including joins, subqueries, and computed columns for detailed data retrieval.
-
Implemented stored procedures, functions, and cursors to automate business logic and streamline operations.
-
Managed data updates, schema changes, and views to adapt to evolving business needs.
-
Applied user access controls and indexing strategies to secure sensitive information and improve performance.
Insights
Strategic
How can a property management company quickly retrieve property, owner, and service request details in one place?
Operational
What methods ensure that only the right staff have the right level of access to sensitive business information?
Finance
What SQL logic can automate rent discounts or owner updates without manual calculations?
.png)