1. Create the Author table with the following fields: Number, First Name, Last Name and Date of Birth.

2. Fill the Author table with the following authors:

Number	First Name	Last Name	Date of Birth
1	Azizi	Ahmed	1976-05-06
2	Louizi	Rachid	1967-09-23
3	Mahfoudi	Hamid	1954-12-17

3. Create the Book table with the following fields: ISBN, Title, Date, Number of pages and Number of Author.

4. Fill the Book table with the following Books.

ISBN	Title	Date	Number of pages	Number of author
1	Microsoft Word	2004-02-06	234	3
2	Bureatique	2006-10-04	123	2
3	Microsoft Access	2005-09-03	432	3
4	Microsoft Excel	2007-07-07	323	1

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?