College Management System Database
I'm creating one software for College Management System. In which I'm stuck over in Academic Routine(Time Table) creation module. For time table creation module we need three tables, namely SUBJECT{Subject_id, Subject_name, Department_ID,Year}, DEPARTMENT{Department_ID, Department_name,HOD}, FACULTY{Fac_ID, Last_Name, First_Name, Middle_Name, Department_ID, Subject_ID}.
Now the problem is multiple departments can have the same subject, for example, in Mechanical 1st Year, and also in Computer Science and engineering 1st year we have subject Data Structure and Algorithm with same subject code. Also multiple teachers can teach a single subject. So I'm unable to understand how to perform the data integration and how to insert data into it.
Please help.