pls help :D

CREATE TABLE office ( Officeid INTEGER CONSTRAINT pk_office PRIMARY KEY, Officeaddress VARCHAR(32) NOT NULL CHECK(officeaddress = UPPER(officeaddress))); CREATE TABLE manufacturer ( Manufacturerid INTEGER CONSTRAINT pk_manufacturer PRIMARY KEY, Manufacturername VARCHAR(32) NOT NULL CHECK(manufacturername = UPPER(manufacturername))); CREATE TABLE vehicletype ( Vehicletypeid INTEGER CONSTRAINT pk_vehicletype PRIMARY KEY, Vehicletypename VARCHAR(32) NOT NULL CHECK (vehicletypename = UPPER (vehicletypename))); CREATE TABLE vehicle( Vehicleid INTEGER CONSTRAINT pk_vehicle PRIMARY KEY, Vehiclemodel VARCHAR(32) NOT NULL CHECK (vehiclemodel = UPPER (vehiclemodel)), Vehicleyear SMALLINT NOT NULL, Vehiclemileage INTEGER NOT NULL, Manufacturerid INTEGER REFERENCES manufacturer(manufacturerid), Vehicletypeid INTEGER REFERENCES vehicletype(vehicletypeid)); CREATE TABLE booking( Bookingid INTEGER CONSTRAINT pk_booking PRIMARY KEY, Bookingdateout DATE NOT NULL, Bookingdatein DATE NOT NULL, Vehicleid INTEGER REFERENCES vehicle(vehicleid), customerid INTEGER REFERENCES customer(customerid), officeid INTEGER REFERENCES office(officeid), paymentid INTEGER REFERENCES payment(paymentid)); CREATE TABLE vehiclebooking ( vehicleid INTEGER REFERENCES vehicle(vehicleid), bookingid INTEGER REFERENCES booking(bookingid), PRIMARY KEY (vehicleid, bookingid)); CREATE TABLE customer( Customerid INTEGER CONSTRAINT pk_customer PRIMARY KEY, Customername VARCHAR(64) NOT NULL CHECK(customername = UPPER(customername)), Customeraddress VARCHAR(64) NOT NULL CHECK(Customeraddress = UPPER(Customeraddress)), Customeremail VARCHAR(64) NOT NULL CHECK(Customeremail=UPPER(customeremail)), Customerphoneno INTEGER NOT NULL, Customerlicenceno INTEGER NOT NULL); CREATE TABLE payment ( Paymentid INTEGER CONSTRAINT pk_payment PRIMARY KEY, Paymenttype varchar(8) NOT NULL CHECK(paymenttype = UPPER(paymenttype)));