+ 2

Creating School database scheme

Main attributes needed to creating scheme

5th Nov 2018, 8:50 PM
^_^
^_^ - avatar
1 Odpowiedź
0
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.
14th Mar 2021, 3:32 AM
Josh Greig
Josh Greig - avatar