Smart Baby Nursery and Kindergarten has started its operation since 2 years ago. As the number of children in the nursery and kindergarten increases, their manually done management system is no longer sufficient to support their operation. Thus, they need a computerized database system, which will help them to store the following information: a. The personal particulars of every child, which include ID, name, birth certification number, age, parents contact information, health condition, entry date and any other relevant information. b. The personal particulars of the staffs, which include staff ID, name, IC number, contact information, date started working and any other relevant information. c. Each staff is assigned to take care of maximum 10 children in every year. d. The learning subjects offered are learning the Letters, Learning the Numbers, Drawing and Music. The system should be able to keep track of the childrens performance for each of the subject taken. e. Monthly fee is charged and amount paid, payment due (if any), due date and payment date must be recorded properly in the system. Your task is to carry out the following exercises.

Exercise Four

1. Create and save a query that would display all children by age, 4, 5 and 6 years old and their classes.

2. Create a query that will display the children from each class.

3. Create a query that will display the children details sorted from the oldest to youngest in age followed by their name.

4. Create a parameter query that will display all children details based on the children name entered.

5. Create a query to display the total number of subjects available.

6. Calculate the fees collected by childrens age and month.

7. Calculate the total outstanding by class and month.

8. Create a query to display the total payment for each children.

9. Create and save a parameter that will show the childrens performance records based on subject and by children.

10. Using SQL statement, increase the monthly fees by 10%.

11. Using SQL statement, write a query to display the outstanding fees for children whom has outstanding for two(2) months or more.