)(Answer according to Figure 1) a) Create database tables and relations for two entities namely GPS POSITION and ADDRESS by using SQL Data Definition Language (DDL) (create/alter) statements.

b) Show on ADDRESS table you can INSERT, UPDATE and DELETE data by using SQL Data Manipulation Language (DDL) statements.

e) Make any 3 Integrity Tests and explain on some the 2 Tables namely GPS POSITION and ADDRESS.

Oracle SQL Developer Data Modeler - Vehicle TrackingSystem File Edit View Team Tools Window Help Start Page 20 Logical (Vehicle TrackingSystem) ADDRESS containing CUSTOMER #* Customer ID * Name * Surname o Gender # * Address ID * Description o Level having used for Irelated to Yunder having GPS POSITION #*GPS Position ID VEHICLE # * Vehicle ID * Plate No *Y * Z o Description for for utilised for related to CUSTOMER LOCATION o Preceedence subject to VEHICLE ROUTE # Date for Visit * Order ID containing Figure 1. Data Model for Vehicle Tracking System