Department (deptId, dept_name, head_id, dept_exe_id) ----> deptId is primary key
AcademicYear (deptId, year) -----> deptIds references from Department and (deptId, year) composite primary key
Semester (deptId, year, sem) ------> deptId, year is references from AcademicYear and (deptId, year, sem) composite primary key
Division (deptId, year, sem, div, batch) -------> deptId, year, sem is references from semester and (deptId, year, sem, div, batch) composite primary key.
Regards,
Manish Yadav
--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/8681de2d-977e-4817-be8d-2d1e865e93a6o%40googlegroups.com.