DRONE_TYPE
P * dt_code
* dt_model
* dt_carry_kg
F * train_code F * manuf_id
CHAR (4) VARCHAR2 (50) NUMBER(3) CHAR (5) NUMBER(5)
TRAINING
P * train_code
* train_desc
* train_hrs
* train_active_months
CHAR (5) VARCHAR2 (100) NUMBER(2) NUMBER(2)
MANUFACTURER
P * manuf_id NUMBER(5)
* manuf_name VARCHAR2 (25)
DRONE
P * drone_id
* drone_pur_date
* drone_pur_price * drone_flight_time * drone_cost_hr
F * dt_code
NUMBER(5) DATE NUMBER(7,2) NUMBER(6,1) NUMBER(6,2) CHAR (4)
TRAINING_COURSE
PF* train_code
P * traincourse_date F * trainer_id
CHAR(5) DATE NUMBER(3)
TRAINER
P * trainer_id
* trainer_rego
* trainer_fname
* trainer_lname
* trainer_category
NUMBER(3) CHAR (12) VARCHAR2 (25) VARCHAR2 (25) CHAR (1)
CUST_TRAIN
P * UF* UF* UF*
ct_id
cust_id train_code traincourse_date ct_exam_date ct_date_expire
NUMBER(7) NUMBER(4) CHAR (5) DATE
DATE DATE
RENTAL
P * rental_no * rent_bond * rent_out
rent_in F * drone_id
F * ct_id
NUMBER (8) NUMBER (6,2) DATE
DATE NUMBER (5) NUMBER (7)
CUSTOMER
P * cust_id
* cust_fname * cust_lname * cust_phone
NUMBER(4) VARCHAR2 (25) VARCHAR2 (25) CHAR (12)