+1 (315) 557-6473 
Masters in computer science
1260 Order Completed
97 % Response Time
78 Reviews
Since 2012
Related Blogs

What do You Need to Know Before Seeking Help with HTML Homework Solution?Scholars often find themselves in a situation where seeking help with an HTML homework solution is not an option. Whether you get all the help you need or not, there are some of the important keynotes every student needs to kno...

2020-08-24
Read More

Computer Programming Homework Help; Why We Are the Best?Programming Homework Help is an established homework help providing agency, ready to help any student, irrespective of their geographical location or level of study, with their computer science homework help services. We have vast experience in...

2020-08-24
Read More

Where to Find the Best Assembly Programming Project Help in the UKAssembly programming has been a challenge for many students and so are homework and projects that require knowledge of assembly programming. The highly technical nature of assembly languages makes them the most feared languages in pro...

2020-08-24
Read More

Masters in computer science

Princeton, New Jersey

Christopher Hemmingway.

Masters in computer science, Princeton University, Princeton

Profession

Computer Science Expert (Haskell, Prolog )

Skills

A software engineer from Sweden with 7+ years’ experience providing help with various hardware and software projects. I am in love with writing code since I discovered that I have a passion for developing Software. I have a passion for developing apps for desktop and mobile platforms. I also love helping students with challenging homework on Haskell and Prolog. Programmiinghomeworkhep.com has provided me with a platform where I could help students with their homework, and I have been with them for the past two years. I think this was the best move in my life. I give you my word of honor that I always ensure you avail of the best client benefits from us during the meticulous product development process.

Get Free Quote
0 Files Selected

Database Design and Implementation for the Student Information System

Business Rules

The 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:

  1. 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.
  2. The university has a list of courses that are offered every semester in every year. Some courses are offered and some are not.
  3. 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. 
  4. 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.
  5. 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.

The Student Information System is big but this project only covers the enrollment of the student. It does not cover other details such as student payments, details of faculty information, detailed courses and prerequisites, teaching assistants, and so on. There might also be other missing attributes that have not been included but the above business rules and functionality would suffice to cover the minimum requirements of the information system.

Importance of Data Model

When 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.