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

+2

Creating School database scheme

Main attributes needed to creating scheme

11/5/2018 8:50:21 PM

^_^

1 Answer

New Answer

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.