Database Design and Development Project

Project Goal

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.

Methodologies and Tools:

• Relational Database with PostgreSQL
• ER and ERR Mapping with diagrams.net

Workflow:

This project follows a waterfall model, with the phases listed below.

1. User requirements analysis
2. Conceptual Design
3. Logical Design
4. Physical Design
5. Normalization
6. CRUD Operation
7. Business Inquiries with Advance PostgreSQL

Directory

| - 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

Future Development:

This database can be use in conjunction with internal softwares in order to provide better UI for users.