So you really ask: PLEASE, MAKE THE COMPLETE DESING FOR ME Look, it isn't this hard; you just have to think about relationships: - you have *students* with Student_ID and other student related columns - vou have *teachers* with Teacher_ID and other teacher related columns - you have *courses* with Course_ID and other course related columns them are your BASE tables then you have a relation: which teacher can teach which courses - *TeachCourse* with Teacher_ID and Course_ID and other columns (i.e Weekday/Time) also, you have a relation: which student took what courses - *StudCourse* with Student_ID and Course_ID, no other columns (initially) needed Underlined columns are the primary keys for the tables Beware this is just the basic work - you have to refine it for multiple years and so on HTH
