This is a class project I did with my friends for Database Management Systems class at MUICT. We start from developing business requirements to coding an SQL database. Here's a brief list of what we did.
- Business domain and business analysis
- Summarising business requirements and/or functions
- Designing relational schema
- Drawing ER diagrams
- Chen diagram
- Crow foot diagram
- Setting up an SQL database
- Some queries
In this repository, I have a PDF file which is a whole report of what we did, all the diagrams, and some query codes. The code doesn't include the setting up part, however.
Enjoy! :D