Question

a) Investigate the SQL dialect on any DBMS that you are currently using.
Determine the system's compliance with the DML statements of the ISO
standard. Investigate the functionality of any extensions the DBMS supports.
Are there any functions not supported?
b) Show that a query using the HAVING clause has an equivalent formulation
without a HAVING clause.
I
Q2: Create the Room, Booking, and Guest tables using the features of SQL with
the following constraints:
a) Type must be one of Single, Double, or Family.
b) Price must be between £10 and £100.
c) Room No must be between 1 and 100.
d) Date From and date to must be greater than today's date.
e) The same room cannot be double-booked.​

Answer 1

Answer:

Chemistry, the science that deals with the properties, composition, and structure of substances (defined as elements and compounds), the transformations they undergo, and the energy that is released or absorbed during these processes.