assignnmnet4
Tables (7)
Contact (Untitled2)
- StudentID — Foreign key → STUDENT.StudentID — NOT NULL
- Field (Name)
- Phone
- Email
REGISTER (Untitled3)
- StudentID — Foreign key → STUDENT.StudentID — NOT NULL
- SectionID — Foreign key → Section.SectionID — NOT NULL
- Grade
- Teacher
- RegistrationDate
REQUIRE (Untitled7)
- SectionID — Foreign key → Section.SectionID — NOT NULL
- ISBN — Foreign key → TEXTBOOK.ISBN — NOT NULL
- SalesVo;ume (SalesVolume)
STUDENT (Untitled)
- StudentID — Primary key — NOT NULL
- Year
- Major
- GPA
Section (Untitled4)
- SectionID — Primary key — NOT NULL
- RoomNumber
- CourseName
- Semester
- Department
TEXTBOOK (Untitled5)
- ISBN — Primary key — NOT NULL
- Publisher
- Title
- Price
Writer (Untitled6)
- ISBN — Foreign key → TEXTBOOK.ISBN — NOT NULL
- Writer