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.
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.
(
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
Last
Name
FirstName
Address
Phone
Department
)
Conceptual Data Flow Diagram for the New Keller Student System
(
STUDENT
Student Id
Name
Address
Major
GPA
)
(
REGISTRATION
Course ID
Student I
D
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.
(
FINANCIAL AID
PK
Code FA
Int (5)
Year
Int (4)
Status
Varchar
Type
Varchar
) (
REGISTRATION
FK
Course ID
Int (5)
FK
Student ID
Int (5)
Grade
Varchar
(
8
)
)
Logical Data Flow Diagram for the New Keller Student System
(
COURSE
PK
Course ID
Int (5)
Title
Varchar
(
8
)
Description
Varchar
Credit
Int (2)
) (
COURSE OFFERING
PK
Course ID
Int (5)
Year
Int (4)
Term
Varchar
Session
Varchar
Location
Varchar
Days
Int
Time Start
Date
Control
Varchar
Enrollment
Varchar
Instructor SSN
Int
)
(
STUDENT
PK
Student Id
Int (5)
Name
Varchar (50)
Address
Varchar
Major
Varchar
GPA
I
nt
)
(
INSTRUCTOR
PK
SSN
Int (5)
Last
Name
Varchar
(
20
)
FirstName
Varchar
(
30
)
Address
Varchar
(
40
)
Phone
Int (10)
Department
Varchar
(
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.
(
FINANCIAL AID
PK
Code FA
Int (5)
Year
Int (4)
Status
Varchar
Type
Varchar
) (
REGISTRATION
FK
Course ID
Int (5)
FK
Student ID
Int (5)
Grade
Varchar
(
8
)
)
Physical Data Flow Diagram for the New Keller Student System
(
COURSE
PK
Course ID
Int (5)
Title
Varchar
(
8
)
Description
Varchar
Credit
Int (2)
) (
COURSE OFFERING
PK
Course ID
Int (5)
Year
Int (4)
Term
Varchar
Session
Varchar
Location
Varchar
Days
Int
Time Start
Date
Control
Varchar
Enrollment
Varchar
Instructor SSN
Int
)
(
STUDENT
PK
Student Id
Int (5)
Name
Varchar (50)
Address
Varchar
Major
Varchar
GPA
I
nt
)
(
INSTRUCTOR
PK
SSN
Int (5)
Last
Name
Varchar
(
20
)
FirstName
Varchar
(
30
)
Address
Varchar
(
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.
Student FinanceRegistered Students Students courses feesStudent Financial tablePortal AccessFigure 3. Student Finance of student·s online portal in Keller CollegeFinancial Aid Application
Student Finance
Registered
Students
Students courses fees
Student Financial table
Portal Access
Portal Access
Portal Access
Figure 3. Student Finance of student’s online portal in Keller College
Financial Aid Application
Portal Access
Keller School Students��Information SystemsProspective StudentsKeller Admitted StudentsCourse Registration Students Financial Acess Keller Admitted StudentsKeller Technical TeamPortal AccessFigure 1. Context level data flow diagram of student¶s online portal in Keller College
Keller School Students’ Information Systems
Prospective Students
Keller Admitted Students
Course Registration
Students Financial Acess
Keller Admitted Students
Keller Technical Team
Portal Access
Portal Access
Portal Access
Portal Access
Portal Access
Portal Access
Figure 1. Context level data flow diagram of student’s online portal in Keller College
nrvamcni143
week-5_milestone.docx
