Database Requirements

Entities

• Students

  • They are defined by a id and we also need to keep record of their name, birth date, phone number, address, avatar, university they attend and any media related to them.
  • Each student has an email address which he will use to login, and a password created upon registration.

• Instructors

  • They are also defined by a social security number and we are going to keep also basic information about them. An important attribute is "confirmed" that belongs to instructor. Since an instuctor has to go through examination of his/her skill, this attribute keeps the information if he has passed successfully it or not.
  • Each student has also an email address which he will use to login, and a password created upon registration.

• Courses

  • Courses are defined by a id, it has a description and name.

• Educational Institutions

  • An educational institution is defined by an international code. We also need to keep its name, location and any related media.

  • each institution offers a collection of different courses

*Requests * Requests are defined by id. We also need to keep information about the topic and the description of the request. Important attribute is status. A request will either be accepted, declined or still not processed.

• Reviews

  • After completing the request, the student will be asked to review the instructor so it is needed to keep record of the review. It will be in a form of rating.

Relations

• Independent

  • Each Student attends a number courses.

  • Each instructor is recognized by an educational institution on a specific course where his hourly payment is set.

• Sessions

  • They seize exist by the presense of a meeting between an instructor and a student that requests a lesson in a specific course.

  • We need to keep payment information, the resulotion and the time of occurance of both the payment and the meeting once completed.