joaquimesteves/databases-2016-ist

databases-2016-ist's Issues

Populate - not quite right

Most of the entries are the same. Fix it.

QUERIES FOR PHP

a) Inserir e Remover Edifícios, Espaços e Postos de trabalho
b) Criar e Remover Ofertas
c) Criar reservas sobre Ofertas //NO IDEA HOW
d) Pagar reservas //NO IDEA HOW
e) Para um dado edifício mostrar o total realizado para cada espaço //wtf is total realizado para cada espaço

Every remove must be on cascade or something. e) is probably part of the requested queries.

SOLUTIUON!Q!"FR§"!R§!

b)DELETE FROM Oferta WHERE morada = ‘rua da agua’;

c)INSERT INTO Oferta ()

INSERT INTO Reserva ()
INSERT INTO Aluga ()

d)select a reservation and at the date and the type of payment

INSERT INTO Paga(numero, data, metodo) VALUES ('1','2017-11-18','CASH');

e)

SELECT e.morada SUM(o.tarifa)*DATEDIFF(day,o.data_fim, o.data_inico)
FROM Paga p
NATURAL JOIN Reserva
NATURAL JOIN Aluga
NATURAL JOIN Oferta o
NATURAL JOIN Espaco e
GROUP BY e.morada
;

10 value queries.

C is not quite right.
D is untested.
E is a fuckin' mess.

session log out - php