CREATE TABLE Firma(
  CodF SMALLINT PRIMARY KEY,
  Nume VARCHAR(30)
);

CREATE TABLE Utilizator(
  CodU SMALLINT PRIMARY KEY,
  CodF SMALLINT REFERENCES Firma(CodF),
  Nume VARCHAR(30),
  Prenume VARCHAR(30),
  Parola VARCHAR(30)
);

CREATE TABLE ObiectivTuristic(
  CodOT SMALLINT PRIMARY KEY,
  Nume VARCHAR(30),
  Locatie VARCHAR(30)
);

CREATE TABLE Excursie(
  CodE SMALLINT PRIMARY KEY,
  CodOT SMALLINT REFERENCES ObiectivTuristic(CodOT),
  CodF SMALLINT REFERENCES Firma(CodF),
  DataPlecarii DATE,-- "yyyy-MM-dd"
  OraPlecarii TIME, -- "HH:mm:ss"
  LocuriDisponibile SMALLINT
);

CREATE TABLE Rezervare(
  CodR SMALLINT PRIMARY KEY,
  CodE SMALLINT REFERENCES Excursie(CodE),
  NrPersoane SMALLINT NOT NULL,
  NumeClient VARCHAR(30),
  PrenumeClient VARCHAR(30),
  CNPClient VARCHAR NOT NULL UNIQUE
);

INSERT INTO Firma VALUES (1,"TransDor"),(2,"Move Fast"),(3,"Best Cars"),(4,"Slow as Snails")
INSERT INTO ObiectivTuristic VALUES (1,"Castel","Amsterdam"),(2,"Palatul de Cultura","Bucuresti"),(3,"Casa Memoriala Mihai Eminescu","Botosani"),(4,"Elas","Botosani"),(5,"Cel Mai Frumos Parc","Botosani")
INSERT INTO Utilizator VALUES (1,1,"Mihai","Popescu","123"),(2,1,"Alina","Vasilescu","321"),(3,1,"Mihai","Georovici","123"),(4,2,"Mihai","Luca","123"),(5,2,"George","Popescu","123"),(6,2,"Vasilescu","Popescu","123"),(7,3,"Mihai","Iovan","123"),(8,3,"George","Pangea","123"),(9,3,"Gustav","Arama","123")
INSERT INTO Excursie VALUES (1,1,1,"2018-04-01","08:00:00",30),(2,2,3,"2018-03-20","10:00:00",30),(3,4,2,"2018-04-01","11:30:00",30),(4,5,1,"2018-04-01","09:00:00",30),(5,1,1,"2018-04-02","18:20:00",30)
INSERT INTO Rezervare VALUES (1,1,5,"Mihai","Pop","143242345234432"),(2,2,5,"Vasile","Ioan","143245345234432"),(3,1,5,"Geore","Mihai","143242345333333")