The project aims to build a database from scratch for a hiking orgarnization, demonstrating step-by-step process from user requirement analysis, to identify entities and relationships with assumptions about cardinality and participation, EER modeling, relational schema, normalization, ending with the CRUD for illustrating purposes. In addition, 10 business queries are answered at the end, using advance SQL queries to generate reports.
- Relational Database with PostgreSQL
- ER and ERR Mapping with diagrams.net
This project follows a waterfall model, with the phases listed below.
- User requirements analysis
- Conceptual Design
- Logical Design
- Physical Design
- Normalization
- CRUD Operation
- Business Inquiries with Advance PostgreSQL
| - database-dev
| -- CRUD Includes all the CRUD operation
| --- Create_Tables.sql Includes queries to create tables
| --- Drop_Tables.sql Includes queries to drop tables
| --- Populate_Tables.sql Includes queries to populate tables
| -- SQL Queries Includes queries to generate reports
| --- SQL_Commands.sql Includes queries to answer business inquires
| -- README.md Includes the project's overview
| -- Database Development Report Includes all the details about the project's development
This database can be use in conjunction with internal softwares in order to provide better UI for users.