Search for question
Question

Q1:

Based on the relational diagram below, answer the following questions

1. Based on the table structure, which table is a junction table?

2. What type of relationship is between the building and the room table, 1-1, 1-*, *-*?

3. Write a SQL query to show all the room reservations.

4. Write a SQL query to show all guests whose Last name contains 'G' in any position.

5. Show all room reservations with building descriptions.

PK Gcode. int

GFirstName Varchar(50)

GLastName Varchar(50)

PK

Guest

FK

Room

RMCode

RMDesc

BCode

Floor

int

Char(50)

int

int

MaxOccupancy Type

RoomReservation

PK,FK RMCode

PK,FK GCode

int

int

RsvOccupancy int

Building

PK BCode

BDesc

BXCoOrd

BYCOOrd

int

varchar(50)

int

int

Fig: 1