This project revolves around the management of fire stations.
-
A fire station is a place where firefighters gather and where trucks are stored. Each fire station has an address, an identification number, a maximum human capacity, and a storage capacity for trucks. Each fire station numbers its trucks and firefighters.
-
A firefighter has a number assigned by the station where he is assigned, as well as a name and an address. An address consists of four parts: a street number, a street name, a postal code, and a city name. For each address, we have an estimate of the mileage between this address and the nearest fire station.
-
For each city, we know its population. We also know the fire stations that protect a city, and the cities that a fire station protects.
-
A truck has a number assigned by the station where it is stored, as well as a maximum number of seats and a model. Among the trucks, we distinguish the tankers for which we also want to know their capacity.
-
A truck model is identified by its name (Premium210,...). For each model, we know the type of truck (heavy-fast,...) as well as its engine (210hp,...) and its manufacturer identified by the brand (Renault,...).
-
We know for each manufacturer the address of its head office, as well as its average delivery time.
-
What is the number of fire stations?
-
Who are the firefighters (identifiers, names, first names) of the fire stations located in Draguignan?
-
What are the fire stations protecting both Brignoles and Le Luc?
-
Who are the firefighters (identifiers, names, first names) of fire station 3 living more than 5 kms from the "nearest" fire station for their address?
-
What is the number of firefighters per fire station?
-
What are the fire stations that have reached their maximum human capacity?
-
Who are the firefighters who do not work in the city where they live?
-
List in descending order the fire stations according to the number of firefighters working there.
-
Give for each fire station the total volume of water of its tankers.
-
In which fire station(s) is/are the tanker(s) with the largest capacity located?
| Leo Jourdain |
| Mapathe Faye |
| Jaffar Gura |