Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

the case study is about the analysis of the students understanding in analyzing a given scenario and practical skills to apply concepts and build diagrams

the case study is about the analysis of the students understanding in analyzing a given scenario and practical skills to apply concepts and build diagrams studied in IT242 (Software Engineering). The case study consists of five parts. Students are required to answer all these parts based on the below scenario.

The SEU has adopted a blending approach to electronic learning, requiring learners to attend class lectures (25%), while 75% of course time is assigned to virtual classes, learning forums and follow-up of digital learning content.

"SEU Examinations System(SES),"automation of the examination activities of SEU that aims to bring in a centralized system that will ensure the operations in the context of an examination that can manage effectively. This system allows students to register the courses every semester themselves into the system by providing the details or by sharing details to admin at each branch. If the student is doing it by their own, then the system should check the login credentials and then the user can view all his registered courses for that semester along with the other arrear courses from previous semesters. The same is done by providing their student details and all the necessary information like Name, email, registered courses, semester, and so forth. The submitted details are then entered by admin into the SES system to enable the student to attend the examination and also creates a login id and password for them. After creating the login, the system mails the link of soft copy to every student who has registered successfully. Students containing the link in their mail can log in, and view the details of the courses and with the same login credentials they can log in into the system to modify or update their information like phone number, email-id, and so forth. Admin is also responsible for both publishings the grades and the generation of Grade sheets for every registered student after the exams completion. The course instructors are allowed to enter the marks into the system for the courses they teach in respective semesters. Once the teacher fixes the grades, then they have to approve it for admin verification. There will be a total of three to six semesters where each semester contains a maximum of seven subjects. Admin will verify the marks and grades of every student using the systems GUI or via Database entry and then finally the student grades will be published into their login separately. Students can also request for revaluation of their exam papers through this system. On receiving the revaluation request, the system sends the notification to the concerned instructor and the final grades will be displayed to the students. The system will support 250 concurrent users and can easily integrate with the learning management system (Blackboard) that the university is planning to purchase. Thus, on the whole, it serves as a completely automated software which handles every tedious and complicated process handled

during the examination times by covering for the most significant drawbacks of a manual system, namely speed, precision, and simplicity. A centralized system will ensure that the activities in the context of an examination can be managed effectively, while also making it more accessible and convenient for both students and staff.

Deliverables

The parts of this case study yield many outputs. These outputs will be the means of evaluation of each part of the case study. On or before the due date, the group leader (selected by the students group) must upload only one Word-format document to the Blackboard.

Based on the given scenario, answer the following parts.

Questions of this part analyze the students understanding in analyzing the given scenario and practical skills to build Class diagrams studied in chapters 8, 10 and 12of IT242.

The SES administration would desire to have a database system to keep track of students, instructors, courses, assessments, and grades. Read the following paragraph to answer the given questions.

The system maintains courses information. For each course, the system keeps a unique course code, name and credit hours. Each course offered in one to ten sections (CRNs). A section has a section ID, year, semester (i.e., semester 1, semester 2 or summer), time, room and seating capacity. One to three instructors teach each section, and an instructor can teach zero to five sections. The instructor details to be stored are instructor ID, name, password, email, contact number and address. The system also stores students information. Each student has a student ID, name, password, email, major, contact number and address. Students have to enroll to one to seven sections each semester. In each section, three to six assessments administrated to students including a mid-semester and a final exam. Assessments are the same for the sections of the same course. An assessment has an assessment ID, due date and maximum grade. For each assessment, a student is given a grade. Each grade has a grade ID and value. Each grade provided by one instructor only and belongs to one student only.

  1. image text in transcribed Identify the classes and their attributes from the given paragraph. (6 Marks)

Class

Attributes

  1. Draw a Class diagram for the given database. The picture must show all classes, relationships between classes, and multiplicities. (8 Marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Current Trends In Database Technology Edbt 2006 Edbt 2006 Workshops Phd Datax Iidb Iiha Icsnw Qlqp Pim Parma And Reactivity On The Web Munich Germany March 2006 Revised Selected Papers Lncs 4254

Authors: Torsten Grust ,Hagen Hopfner ,Arantza Illarramendi ,Stefan Jablonski ,Marco Mesiti ,Sascha Muller ,Paula-Lavinia Patranjan ,Kai-Uwe Sattler ,Myra Spiliopoulou ,Jef Wijsen

2006th Edition

3540467882, 978-3540467885

More Books

Students also viewed these Databases questions