How to make an approximate database schema?

G

Good Samaritan2019-02-05 16:43:16

Database design

Good Samaritan, 2019-02-05 16:43:16

1) there are students, teachers and classes
2) each student is in a class
3) a teacher can teach in one or more classes
4) one or more teachers can teach in one class

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Vitaliy Orlov, 2019-02-05
@djamali

class
~~~~~~
id
name

teacher
~~~~~~~
id
name

teacher_class
~~~~~~~
class_id
teacher_id

pupil
~~~~~~
id
class_id
name