All the queries locations are listed in our PHP file, example, we added comments above the insert query
This repository contains the work of Michael Ge, Linda Ma and Irem Yucel for the CPSC304 - Introduction to Relational Databases Project. We are modelling the Team Canada's Olympic history.
- Milestones 0 Group Formation: September 28, 2021
- Milestones 1 Project Proposal, Conceptual Design: ER Diagram: October 8, 2021
- Milestones 2 Logical Design, RS, SQL DDL, Normalization, Query Design: October 25, 2021
- Milestones 3 Project Check In: November 5, 2021
- Milestones 4 Project Implementation: November 25, 2021
- Milestones 5 Group Demo: December 3, 2021
- Milestones 6 Individual and Peer Assessment: December 7, 2021
Benefits that this database provides to the application is a centralized space where users can query different statistics about Team Canada’s participation in past Olympics. This database allows users to view and compare Team Canada’s performance and resources that went into attending the Olympics during different years.
- This database gives users the functionality to query the database based on:
- People involved (whether that be athletes, coaches, or managers). Additionally, indicating whether athletes participated in individual sports or team sports
- Sports Canada participated
- Host country that held the game
- Sponsors that support the athletes
- Income that financed the people involved
- Medals won by the athletes
- Media broadcasts (how the sports were broadcasted)
Our application technology stack will be PHP and Oracle SQL.
| File name | Description |
|---|---|
Olympic's Team Canada Team 53.jpg |
the ER Diagram for this project |
Group53_304 Olympic Team Canada_Milestone1.pdf |
Detailed description of the project |
README.md |
Documentation about the group repository |
project-sql-ddl.sql |
File containing all the SQL queries |
oracle_teamcanada.php |
File that contains PHP code to query database |