MyERD

Tables (5)

Course

  • cid — Primary key — NOT NULL
  • tid — Foreign key → Lecture.tid — NOT NULL
  • cname
  • cprice

Lecture

  • tid — Foreign key → Teacher.tid — NOT NULL

Register

  • sid — Foreign key → Student.sid — NOT NULL
  • cid — Foreign key → Course.cid — NOT NULL
  • tid — Foreign key → Course.tid — NOT NULL

Student

  • sid — Primary key — NOT NULL
  • sname
  • sphonenumber

Teacher

  • tid — Primary key — NOT NULL
  • tname
  • tphonenumber