Create the Railway schema using the commands Q1 Create following tables ( a) trainhalts (id varchar(5) seqno integer stcode varchar(10), timein varchar(5) ,timeout varchar(5) primary key (id,seqno) ); This table stores the distances between directly connected stations stcode1 and stcode2. Assume that this represents a directed track. i.e, for two stations A and B, there will be an entry corresponding to (A, B, distance) and another for (B,A, distance). (b) track (stcode1 varchar(5) ,stcode2 varchar(5), distance integer , primary key (stcode1,stcode2) ); C) table station (stcode varchar(5), name varchar(20), primary key (stcode)); (d)table train (id varchar(5) ,name varchar(20), primary key (id) ); Enter following the data from a.sql 1. ...
Comments
Post a Comment