View Single Post
  #1 (permalink)  
Old April 2nd, 2014, 10:58 PM
frdata frdata is offline
Authorized User
Points: 80, Level: 1
Points: 80, Level: 1 Points: 80, Level: 1 Points: 80, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 20
Thanks: 7
Thanked 0 Times in 0 Posts
Default Students,Courses, and Grades

Hello Rod,
I am trying to implement one of the models that you listed in Appendix B. I am using vb6 frontend and Access backend

For the moment, I have three questions based on figure B-16 page 478.

Q1 : Why is Instructors.InstructorID not connected to CourseOfferings.InstructorID. Isn't it a foreign key relationship

Q2 : Why don't you create a look up table for GradeItem

Q3 : StudentCourses has Grade field. StudentGrades has Score field. What is the difference between StudentCourses and StudentGrades

Thank you