COURSE

1
StudentID
Address
PROJECT
Project
Major
InstSSN
Description
Assign
InstName
SECTION 2000
STUDENT 25000
INSTRUCTOR 500
Assign
Enroll
RoomWIth
TermOffered
YearOffered
Section
GradeReceived
Days/Time Offered
Sname
Advise
Offer
Assign
CanTeach
Fname
Lname
Course
Description
d
Select
COURSE 1000
ADVISOR
Hours
PARKING PERMIT
MajorAdvised
AdvisorID
AdvisorName
Use
Type
60
40
Cost
Permit
UNDERGRAD
GRADUATE
AuthorName
TEXT 2000
Degree
ISBN
Exam
SAT
Class
2

1. STUDENT(StudentID, Fname, Lname, MentorID)
2. ADVISOR(AdvisorID, AdvisorName, MajorAdvised)
3. COURSE(Course, Description, Hours)
4. PARKING_PERMIT(Permit, Type, Cost, InstSSN,
   Assign_Date)
5. TEXT(ISBN, AuthorName)
6. UNDERGRAD(SAT, Class, StudentID)
7. GRADUATE(Degree, Exam, StudentID)
8. INSTRUCTOR(InstSSN, InstName)
9. PROJECT(Project, Description)
10. SECTION(Course, Section, YearOffered, InstSSN)
11. STUDENT_MAJOR(StudentID, Major)
12. STUDENT_ADDRESS(StudentID, Address)
13. USE(Course, ISBN)
14. RoomWith(StudentID, RoomMateID)
15. Select(Course, ISBN, InstSSN)
16. Assign(StudentID, Project, InstSSN)
17. Enroll(StudentID, Course, Section,
    GradeReceived)
18. Advise(StudentID, AdvisorID)
19. CanTeach(InstSSN, Course)