Database Management systems, assignment help

No Plagiarism and do not copy directly and please provide citation and references of it.1. Discuss what you consider to be the three most important advantages for the use of a DBMS for a company like DreamHome and provide a justification for your selection.Discuss what you consider to be the three most important disadvantages for the use of a DBMS for a company like DreamHome and provide a justification for your selection._____________________________________________________________________________________2.Discuss each of the following concepts in the context of the relational data model: (a) Relation (b) Attribute (c) Domain (d) Tuple (e) Intension and Extension  (f) Degree and Cardinality_____________________________________________________________________________________3.Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses?_____________________________________________________________________________________4.The following tables form part of a database held in a relational DBMS:- Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress)where Hotel contains hotel details and hotelNo is the primary key;Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms the primary key;andGuest contains guest details and guestNo is the primary key.Compose an SQL that lists the rooms that are currently unoccupied at the Grosvenor Hotel._____________________________________________________________________________________5.The following tables form part of a database held in a relational DBMS:- Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress)where Hotel contains hotel details and hotelNo is the primary key;Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms the primary key;andGuest contains guest details and guestNo is the primary key.Compose an SQL that creates a view containing the hotel name and the names of the guests staying at the hotel.