Creating School database scheme

Question

Main attributes needed to creating scheme

Answer 1

It would help if you described how you'd use your database.

If this was used for an online school anything like sololearn, you'd at least want tables for:
- courses
- students

For each course, you'd want 1 or more:
- course_pages or tutorial_pages
- course_quizzes

Relating students with the answers or grades they get on the quizzes, you'd want:
- student_quiz_answers

Since students sign in to take the quizzes, you'd want some credentials for each student such as username and password.

A lot more detail on requirements and how you use it would be needed before all tables, columns, constraints... can be found but that's a start to your database design.