logo

Crowdly

Dado HUESPED_GUEST(dni_idcard,nombre_name,nacio_born), siendo dni_idcard su prim...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Dado HUESPED_GUEST(dni_idcard,nombre_name,nacio_born), siendo dni_idcard su primary key,HAB_ROOM(planta_floor,num,tipo_type) siendo su primary key planta_floor y num, con num el número de habitación, y RESERVA_RESERVATION(dni_idcard,planta_floor,num,desde_from,hasta_to), con dni_idcard referenciando a HUESPED_GUEST.dni_idcard, planta_floor y num referenciando a HAB_ROOM.planta_floor y HAB_ROOM.num respectivamente, donde la tabla RESERVA_RESERVATION guarda las reservas de habitaciones de los huéspedes a lo largo de cinco años. ¿Qué devuelve la siguiente consulta?

Given HUESPED_GUEST(dni_idcard,nombre_name,nacio_born) with dni_idcard being its primary key, HAB_ROOM(planta_floor,num,tipo_type) with its primary key being planta_floor and num, with num being the room number, and RESERVA_RESERVATION(dni_idcard,planta_floor,num,desde_from,hasta_to) with dni_idcard referencing  HUESPED_GUEST.dni_idcard, planta_floor and num referencing HAB_ROOM.planta_floor and HAB_ROOM.num respectively, where the table RESERVA_RESERVATION stores the room reservations done during the last five years. What is the result of the following statement?

More questions like this

Want instant access to all verified answers on campusvirtual.uclm.es?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!