Question 1 You have been hired as a consultant by UMUC to help with their studen

Question

Question 1

You have been hired as a consultant by UMUC to help with their student information system. I would like you to login to my.umuc.edu and choose one of the functionalities (enrollment/registration, payment, etc) of your choice, then write a simple business document not exceeding ONE page. This document is called the functional requirements or business requirements which will be given to the technical staff/consultants who will translate the requirements into data model and create tables in the database using SQL. Please try to make it simple and just cover essential features.

Question 2

Based upon the functional document created in #1, describe the importance of relational data model or entity relationship model.

Question 3

Create an ERD using ER Assistant or Oracle Data Modeler for the chosen functionality in #1. This is just a beginning chapter and we will cover more database design and ERD in later chapters, so just try and don't be afraid if the diagram is not perfect.

Explanation / Answer

ans...

Student information system (SIS), student management system, school administration software or student administration system is a management information system for education establishments to manage student data. Student Information Systems (often abbreviated as SIS) provide capabilities for registering students in courses, documenting grading, transcripts, results of student tests and other assessment scores, building student schedules, tracking student attendance, and managing many other student-related data needs in a school. A SIS should not be confused with a learning management system or virtual learning environment, where course materials, assignments and assessment tests can be published electronically.

Maintenance and reporting of studentdata

Handling in quiries from prospective students

Handling the admissions process

Enrolling new students and enabling online scheduling

Student accounts and financia laid processing

Automatically creating class and teacher schedules

Handling records of examinations,assessments,marks,grades and academic progression

Maintaining records of absences and attendance

Recording communications with students

Maintaining discipline records

Providing statistical reports

Capabilities to operatemultiple campuses,onlineandon-ground,in multiplecountries and languages

Housing, dorms and facilities details, assignments and tasks

Communicating student details to parents or other persons authOrized by the student,through a portal

Special Education/Individual Education Plan(IEP) services

Career services management for student portfolio sandmatching with potential employers

Human resources services

Accounting and budgeting services·

Student heallh records

Canteen Management

Transportation Management

Fees Management

Inventory and Assets of the school

Pay roll processing for the Staff in the school

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.