Database Design and Implementation for the Student Information System
Business RulesThe chosen functionality within the Student Information System is delimited to the enrollment of students for a course. The following are the business rules that are put into assumptions:
- Every student is given a unique ID upon registration. They are only registered once but they can enroll in many courses that are offered within a semester.
- The university has a list of courses that are offered in every semester in every year. Some courses are offered and some are not.
- Each course that is offered is taught by a faculty member however a faculty member can teach many courses for a semester in a year.
- An offered course will finally go on if there are at least 1 enrolled student but of course, an offered course can accommodate many enrolled students.
- For every enrolled course of a student in a semester, they get a grade (GPA) which indicates whether they passed or not. If they do fail, then they can re-enroll again the course on the next incoming semester when it opens.
Importance of Data ModelWhen we do database design and implementation, we follow basic engineering steps. We do not dive right away into implementing and work on it as we go on. This is going to be costly in resources and time especially if it goes unplanned. There will be a lot of unexpected changes because of technicalities. It is recommended to the first start with a design in which we do the data model. In this phase, we study and analyze the data that is going to be captured, how they are going to be stored and retrieved efficiently and effectively. The data model would serve as a blueprint when implementing it in an actual database. We can think of this similar to building a house where engineers start designing and formulating an architectural blueprint then gives it to other engineers later on to implement and build a house after the model underwent scrutiny. In cases that the database has to be re-created, to be migrated, or to be re-designed then the model will play a huge role because it will save a lot of time.
Question 3: ERD