DATABASES

Entity Relationship Diagram Describing the Database Setup for Drones and UAVs Traffic Management and Control

Each ‘Area’ contains a tower in the middle which communicates with drones using EM signals. An area is spherical in shape.

The diagram has the following Entities:

1. Make: This entity stores information about the construction of a drone.
2. Drone: This entity stores information about a drone in use including its Reg_No., Identity Code, Color, Usage Type, Payload Type etc.
3. Owner: This entity stores information about an owner of a drone including its name, organization, identification number
4. Area: A geographical area which is around a tower situated at Latitude and Longitude and having a Radius. The entity also stores the rules or patterns of a drone’s Identity Code allowed in the area of a tower.
5. Asset: An asset is a camera situated at Latitude and Longitude. It is accesible to a tower at Address. It stores information about the uptime and downtime of a camera

The diagram has the following Relationships:

1. IS_OF: Make & Drone: Specifies the make of a drone. A Drone can only have one Make.
2. OWNS: Drone & Owner: Specifies the owner of a drone. A Drone can only have one Owner.
3. Warns: Area & Owner: Stores details about warnings issued to an owner due to unlawful access by a Drone. Drone_Reg_No at Date, Time.
4. Visits: Area & Drone: It stores information about a visit of a Drone to an Area, at Date and Time and if the visit was valid or not.
5. Detects: Asset & Drone: It stores inforamaton about detection of a Drone by an Asset at Date and Time .
6. Monitors: Asset & Area: It stores inforamtion about which Asset monitors which Area. Under present scheme an Asset monitors1 Area.
7. Alarm: Asset & Area: Stores details about an Alarm raised by a tower in an Area due to an unknown drone detected by Asset at Date, Time.

Assumptions: We assume that all the drones flying at any point of time are registered with a central authority and hence can be assigned certain unique identifiers.

National Schema for Drones and UAVs

Following are the database entries and their respective attributes:

1. Drone: Registration Number, Identification Code, Owner Id, Payload Type, Payload Capacity, Power, Maximum Speed, Maximum Height, Commercial, Place of Registration, Make, Color, Height, Width, Length, Weight – Details of Drone are stored in the schema.
2. Owner: Owner Id, Name, Organization, Organization Type, Identity Card Type, Identity Card Number – Details of Drone Owner are recorded.
3. Area: Area Id, Latitude of Center, Longitude of Center, Radius of Coverage – Details of the area where drone flies is recorded.
4. Assets: Assetid, Asset Type, Access Address, Latitude, Longitude, Area Id, Uptime, Downtime – Asset details are recorded
5. Drone Detected: Detected Number, Registration Number, Asset Id, Date, Time, Validity – Attributes related to the detection of drone are kept.
6. Drone Visited: Visit Number, Registration Number, Visit Id, Date, Time, Validity – Attributes related to the drone visit are recorded and kept.
7. Warnings: Warning Number, Area Id, Registration Number, Owner Id, Visit Number – Warning details for the drone are recorded and shared.
8. Alarms: Alarm Number, Area Id, Asset Id, Detected Number, Date, Time – Alarms for the drones are recorded, notified and logged.