Design and implement a database to store all the data held in DroneStore, OperatorStore and MapStore. The database should include all the tables needed, the columns within each table and the relationships between each table. For maps, you can assume the map image will be stored outside the database. The database will just store the filename of the map. The design should handle the following rules:

MapStore - map_name primary key , filepath

DroneStore which consists of dronename,classtype,rescue drone,operator

Operator Store operatorid,firstname,lastname,birthdate,license,rescue,operations

1 -A drone can be operated by zero or one operators. 2-An operator can use zero or one drones. 3-A drone can be on zero or one maps. 4-A map can have zero or more drones (no limit).

CAn you add the foreign keys and relationships in the table please thank u