• Each course having one or more named course tutors
• Some programmes having three stages over 3 academic years
• Some programmes having 8 courses per year instead of 4
• Some students being part-time
• Some programmes and courses having different details (eg different coordinators) in different academic years.
A revised database ERD would help for explaining the changes. You are not required to implement any of these changes in your ASP.NET site.