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