(Solved) : Every School Many Teachers Many Students Student Assigned One School Teacher Works One Sch Q26267941 . . . .

Every School has many teachers and many students. Each studentis assigned to one school and each teacher works for one schoolonly. Each teacher teaches more than one subject but a subject maybe taught by more than one teacher. The database should store thenumber of hours a teacher spent teaching a subject. Informationheld on each teacher includes his/her tax file number, name (firstand last), gender and qualifications. The data held on each subjectincludes subject title and type. Each student can study more thanone subject and a subject may be studied by more than one student.Data held on each student includes the