Hausaufgabe
Tables (6)
CONTACT
- StudentID — Foreign key → STUDENT.StudentID — NOT NULL
- Email
- Phone
- Name
REGISTER (Register)
- StudentID — Foreign key → STUDENT.StudentID — NOT NULL
- SectionID — Foreign key → SECTION.SectionID — NOT NULL
- Grade
- Teacher
- RegistrationDate
Require
- SectionID — Foreign key → SECTION.SectionID — NOT NULL
- ISBN — Foreign key → TEXTBOOK.ISBN — NOT NULL
- SalesVolume
SECTION (Section)
- SectionID — Primary key — NOT NULL
- CourseName
- RoomNumber
- Semester
- Department
STUDENT (Student)
- StudentID — Primary key — NOT NULL
- Major
- GPA
- YEAR
TEXTBOOK (Textbook)
- ISBN — Primary key — NOT NULL
- Title
- Publisher
- Writer
- Price