As the head of information systems for a college you are tasked with developing a new student registration system. The college would like a new client-server system to replace its much older system developed around mainframe technology. The new system will allow students to register for courses and view report cards from personal computers attached to the campus LAN. Professors will be able to access the system to sign up to teach courses as well as record grades. Due to a decrease in federal funding, the college cannot afford to replace the entire system at once. The college will keep the existing course catalog database where all course information is maintained. This database is an Ingres relational database running on a DEC VAX. Fortunately, the college has invested in an open SQL interface that system must ensure that access to the data on the legacy system occurs in a timely manner. The new system will maintain course information through another system. At the beginning of each semester, students may request a course catalogue containing a list of course offerings for the semester. Information about each course, such as professor, department, and prerequisites, will be included to help students make informed decisions. The new system will allow students to select four course offerings for the coming semester. In addition, each student will indicate two alternative choices in case the student cannot be assigned to a primary selection. Course offerings will have a maximum of ten students and a minimum of three students. A course offering with fewer than three students will be canceled. For each semester, there is a period of time that students can change their schedule. Students must be able to access the system during this time to add or drop courses. Once the registration process is completed for a student, the registration system sends information to the billing system so the student can be billed for the semester. If a course fills up during the actual registration process, the student must be notified of the change before submitting the schedule for processing At the end of the semester, the student will be able to access the system to view an electronic report card. Since student grades are sensitive information, the system must employ extra security measures to prevent unauthorized access. Professors must be able to access the on-line system to indicate which courses they will be teaching. They will also need to see which students signed up for their course offerings. In addition, the professors will be able to record the grades for the students in each class. Question i. Read the scenario carefully and select a model which is appropriate to build the application for the scenario. Justify your answer. Also, analysis the model for the given scenario. ii. After analysis the model show the graphical representation such as UML, Use case diagram for the above scenario.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

As the head of information systems for a college you are tasked with developing a new student registration system.
The college would like a new client-server system to replace its much older system developed around mainframe
technology. The new system will allow students to register for courses and view report cards from personal
computers attached to the campus LAN. Professors will be able to access the system to sign up to teach courses as
well as record grades.
Due to a decrease in federal funding, the college cannot afford to replace the entire system at once. The college will
keep the existing course catalog database where all course information is maintained. This database is an Ingres
relational database running on a DEC VAX. Fortunately, the college has invested in an open SQL interface that
system must ensure that access to the data on the legacy system occurs in a timely manner. The new system will
maintain course information through another system.
At the beginning of each semester, students may request a course catalogue containing a list of course offerings for
the semester. Information about each course, such as professor, department, and prerequisites, will be included to
help students make informed decisions.
The new system will allow students to select four course offerings for the coming semester. In addition, each student
will indicate two alternative choices in case the student cannot be assigned to a primary selection. Course offerings
will have a maximum of ten students and a minimum of three students. A course offering with fewer than three
students will be canceled. For each semester, there is a period of time that students can change their schedule.
Students must be able to access the system during this time to add or drop courses. Once the registration process is
completed for a student, the registration system sends information to the billing system so the student can be billed
for the semester. If a course fills up during the actual registration process, the student must be notified of the change
before submitting the schedule for processing
At the end of the semester, the student will be able to access the system to view an electronic report card. Since
student grades are sensitive information, the system must employ extra security measures to prevent unauthorized
access.
Professors must be able to access the on-line system to indicate which courses they will be teaching. They will also
need to see which students signed up for their course offerings. In addition, the professors will be able to record the
grades for the students in each class.

Question

i.
Read the scenario carefully and select a model which is appropriate to build the application for the
scenario. Justify your answer. Also, analysis the model for the given scenario.

ii.
After analysis the model show the graphical representation such as UML, Use case diagram for the
above scenario.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Knowledge Booster
Cloud Computing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education