This project was started by Justin Speers and Katharine Chen, and completed by Katharine Chen for the Database basics assessment.
The project helps operators organize trains. Operators have the capabilities to create, read, update, and delete train stations, train lines, and trains.
Clone the repository in your terminal.
https://github.com/katharinechen/train_system.git
After installing Postgres, enter the following code to create the appropriate database and files.
psql
CREATE DATABASE train_station;
\c train_station;
CREATE TABLE line (id serial PRIMARY KEY, name varchar);
CREATE TABLE station (id serial PRIMARY KEY, name varchar);
CREATE TABLE line_station (id serial PRIMARY KEY, line_id int, station_id int);After creating the necessary tables in the train_station database, clone the database for testing.
\c epicodus;
CREATE DATABASE train_station_test WITH TEMPLATE train_station;To run the program, run train_system.rb after installing Ruby.
ruby train_system.rbMIT