I have created my Online Taxi Booking Application in Rails and it has created all the required files to start off my development project.
The next step is to create the Taxi database which was detailed in Workshop 1 as follows:
The database called taxi has TWO tables called passenger_origin and passenger_destination:
Passenger_origin:
Name, Contact No., Suburb, Street, Street No., Building (Unit, house or business);
Passenger_destination:
Suburb, No. of passengers (1 to 4), taxi type, time required;
Created the database Taxi and the tables Passenger_origin and Passenger_Destination using mysql as follows:
mysql -u root
create database taxi;
use taxi;
create table passenger_origin (
name varchar(40),
contactno varchar(10),
suburb varchar(40),
street varchar (30),
streetno varchar(5),
building varchar(20)
);
create table passenger_destination(
suburb varchar(40),
noofpassengers tinyint,
taxitype varchar(20),
timerequired datetime
);
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment