A regional officer requires the design of a database system that can provide information on all private kindergartens in the region. The requirements collection and analysis phase of the database design process has provided the following data requirements for the Early Foundation School Information System (EFSIS). (a) Every school has many children and many teachers. Each child is assigned to one school and each teacher works for one school only. (b) Each teacher teaches more than one subject but a subject may be taught by more than one teacher. The database should store the number of hours a teacher spent teaching a subject. Data held on each teacher includes his/her identification card number (IC), name (first and last), gender, qualifications and experiences. The data held on each subject includes subject title, type, language, syllabus, and assigned teachers. (c) Each child can study more than one subject and a subject may be studied by more than one child. Data held on each child includes the student's ID, name (first and last), gender, date of birth, main parent's name and address. (d) Each school is managed by one of its teachers known as the principle. The database should keep track of the date he/she started managing the school. Data stored on each school includes the school's code, name, address (town, street, and post code), started date and contact number. You are supposed to create a database based on ALL necessary entities, relationships and constraints. You must then utilize the SQL (DDL and DML) to define and manipulate relevant data based on the above