Hi hope you are doing well I want to submit this assignment but first of all I want to say that I want this on time and to be done well. this assignment has only 3 tasks everything is mentioned in document how to do I will provide you all supported documents but still you have any queries kindly call me on my number and most Important thing I want to say there is required my name and details in every document so kindly fill that part do not miss my details are STUDENT NAME: AHMER NASIRSTUDENT ID: 6880101AND EMAIL:
[email protected] date kindly put date on which date you complete document and then on next document next day date like you have 3 days so put date like you did one task in a daykindly fill then in every document and save every document with exact document name as mentioned in document because I will direct submit I can't edit because I don't have the software for edit these kind of documents kindly read details carefully and follow all these I would be very thankful thanks.
Sample_database/TRANSPORT/.DS_Store Sample_database/TRANSPORT/dbcount.sql /* DPIT115 : Data Management and Security SESSION : Summer Session 2020 */ SELECT (SELECT COUNT(*) FROM EMPLOYEE ) EMPLOYEE, (SELECT COUNT(*) FROM DRIVER ) DRIVER, (SELECT COUNT(*) FROM ADMIN ) ADMIN, (SELECT COUNT(*) FROM TRUCK ) TRUCK, (SELECT COUNT(*) FROM TRIP ) TRIP, (SELECT COUNT(*) FROM TRIPLEG ) TRIPLEG FROM DUAL; Sample_database/TRANSPORT/dbcreate.sql /* DPIT115 : Data Management and Security SESSION : Summer Session 2020 */ /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ CREATE TABLE EMPLOYEE( ENUM DECIMAL(12)NOT NULL, FNAME VARCHAR(50)NOT NULL, INITIALS VARCHAR(5) NULL, LNAME VARCHAR(50) NOT NULL, DOB DATE NULL, BLDG DECIMAL(3) NOT NULL, STREET VARCHAR(50)NOT NULL, SUBURB VARCHAR(50)NOT NULL, STATE VARCHAR(5)NOT NULL, ZIPCODE DECIMAL(4)NOT NULL, CONSTRAINT EMPLOYEE_PKEY PRIMARY KEY(ENUM) ); /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ CREATE TABLE DRIVER( ENUM DECIMAL(12) NOT NULL, LNUM DECIMAL(8) NOT NULL, STATUS VARCHAR(10) NOT NULL, CONSTRAINT DRIVER_PKEY PRIMARY KEY(ENUM), CONSTRAINT DRIVER_UNIQUE UNIQUE(LNUM), CONSTRAINT DRIVER_FKEY FOREIGN KEY(ENUM) REFERENCES EMPLOYEE(ENUM), CONSTRAINT DRIVER_STATUS CHECK ( STATUS IN ('AVAILABLE', 'BUSY', 'ON LEAVE')) ); /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ CREATE TABLE ADMIN( ENUM DECIMAL(12) NOT NULL, POSITION VARCHAR(50) NOT NULL, CONSTRAINT ADMIN_PKEY PRIMARY KEY(ENUM), CONSTRAINT ADMIN_FKEY FOREIGN KEY(ENUM) REFERENCES EMPLOYEE(ENUM) ); /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ CREATE TABLE TRUCK( REGNUM VARCHAR(10) NOT NULL, CAPACITY DECIMAL(7) NOT NULL, WEIGHT DECIMAL(7) NOT NULL, STATUS VARCHAR(10) NOT NULL, CONSTRAINT TRUCK_PKEY PRIMARY KEY(REGNUM), CONSTRAINT TRUCK_STATUS CHECK ( STATUS IN ('AVAILABLE', 'USED', 'MAINTAINED')), CONSTRAINT TRUCK_WEIGHT CHECK ( WEIGHT > 0.0 AND WEIGHT < 500000="" ),="" constraint="" truck_capacity="" check="" (="" capacity=""> 0.0 AND CAPACITY < 100000 ) ); /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ create table trip( tnum decimal(10) not null, lnum decimal(8) not null, regnum varchar(10) not null, tdate date not null, constraint trip_pkey primary key (tnum), constraint trip_ckey unique (lnum, regnum, tdate), constraint trip_fkey1 foreign key (lnum) references driver(lnum), constraint trip_fkey2 foreign key (regnum) references truck(regnum) ); /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ create table tripleg( tnum decimal(10) not null, legnum decimal(2) not null, departure varchar(30) not null, destination varchar(30) not null, constraint tripleg_pkey primary key (tnum, legnum), constraint tripleg_unique unique(tnum, departure, destination), constraint tripleg_fkey1 foreign key (tnum) references trip(tnum) ); /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ sample_database/transport/dbdrop.sql drop table tripleg; drop table trip; drop table driver; drop table admin; drop table truck; drop table employee; sample_database/transport/dbload.sql /* dpit115 : data management and security session : summer session 2020 */ insert into employee values( 1, 'john', null, 'smith', null, 42, 'victoria st.', 'hurstville', 'nsw', 2456 ); insert into employee values( 2, 'peter', null, 'taylor', '1970-01-12', 42, 'victoria st.', 'hurstville', 'nsw', 2456 ); insert into employee values( 3, 'john', null, 'doe', '1966-03-23', 12, 'station st.', 'dapto', 'nsw', 2530 ); insert into employee values( 4, 'john', null, 'gray', '1988-05-05', 16, 'station st.', 'dapto', 'nsw', 2530 ); insert into employee values( 5, 'adam', null, 'taylor', '1980-01-01', 42, 'church st.', 'city', 'nsw', 2300 ); insert into employee values( 6, 'michael', null, 'jones', '1975-03-05', 23, 'waterloo ave.', 'surry hills', 'nsw', 2502 ); insert into employee values( 7, 'frederic', null, 'jones', null, 3, 'victoria st.', 'redfern', 'nsw', 2420 ); insert into employee values( 8, 'peter', null, 'o''brien', '1983-02-28', 19, 'lucas dr.', 'horsley', 'nsw', 2530 ); insert into employee values( 9, 'john', null, 'lucas', '1966-12-16', 20, 'huxley st.', 'horsley', 'nsw', 2530 ); insert into employee values( 10, 'john', null, 'fox', '1975-10-15', 18, 'victoria st.', 'hurstville', 'nsw', 2456 ); insert into employee values( 11, 'adam', null, 'fox', null, 45, 'victoria st.', 'hurstville', 'nsw', 2456 ); insert into employee values( 12, 'phillip', null, ',cox', '1984-12-12', 5, 'the avenue', 'rockdale', 'nsw', 2300 ); insert into employee values( 13, 'andrew', 'k', 'smith', '1969-04-04', 42, 'bambaramba ave.', 'pennant hills', 'nsw', 2556 ); insert into employee values( 14, 'andrew', 'r', 'smith', '1992-04-01', 67, 'king cr.', 'hurstville', 'nsw', 2456 ); insert into employee values( 15, 'michael', null, 'potter', '1995-04-01', 568, 'bong bong st.', 'horsley', 'nsw', 2530 ); insert into employee values( 16, 'harry', null, 'potter', '1995-04-01', 568, 'bong bong st.', 'horsley', 'nsw', 2530 ); insert into employee values( 17, 'james', null, 'bond', null, 007, 'alan bond st.', 'perth', 'wa', 6000 ); insert into employee values( 18, 'paris', null, 'hilton', null, 1, 'hilton st.', 'melbourne', 'vic', 3000 ); insert into employee values( 19, 'lady', null, 'gaga', null, 3, 'pork st.', 'hobart', 'tas', 7000 ); insert into employee values( 20, 'robin', null, 'hood', null, 6, 'nottingham pl.', 'sydney', 'nsw', 2000 ); insert into employee values( 21, 'lars', 'q', 'peterson', null, 6, 'northfields ave.', 'wollongong', 'nsw', 2522 ); insert into driver values( 1, 10001, 'available' ); insert into driver values( 2, 10008, 'on leave' ); insert into driver values( 3, 10002, 'available' ); insert into driver values( 4, 10004, 'available' ); insert into driver values( 5, 10003, 'on leave' ); insert into driver values( 6, 10012, 'available' ); insert into driver values( 7, 20002, 'busy' ); insert into driver values( 8, 20003, 'busy' ); insert into driver values( 9, 30005, 'busy' ); insert into driver values( 10, 40002, 'busy' ); insert into driver values( 11, 20045, 'available' ); insert into driver values( 12, 20055, 'available' ); insert into driver values( 13, 20065, 'available' ); insert into driver values( 14, 10305, 'available' ); insert into driver values( 15, 10345, 'available' ); insert into driver values( 16, 10705, 'available' ); insert into driver values( 17, 40005, 'available' ); insert into admin values( 18, 'support' ); insert into admin values( 19, 'director' ); insert into admin values( 20, 'ceo' ); insert into truck values( 'pkr768', 1234, 3000, 'available' ); insert into truck values( 'sst005', 12000, 50000, 'used' ); insert into truck values( 'qrt834', 5550, 400, 'used' ); insert into truck values( 'lucy01', 100, 300, 'available' ); insert into truck values( 'kkk007', 10000, 3000, 'maintained' ); insert into truck values( 'syf777', 3333, 4566, 'maintained' ); insert into truck values( 'pkr008', 22000, 8800, 'available' ); insert into truck values( 'xcf003', 30000, 10000, 'available' ); insert into truck values( 'gft008', 40000, 15000, 'available' ); insert into truck values( 'lucy02', 43000, 3000, 'available' ); insert into truck values( 'al08uk', 50000, 5000, 'available' ); insert into trip values( 1, 10001, 'pkr768', '2015-01-12' ); insert into trip values( 2, 10001, 'syf777', '2015-02-20' ); insert into trip values( 3, 10001, 'kkk007', '2015-03-12' ); insert into trip values( 4, 10001, 'pkr768', '2015-06-29' ); insert into trip values( 5, 20002, 'pkr768', '2015-01-12' ); insert into trip values( 6, 10002, 'syf777', '2015-02-20' ); insert into trip values( 7, 30005, 'kkk007', '2015-03-12' ); insert into trip values( 8, 10001, 'pkr768', '2015-01-13' ); insert into trip values( 9, 10002, 'qrt834', '2015-09-17' ); insert into trip values(10, 30005, 'kkk007', '2015-12-15' ); insert into trip values(11, 10003, 'sst005', '2016-01-23' ); insert into trip values(12, 10002, 'pkr768', '2016-03-12' ); insert into trip values(13, 20002, 'qrt834', '2015-04-23' ); insert into trip values(14, 20002, 'pkr008', '2015-04-23' ); insert into trip values(15, 30005, 'pkr768', '2015-05-24' ); insert into trip values(16, 30005, 'sst005', '2014-08-02' ); insert into trip values(17, 20002, 'qrt834', '2014-09-17' ); insert into trip values(18, 10001, 'kkk007', '2014-12-15' ); insert into trip values(19, 30005, 'sst005', '2016-01-23' ); insert into trip values(20, 10003, 'pkr768', '2016-03-12' ); insert into trip values(21, 10001, 'qrt834', '2012-04-23' ); insert into trip values(22, 30005, 'pkr008', '2012-04-23' ); insert into trip values(23, 10003, 'pkr768', '2012-05-25' ); insert into trip values(24, 20002, 'sst005', '2012-08-02' ); insert into trip values(25, 10001, 'pkr768', '2014-01-12' ); insert into trip values(26, 10001, 'syf777', '2013-02-20' ); insert into trip values(27, 20002, 'kkk007', '2013-03-12' ); insert into trip values(28, 30005, 'pkr768', '2010-06-29' ); insert into trip values(29, 10001, 'qrt834', '2010-09-17' ); insert into trip values(30, 10002, 'kkk007', '2010-12-15' ); insert into trip values(31, 10003, 'sst005', '2010-01-23' ); insert into trip values(32, 20002, 'pkr768', '2010-03-12' ); insert into trip values(33, 30005, 'qrt834', '2003-04-23' ); insert into trip values(34, 30005, 'pkr008', '2004-04-23' ); insert into trip values(35, 10001, 'pkr768', '2017-05-24' ); insert into tripleg values( 1, 1, 'sydney', 'melbourne'); insert into tripleg values( 1, 2, 'melbourne', 'hobart'); insert into tripleg values( 1, 3, 'hobart', 'perth'); insert into tripleg values( 1, 4, 'perth', 'adelaide'); insert into tripleg values( 1, 5, 'adelaide', 'wollongong'); insert into tripleg values( 2, 1, 'sydney', 'melbourne'); insert into tripleg values( 3, 1, 'sydney', 'melbourne'); insert into tripleg values( 4, 1, 'sydney', 'melbourne'); insert into tripleg values( 5, 1, 'melbourne', 'sydney'); insert into 100000="" )="" );="" *="" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~="" */="" create="" table="" trip(="" tnum="" decimal(10)="" not="" null,="" lnum="" decimal(8)="" not="" null,="" regnum="" varchar(10)="" not="" null,="" tdate="" date="" not="" null,="" constraint="" trip_pkey="" primary="" key="" (tnum),="" constraint="" trip_ckey="" unique="" (lnum,="" regnum,="" tdate),="" constraint="" trip_fkey1="" foreign="" key="" (lnum)="" references="" driver(lnum),="" constraint="" trip_fkey2="" foreign="" key="" (regnum)="" references="" truck(regnum)="" );="" *="" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~="" */="" create="" table="" tripleg(="" tnum="" decimal(10)="" not="" null,="" legnum="" decimal(2)="" not="" null,="" departure="" varchar(30)="" not="" null,="" destination="" varchar(30)="" not="" null,="" constraint="" tripleg_pkey="" primary="" key="" (tnum,="" legnum),="" constraint="" tripleg_unique="" unique(tnum,="" departure,="" destination),="" constraint="" tripleg_fkey1="" foreign="" key="" (tnum)="" references="" trip(tnum)="" );="" *="" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~="" */="" *="" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~="" */="" sample_database/transport/dbdrop.sql="" drop="" table="" tripleg;="" drop="" table="" trip;="" drop="" table="" driver;="" drop="" table="" admin;="" drop="" table="" truck;="" drop="" table="" employee;="" sample_database/transport/dbload.sql="" *="" dpit115="" :="" data="" management="" and="" security="" session="" :="" summer="" session="" 2020="" */="" insert="" into="" employee="" values(="" 1,="" 'john',="" null,="" 'smith',="" null,="" 42,="" 'victoria="" st.',="" 'hurstville',="" 'nsw',="" 2456="" );="" insert="" into="" employee="" values(="" 2,="" 'peter',="" null,="" 'taylor',="" '1970-01-12',="" 42,="" 'victoria="" st.',="" 'hurstville',="" 'nsw',="" 2456="" );="" insert="" into="" employee="" values(="" 3,="" 'john',="" null,="" 'doe',="" '1966-03-23',="" 12,="" 'station="" st.',="" 'dapto',="" 'nsw',="" 2530="" );="" insert="" into="" employee="" values(="" 4,="" 'john',="" null,="" 'gray',="" '1988-05-05',="" 16,="" 'station="" st.',="" 'dapto',="" 'nsw',="" 2530="" );="" insert="" into="" employee="" values(="" 5,="" 'adam',="" null,="" 'taylor',="" '1980-01-01',="" 42,="" 'church="" st.',="" 'city',="" 'nsw',="" 2300="" );="" insert="" into="" employee="" values(="" 6,="" 'michael',="" null,="" 'jones',="" '1975-03-05',="" 23,="" 'waterloo="" ave.',="" 'surry="" hills',="" 'nsw',="" 2502="" );="" insert="" into="" employee="" values(="" 7,="" 'frederic',="" null,="" 'jones',="" null,="" 3,="" 'victoria="" st.',="" 'redfern',="" 'nsw',="" 2420="" );="" insert="" into="" employee="" values(="" 8,="" 'peter',="" null,="" 'o''brien',="" '1983-02-28',="" 19,="" 'lucas="" dr.',="" 'horsley',="" 'nsw',="" 2530="" );="" insert="" into="" employee="" values(="" 9,="" 'john',="" null,="" 'lucas',="" '1966-12-16',="" 20,="" 'huxley="" st.',="" 'horsley',="" 'nsw',="" 2530="" );="" insert="" into="" employee="" values(="" 10,="" 'john',="" null,="" 'fox',="" '1975-10-15',="" 18,="" 'victoria="" st.',="" 'hurstville',="" 'nsw',="" 2456="" );="" insert="" into="" employee="" values(="" 11,="" 'adam',="" null,="" 'fox',="" null,="" 45,="" 'victoria="" st.',="" 'hurstville',="" 'nsw',="" 2456="" );="" insert="" into="" employee="" values(="" 12,="" 'phillip',="" null,="" ',cox',="" '1984-12-12',="" 5,="" 'the="" avenue',="" 'rockdale',="" 'nsw',="" 2300="" );="" insert="" into="" employee="" values(="" 13,="" 'andrew',="" 'k',="" 'smith',="" '1969-04-04',="" 42,="" 'bambaramba="" ave.',="" 'pennant="" hills',="" 'nsw',="" 2556="" );="" insert="" into="" employee="" values(="" 14,="" 'andrew',="" 'r',="" 'smith',="" '1992-04-01',="" 67,="" 'king="" cr.',="" 'hurstville',="" 'nsw',="" 2456="" );="" insert="" into="" employee="" values(="" 15,="" 'michael',="" null,="" 'potter',="" '1995-04-01',="" 568,="" 'bong="" bong="" st.',="" 'horsley',="" 'nsw',="" 2530="" );="" insert="" into="" employee="" values(="" 16,="" 'harry',="" null,="" 'potter',="" '1995-04-01',="" 568,="" 'bong="" bong="" st.',="" 'horsley',="" 'nsw',="" 2530="" );="" insert="" into="" employee="" values(="" 17,="" 'james',="" null,="" 'bond',="" null,="" 007,="" 'alan="" bond="" st.',="" 'perth',="" 'wa',="" 6000="" );="" insert="" into="" employee="" values(="" 18,="" 'paris',="" null,="" 'hilton',="" null,="" 1,="" 'hilton="" st.',="" 'melbourne',="" 'vic',="" 3000="" );="" insert="" into="" employee="" values(="" 19,="" 'lady',="" null,="" 'gaga',="" null,="" 3,="" 'pork="" st.',="" 'hobart',="" 'tas',="" 7000="" );="" insert="" into="" employee="" values(="" 20,="" 'robin',="" null,="" 'hood',="" null,="" 6,="" 'nottingham="" pl.',="" 'sydney',="" 'nsw',="" 2000="" );="" insert="" into="" employee="" values(="" 21,="" 'lars',="" 'q',="" 'peterson',="" null,="" 6,="" 'northfields="" ave.',="" 'wollongong',="" 'nsw',="" 2522="" );="" insert="" into="" driver="" values(="" 1,="" 10001,="" 'available'="" );="" insert="" into="" driver="" values(="" 2,="" 10008,="" 'on="" leave'="" );="" insert="" into="" driver="" values(="" 3,="" 10002,="" 'available'="" );="" insert="" into="" driver="" values(="" 4,="" 10004,="" 'available'="" );="" insert="" into="" driver="" values(="" 5,="" 10003,="" 'on="" leave'="" );="" insert="" into="" driver="" values(="" 6,="" 10012,="" 'available'="" );="" insert="" into="" driver="" values(="" 7,="" 20002,="" 'busy'="" );="" insert="" into="" driver="" values(="" 8,="" 20003,="" 'busy'="" );="" insert="" into="" driver="" values(="" 9,="" 30005,="" 'busy'="" );="" insert="" into="" driver="" values(="" 10,="" 40002,="" 'busy'="" );="" insert="" into="" driver="" values(="" 11,="" 20045,="" 'available'="" );="" insert="" into="" driver="" values(="" 12,="" 20055,="" 'available'="" );="" insert="" into="" driver="" values(="" 13,="" 20065,="" 'available'="" );="" insert="" into="" driver="" values(="" 14,="" 10305,="" 'available'="" );="" insert="" into="" driver="" values(="" 15,="" 10345,="" 'available'="" );="" insert="" into="" driver="" values(="" 16,="" 10705,="" 'available'="" );="" insert="" into="" driver="" values(="" 17,="" 40005,="" 'available'="" );="" insert="" into="" admin="" values(="" 18,="" 'support'="" );="" insert="" into="" admin="" values(="" 19,="" 'director'="" );="" insert="" into="" admin="" values(="" 20,="" 'ceo'="" );="" insert="" into="" truck="" values(="" 'pkr768',="" 1234,="" 3000,="" 'available'="" );="" insert="" into="" truck="" values(="" 'sst005',="" 12000,="" 50000,="" 'used'="" );="" insert="" into="" truck="" values(="" 'qrt834',="" 5550,="" 400,="" 'used'="" );="" insert="" into="" truck="" values(="" 'lucy01',="" 100,="" 300,="" 'available'="" );="" insert="" into="" truck="" values(="" 'kkk007',="" 10000,="" 3000,="" 'maintained'="" );="" insert="" into="" truck="" values(="" 'syf777',="" 3333,="" 4566,="" 'maintained'="" );="" insert="" into="" truck="" values(="" 'pkr008',="" 22000,="" 8800,="" 'available'="" );="" insert="" into="" truck="" values(="" 'xcf003',="" 30000,="" 10000,="" 'available'="" );="" insert="" into="" truck="" values(="" 'gft008',="" 40000,="" 15000,="" 'available'="" );="" insert="" into="" truck="" values(="" 'lucy02',="" 43000,="" 3000,="" 'available'="" );="" insert="" into="" truck="" values(="" 'al08uk',="" 50000,="" 5000,="" 'available'="" );="" insert="" into="" trip="" values(="" 1,="" 10001,="" 'pkr768',="" '2015-01-12'="" );="" insert="" into="" trip="" values(="" 2,="" 10001,="" 'syf777',="" '2015-02-20'="" );="" insert="" into="" trip="" values(="" 3,="" 10001,="" 'kkk007',="" '2015-03-12'="" );="" insert="" into="" trip="" values(="" 4,="" 10001,="" 'pkr768',="" '2015-06-29'="" );="" insert="" into="" trip="" values(="" 5,="" 20002,="" 'pkr768',="" '2015-01-12'="" );="" insert="" into="" trip="" values(="" 6,="" 10002,="" 'syf777',="" '2015-02-20'="" );="" insert="" into="" trip="" values(="" 7,="" 30005,="" 'kkk007',="" '2015-03-12'="" );="" insert="" into="" trip="" values(="" 8,="" 10001,="" 'pkr768',="" '2015-01-13'="" );="" insert="" into="" trip="" values(="" 9,="" 10002,="" 'qrt834',="" '2015-09-17'="" );="" insert="" into="" trip="" values(10,="" 30005,="" 'kkk007',="" '2015-12-15'="" );="" insert="" into="" trip="" values(11,="" 10003,="" 'sst005',="" '2016-01-23'="" );="" insert="" into="" trip="" values(12,="" 10002,="" 'pkr768',="" '2016-03-12'="" );="" insert="" into="" trip="" values(13,="" 20002,="" 'qrt834',="" '2015-04-23'="" );="" insert="" into="" trip="" values(14,="" 20002,="" 'pkr008',="" '2015-04-23'="" );="" insert="" into="" trip="" values(15,="" 30005,="" 'pkr768',="" '2015-05-24'="" );="" insert="" into="" trip="" values(16,="" 30005,="" 'sst005',="" '2014-08-02'="" );="" insert="" into="" trip="" values(17,="" 20002,="" 'qrt834',="" '2014-09-17'="" );="" insert="" into="" trip="" values(18,="" 10001,="" 'kkk007',="" '2014-12-15'="" );="" insert="" into="" trip="" values(19,="" 30005,="" 'sst005',="" '2016-01-23'="" );="" insert="" into="" trip="" values(20,="" 10003,="" 'pkr768',="" '2016-03-12'="" );="" insert="" into="" trip="" values(21,="" 10001,="" 'qrt834',="" '2012-04-23'="" );="" insert="" into="" trip="" values(22,="" 30005,="" 'pkr008',="" '2012-04-23'="" );="" insert="" into="" trip="" values(23,="" 10003,="" 'pkr768',="" '2012-05-25'="" );="" insert="" into="" trip="" values(24,="" 20002,="" 'sst005',="" '2012-08-02'="" );="" insert="" into="" trip="" values(25,="" 10001,="" 'pkr768',="" '2014-01-12'="" );="" insert="" into="" trip="" values(26,="" 10001,="" 'syf777',="" '2013-02-20'="" );="" insert="" into="" trip="" values(27,="" 20002,="" 'kkk007',="" '2013-03-12'="" );="" insert="" into="" trip="" values(28,="" 30005,="" 'pkr768',="" '2010-06-29'="" );="" insert="" into="" trip="" values(29,="" 10001,="" 'qrt834',="" '2010-09-17'="" );="" insert="" into="" trip="" values(30,="" 10002,="" 'kkk007',="" '2010-12-15'="" );="" insert="" into="" trip="" values(31,="" 10003,="" 'sst005',="" '2010-01-23'="" );="" insert="" into="" trip="" values(32,="" 20002,="" 'pkr768',="" '2010-03-12'="" );="" insert="" into="" trip="" values(33,="" 30005,="" 'qrt834',="" '2003-04-23'="" );="" insert="" into="" trip="" values(34,="" 30005,="" 'pkr008',="" '2004-04-23'="" );="" insert="" into="" trip="" values(35,="" 10001,="" 'pkr768',="" '2017-05-24'="" );="" insert="" into="" tripleg="" values(="" 1,="" 1,="" 'sydney',="" 'melbourne');="" insert="" into="" tripleg="" values(="" 1,="" 2,="" 'melbourne',="" 'hobart');="" insert="" into="" tripleg="" values(="" 1,="" 3,="" 'hobart',="" 'perth');="" insert="" into="" tripleg="" values(="" 1,="" 4,="" 'perth',="" 'adelaide');="" insert="" into="" tripleg="" values(="" 1,="" 5,="" 'adelaide',="" 'wollongong');="" insert="" into="" tripleg="" values(="" 2,="" 1,="" 'sydney',="" 'melbourne');="" insert="" into="" tripleg="" values(="" 3,="" 1,="" 'sydney',="" 'melbourne');="" insert="" into="" tripleg="" values(="" 4,="" 1,="" 'sydney',="" 'melbourne');="" insert="" into="" tripleg="" values(="" 5,="" 1,="" 'melbourne',="" 'sydney');="" insert="">