Open Ayushk4 opened 5 years ago
This sounds like a good idea!
While developing the DB, I was primarily concerned with the immediate requirements of the various apps and didn't find the motivation for storing the entire data. Giving it a second thought, we can create new tables for storing semester based information such as courses, associated faculty members, and grades etc. We can populate these tables on a semester basis rather than pre-fetching them at once. It would be wonderful if we could use the data from the current semester for the new tables so that data integrity is maintained.
Do you have any particular requirements/suggestions/use-cases to share?
As of now the list of courses is not exhaustive. From what it shows, it only has the data on the courses offered in the current semester.