CREATE TABLE Bus ( Bus_id INTEGER NOT NULL AUTO_INCREMENT, regno VARCHAR(20) NOT NULL, model VARCHAR(20) NOT NULL, BusType_id INTEGER REFERENCES BusType ( BusType_id) , basedAt INTEGER REFERENCES Depot ( Depot_id) , PRIMARY KEY ( Bus_id ) ); CREATE TABLE BusType ( BusType_id INTEGER NOT NULL AUTO_INCREMENT, tno VARCHAR(20) NOT NULL, description VARCHAR(20) NOT NULL, PRIMARY KEY ( BusType_id ) ); CREATE TABLE Route ( Route_id INTEGER NOT NULL AUTO_INCREMENT, rno VARCHAR(20) NOT NULL, description VARCHAR(20) NOT NULL, startPoint VARCHAR(20) NOT NULL, endPoint VARCHAR(20) NOT NULL, PRIMARY KEY ( Route_id ) ); CREATE TABLE Driver ( Driver_id INTEGER NOT NULL AUTO_INCREMENT, bdno VARCHAR(20) NOT NULL, name VARCHAR(20) NOT NULL, salary VARCHAR(20) NOT NULL, PCVDate VARCHAR(20) NOT NULL, PRIMARY KEY ( Driver_id ) ); CREATE TABLE Depot ( Depot_id INTEGER NOT NULL AUTO_INCREMENT, dno VARCHAR(20) NOT NULL, dname VARCHAR(20) NOT NULL, daddress VARCHAR(20) NOT NULL, PRIMARY KEY ( Depot_id ) ); CREATE TABLE permittedOn ( BusType_id INTEGER NOT NULL REFERENCES BusType ( BusType_id) , Route_id INTEGER NOT NULL REFERENCES Route ( Route_id) , PRIMARY KEY ( Route_id, BusType_id ) ); CREATE TABLE supplies ( Depot_id INTEGER NOT NULL REFERENCES Depot ( Depot_id) , Route_id INTEGER NOT NULL REFERENCES Route ( Route_id) , PRIMARY KEY ( Route_id, Depot_id ) ); CREATE TABLE canOperate ( Driver_id INTEGER NOT NULL REFERENCES Driver ( Driver_id) , Route_id INTEGER NOT NULL REFERENCES Route ( Route_id) , PRIMARY KEY ( Route_id, Driver_id ) ); CREATE TABLE qualifiedOn ( Driver_id INTEGER NOT NULL REFERENCES Driver ( Driver_id) , BusType_id INTEGER NOT NULL REFERENCES BusType ( BusType_id) , PRIMARY KEY ( BusType_id, Driver_id ) );