Please answer these questions based on this information- this is a homework in a management information system course-

A kindergarten

Has students from age 2 yeas - 6 years

There are 5 classes , each class has a selected age group,each class has two teachers and two assistant teachers

We have 5 management staff

1-general manager

2-transport manager

3-teacher affairs manager

4-teacher affairs manager

5-principal

The kindergarten is located at newyork

It has 50 students

The entitys:

The students

The teachers

General management

Sub department management

Bus drivers

Assistant teacher

(You can makeup any missing information)

Transaction Requirements: Refer to Appendix A in your text book "Database Systems: A Practical Approach to Design, Implementation and Management", for a detailed example that you have to follow. Data Entry: List 2 insert transactions related to your view. Data update/deletion: List 3 delete/update transactions related to your view. Data Queries: List 10 retrieval transactions related to your view. 2 Transaction Requirements: Data Entry: Enter the details of new staff. Enter the details of a new customer. Data update/deletion: Updatedelete phone numbers for staff. Update/delete the details of a supplier. Update/delete the details of a branch. Data Queries: 1- list the details of branches. 2- list the name, position, and salary of staff at a given branch, ordered by staff_name. 3- Identify the company's salaries cost for all staffs. 4- list the number of customers who buy from the DD2 branch. 5- List the distinctive staff address. 6- List the number of milk supplies that deliver the product in jun. 7- Identify the total number of branches in the Nakheel district. 8- Identify the total number of staff in each position at the branches. 9-Identify the total number of Suppliers of each type. 10- list the details of suppliers