Creating School database scheme | Sololearn: Learn to code for FREE!


Creating School database scheme

Main attributes needed to creating scheme

11/5/2018 8:50:21 PM


1 Answer

New Answer


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.