CREATE DATABASE Trenuri;
GO
Use Trenuri;
CREATE TABLE Tipuri (id_tip INT PRIMARY KEY,
		descriere VACRCHAR(50));
CREATE TABLE Trenuri (id_tren INT PRIMARY KEY,
		nume VARCHAR(50),
		id_tip INT FOREIGN KEY	REFERENCES Tipuri(id_tip));
CREATE TABLE Rute (id_ruta INT PKRIMARY KEY,
		nume VARCHAR(50),
		id_tren INT FOREIGN KEY	REFERENCES Trenuri(id_tren));
CREATE TABLE Statii(id_statie INT PRIMARY KEY,
		nume VARCHAR(50));
CREATE TABLE leg_rute_statii(id_ruta INT FOREGIN KEY REFERENCES Rute(id_ruta),
		id_statie INT FOREIGN KEY REFERENCES Statii(id_statie),
		sosire TIME,
		plecare TIME,
		CONSTRAINT PK_rute_statii PRIMARY KEY (id_ruta, id_statie));