The database used in this project has been made with MySQL.
There is a report written in Latex which explains in detail the organization, structure and operation of the entire project.
There is also its PDF version.
- Register a new component.
- Create a new team.
- Replace a team member.
- Add a constructor.
- Assign a constructor to a team.
- View a history of team members.
- Create a new Championship.
- Register a team for a Championship.
- Add an Autodrome.
- Add a new race to a championship.
- Record the outcome of an event.
- View an event finish ranking.
- Calculate a driver's score in an event.
- Calculate a constructor's score in an event.
- Find the winner of the drivers' championship at the end of the season.
- Find the winner of the constructors' championship at the end of the season.
- Sell a ticket for an event.
A detailed explanation, also including the analysis of the entities taken into consideration and calculation of the cost of each operation is present in the report.
- The URL and credentials for the database must be inserted in the file "src/database/DBConnection.java"
String url = "???";
String user = "???";
String password = "???";
Connection con = DriverManager.getConnection(url, user, password);
- Start the program using the main present in the file "src/start/ApplicationStart.java"