Every School has many teachers and many students. Each student is assigned to school and each teacher works for one school only. Each teacher teaches more 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. Information on each teacher includes his/her tax file number, name (first and last), gender and qualifications. The data held on each subject includes subject title and type. Each student can study more than one subject and a subject may be studied by more than one student. Data held on each student includes the student number, name (first and last), gender and date of birth. Each school is managed by one of its teachers. 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 postcode) and phone.

For the above scenario, you need to perform the following tasks:

  • Draw ERD with key attributes. You can use any notation to draw the ERD. Must include legend.
  • Data dictionary for the above scenario
  • Implement the database and populate with sample data for every table.
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.