RAILWAY DATABASE

CREATE DATABASE railway;

USE railway;

 CREATE TABLE train (

    train_number VARCHAR(10) PRIMARY KEY, -- Indian train numbers are 5-digit codes

    train_name VARCHAR(100) NOT NULL,

    origin VARCHAR(50) NOT NULL,

    destination VARCHAR(50) NOT NULL,

    fare DECIMAL(7,2) NOT NULL, 

    seats_available INT NOT NULL

);

INSERT INTO train VALUES

('22436', 'Vande Bharat ', 'Delhi', 'Varnas',  1750, 45),

('12952', 'Rajdhani', 'Hyder', 'Mumbai', 2400, 18),

('12002', 'Shatabdi ', 'Delhi', 'Chennai', 1165, 85),

('12626', 'Kerala Exp', 'Mumbai', 'Trivand',  810, 120);