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