week-7

Mis-581 (Milestone week-5)

Team 3:

High-Level Functional Requirements:

The new student portal will enable the institution to carry out the registration process very easily, and the students will be the one providing the institution all details needed, and the process will be very fast, and the financial system will show more transparency. The system will generate a student portal every time a student has been accepted and registered to the school. So the student, will be given a temporary credential, which can be customized by the student. The information provided in those portals will directly reflect in institution website and be recorded.

The instruction will also be able to have a clear and flowing report concerning the history of each of each student in Keller College. The institution will give the date when the students joined, and the day they left.

The online portal will enable the institution to provide the performance record of the student throughout the course, as well as a statistical progression about his grades, and the class average. All the results of each student will be uploaded in the system, and therefore the student performance can be shared easily when it is necessary (Ozkan, 2009).

Additionally, the online portal will enable the students to register for the courses they will undertake easily and thus making it easy for the professors to identify the courses they are teaching each student in the institution. The course registration will be done online after login into student portal, and it can be done by student himself, or by a school representative. The course online registration will enable the institution to process the student's results easily especially during the graduation.

Through online portal, student also can have a total view of the progression of their finance. Starting from their program estimation, registration fees, course fees; also they can have access to the financial aid website. At the same time they can consult the tuition payments, tuition balance, and overall their financial chart like the bank statement that a bank provide to its clients when they login into their online banking.

Context level data flow diagram of students’ online portal in Keller College

Description

The students and prospective students will visit Keller college website and create their own portal using a computer or mobile phone devices that connect to the internet. The portal will have different sections which the students will give the details of what they want. They will log in their details and provide the information needed to the system and obtain instant feedback.

Use Case Student Registration

STUDENT

ADMINSTRATOR

Figure 2 Diagram of the online portal registration of the Keller school

During the registration, the student will visit the website provided to them and registration as a new student of the institution. They provide the registration number when creating a username and create a strong password. The students will be using these details whenever they visit their portal.

Use Case Student Finance

When the students wish to consult their financial position, they will login to the system and then select the part of finance element they want to see. After that, the students can get in touch with a financial advisor to discuss about any financial issues. They will be able to apply directly their financial aid through the online portal by accessing to the financial aid website. A global chart of student finance will be available to students, so that will perform the transparency about their finance.

Conceptual, Logical and Physical Data Model

Conceptual, logical and physical model or ERD are three different ways of modeling data in a domain. While they all contain entities and relationships, they differ in the purposes they are created for and audiences they are meant to target. A general understanding to the three models is that, business analyst uses conceptual and logical model for modeling the data required and produced by system from a business angle, while database designer refines the early design to produce the physical model for presenting physical database structure ready for database construction.

Conceptual Model

Conceptual ERD models information gathered from business requirements. Entities and relationships modeled in such ERD are defined around the business's need. The need of satisfying the database design is not considered yet. Conceptual ERD is the simplest model among all.

Conceptual Data Flow Diagram for the New Keller Student System

COURSE OFFERING

Course ID

Year

Term

Session

Location

Days

Time Start

Control

Enrollment

Instructor SSN

COURSE

Course ID

Title

Description

Credit

FINANCIAL AID

Code FA

Year

Status

Type

INSTRUCTOR

SSN

LastName

FirstName

Address

Phone

Department

STUDENT

Student Id

Name

Address

Major

GPA

REGISTRATION

Course ID

Student ID

Grade

Logical Model

Logical ERD also models information gathered from business requirements. It is more complex than conceptual model in that column types are set. Note that the setting of column types is optional and if you do that, you should be doing that to aid business analysis. It has nothing to do with database creation yet.

Logical Data Flow Diagram for the New Keller Student System

FINANCIAL AID

PK Code FAInt (5)

Year Int (4)

Status Varchar

Type Varchar

REGISTRATION

FK Course IDInt (5)

FKStudent IDInt (5)

Grade Varchar (8)

COURSE

PK Course IDInt (5)

Title Varchar (8)

Description Varchar

Credit Int (2)

COURSE OFFERING

PK Course IDInt (5)

Year Int (4)

Term Varchar

Session Varchar

Location Varchar

Days Int

Time Start Date

Control Varchar

Enrollment Varchar

Instructor SSN Int

STUDENT

PKStudent IdInt (5)

NameVarchar (50)

AddressVarchar

MajorVarchar

GPA Int

INSTRUCTOR

PKSSN Int (5)

LastNameVarchar (20)

FirstName Varchar (30)

AddressVarchar (40)

Phone Int (10)

DepartmentVarchar (20)

Physical Model

Physical ERD represents the actual design blueprint of a relational database. It represents how data should be structured and related in a specific DBMS so it is important to consider the convention and restriction of the DBMS you use when you are designing a physical ERD. This means that an accurate use of data type is needed for entity columns and the use of reserved words has to be avoided in naming entities and columns. Besides, database designers may also add primary keys, foreign keys and constraints to the design.

Physical Data Flow Diagram for the New Keller Student System

FINANCIAL AID

PK Code FAInt (5)

Year Int (4)

Status Varchar

Type Varchar

REGISTRATION

FK Course IDInt (5)

FKStudent IDInt (5)

Grade Varchar (8)

COURSE

PK Course IDInt (5)

Title Varchar (8)

Description Varchar

Credit Int (2)

COURSE OFFERING

PK Course IDInt (5)

Year Int (4)

Term Varchar

Session Varchar

Location Varchar

Days Int

Time Start Date

Control Varchar

Enrollment Varchar

Instructor SSN Int

STUDENT

PKStudent IdInt (5)

NameVarchar (50)

AddressVarchar

MajorVarchar

GPA Int

INSTRUCTOR

PKSSN Int (5)

LastNameVarchar (20)

FirstName Varchar (30)

AddressVarchar (40)

Phone Int (10)

Department Varchar (20)

References

Grady, J. O. (2010). System requirements analysis. Academic Press.

Ozkan, S. &. (2009). Multi-dimensional students’ evaluation of e-learning systems in the higher

education context: An empirical investigation. Computers & Education, 53(4),1285-1296.

https://www.keller.edu/graduate-schools/new-york/midtown-manhattan-campus.html

Laplante, P. A. (2004). Real-Time Systems Design and Analysis. Hoboken, N.J.: Wiley-IEEE Press.