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.