1. Create the Room table with the following fields: Number, Type (Simple, Double, Suite), Roof (between 1 and 10), Number of bed (between 1 and 4), Situation (Available, Occupied).

2. Fill in the Room table with the following authors:

Number	Type	Roof	Number of Bed	Situation
1	Simple	1	1	Available
2	Suite	1	4	Occupied
3	Simple	1	2	Available
4	Simple	1	2	Occupied
5	Simple	2	1	Occupied
6	Simple	2	2	Available
7	Double	2	1	Occupied
8	Suite	2	2	Available

3. Create the Client table with the following fields: ID, First Name, Last Name and Number of room.

4. Fill in the Client table with the following authors:

ID	First Name	Last Name	Number of Room
A567890	Malki	Aziz	2
B678544	Nafidi	Ahmed	2
AB785666	Larzak	Hind	5
BE45434	Alaoui	Najib	7

5. Perform the following queries:

a. List the names and dates of birth of the various authors?

b. Give the date of birth of the author Azizi?

c. Name the authors who start with A and M?

d. Name the authors who start with L or M?

e. Give the names of the books and their publication date sorted?

f. Name the most recent book?

g. Give the names of the books and the names of their authors?

h. Give the name of each author and the number of his books?

i. Name the author of the Microsoft word book?

j. Name the books that have more than 300 pages?

k. How many pages does our library have?