Hi,I'm after a little help with designing a student records databse from scratch - I'm reasonably familiar with Access but can't get my head around this design. I have multiple students who attend four different courses at our school (they can take each course more than once). During each course they sit multiple exams (and can take each each more than once). What I would like to do is have a database to store:- student records- course records- exam resultsSo this is the basic design that I am starting with:Student Table Student_ID (PK) Student_Name Student details....Course Table Course_ID (PK) Course_Type_ID (FK) Course_Number Course_Start_Date Course_End_DateExam Table Exam_ID (PK) Exam_Name Course_Type_ID (FK) Exam_Max_Marks Exam_Pass_MarksExam Results Table Result_ID (PK) Student_ID (FK) Exam_ID (FK) Result_MarkDoes this sound reasonable? Any thoughts on the design would be very much appreciated!Wally