This database assignment, involved managing a database of vehicle breakdowns. The assignment was done purely using SQL code. The website contains the SQL code used and the results produced when the SQL code was run. A range of SQL queries were used throughout the assignment for

• Creating the database and tables
• Adding in the foreign keys
• Calculations of data in specific fields (min() max() e.t.c.)
• Queries that can be useful specifically for the breakdown company including
  • The amount of engineers who work for the company
  • Breakdowns between different dates
  • Member details like how many vehicles each member owns and membership type chosen
  • How much each member is charged based on membership chosen and how many times each of their vehicles have broken down