Marist College plans to develop a new ‘course registration system’ to better manage and streamline the online registration process for graduate students. based on the following requirements create a use case, sequence, class, er diagram and sql query for a registration report (check req# 9).
requirements:
1. the system will allow students to register as well as drop both online and ground classes.
2. the system will allow the graduate director to add/remove/edit courses offered during each semester and set maximum seats availability for each course.
3. the system will allow students to view the courses offered for their graduate program during selected semesters.
4. the system will also list the pre requirement courses if any associated with a particular course.
5. the system should not allow students to register for a course unless the pre-requirement courses have been completed. for example: a student should not be allowed to register for systems design unless s/he has completed its pre-req information analysis.
6. the system should not allow a student to register for more than 3 courses per semester.
7. in case of international students, the system should only allow registration for 1 online course per semester.
8. in case of inconsistencies and issues with registration, graduate director will have an authority to override.
9. graduate director would like to view a report showing a student’s class registration history by semester and year and the total credit remaining for his/her successful graduation. please provide a sql query to generate the registration report.
10. please recommend any other reports that your e-r diagram design can generate which may be beneficial for graduate director’s analysis purposes
Dear Sir,
I can develop this course registration system. I have 10+ years experience. I am very interested in this project. Please get back to me so that we can discuss further.
Best Regards
ePerfections
We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for projects and we understand what you want so we are confident that we can do it easily in mention time. We assure you that you will be completely satisfy with our work. And after delivering your project if you feel some issue in understanding the projects then we will teach you free until you understand.
If you have any question then feel free to ask. We are here for you.
Thank you
Demon Developer Team
hi,I am a certified microsoft ms sql database server developer.
i would be happy to use my ms access database design skills to assist.
please feel free to approach me for further assistance.
kind regards ,enrico
=====================================================