Final Project: Information Management & Strategic Decision Taking

This project analyzes the National University Information Management System (NUIMS), aiming to improve its efficiency and address its current limitations. The assignment follows the System Development Life Cycle (SDLC), emphasizing system analysis and design. It includes an Entity Relationship Diagram (ERD) to model the system's entities, attributes, and relationships, such as students, lecturers, courses, and attendance. The project also defines business rules and assumptions, alongside a detailed data dictionary outlining entity attributes, data types, and primary/foreign keys. The student has incorporated relevant academic references, demonstrating an understanding of information management principles and database design. The project provides a comprehensive overview of system analysis and design in an academic setting.

704 - Information Management &
Strategic Decision Taking
Final Assignment
Title of the Final Assignment
Lecturer:
Student ID:
Student Name:
Submission Date:
1
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

Declaration:
I certify that this assignment is my own work, based on my personal study and/or
research, and that I have acknowledged all material and sources used in the
preparation of this assignment whether they be books, articles, reports, lecture
notes, any other kind of document, electronic or personal communication.
I also certify that the assignment has not previously been submitted for assessment
in any other course or at any other time in this Course, unless by negotiation and
that I have not copied in part or whole or otherwise plagiarized the work of other
students and/or persons. I have read the Maximus policy on plagiarism and
understand its implications.
2
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

Table of Contents:
Introduction...........................................................................................................................................3
Case study.............................................................................................................................................3
ENTITIES AND ATTRIBUTES BASE ON THE CASE.....................................................................................4
ENTITY RELATIONSHIP DIAGRAM (ERD).................................................................................................7
Business Rules / Assumption...............................................................................................................11
Data Dictionary....................................................................................................................................12
References:.........................................................................................................................................13
3
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

Introduction
System Development Life Cycle SDLC is an approach that works systematically to develop a quality
software which meets each and every requirement of a business or individual organization. System
analysis is an integral part of SDLC, which focuses on data collection, problem identification,
evaluating business processes and attempt to develop a feasible solution to importer the
functionalities of the system. At the end of the system analysis phase is a logical system that
provides picture of the enhanced system than the existing one. The system design phase utilizes the
operational data and requirement gathered during system analysis to develop logical model of the
proposed system. This model includes diagrams which represents the relationships among the
system objects and processes and the logical flow of data. In this report we would utilize entity
relationship diagram ERD to show the scope of the system that would be developed based on the
case study below.
Case study
National University Information Management System (NUIMS)
National University has seen significant growth since its foundation in the year 1995 from 200
students till date to 50000 students and more than 600 members in staff. The existing system used
by the University has many flaws and is inefficient in terms of managing the rapid growth of students
and also incompatible with the latest technologies (for example the system cannot be accessed from
any other area than the university head office). Thus the management requires a whole new
information system capable of handling the management and other task efficiently for the admin as
well as staff members. The main aim of the system would be to simplify management of student's
information. The system would be used by not only the admins and staff but also by the students
and tutors equally. The system should be able to track all the details of the student including their
personal details, academic performance, course and subject details as well as student and teachers
schedule and attendance. The system uses authentication to let the authorized user access the
system according to their privileges and level.
4
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

ENTITIES AND ATTRIBUTES BASE ON THE CASE
Entities and Their Attributes Based On the Above Case Study
Name of the
entity
Name of the
attribute
Definition Data type
Student SID (for
registration
number)
This would be a unique
identifier or Super key for
each student
Varchar
Name A composite attribute that has
first and last name, title,
surname of the student
Text
Address Again a composite attribute
that has street, city/town,
postal code and post office
number.
Varchar
Phone number Student’s mobile number or
mobile number.
Varchar
Email address Valid email address of the
student
Varchar
Year of study Current year in which student
is studying
Integer
Id number Student’s identity number on
card
Integer
Lecturer/ Name A composite attribute that has Text
5
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

instructor first and last name, title,
surname of the Lecturer
Instructor id A unique number to identify
each lecturer.
Varchar
Address Again a composite attribute
that has street, city/town,
postal code and post office
number
Varchar
Email address Validmail address of Lecturer Varchar
Courses taught Name of the courses that each
teacher teaches
Varchar
Course Course name Name of the course Varchar
Course code A unique identifier for each
course
Varchar
Description Brief definition of the course Varchar
Class Class ID A Unique number to identify
the class.
Varchar
Course code Identifies the course for that
particular class.
text
Semester Details of semester Integer
Year Year of class Integer
6
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

Student
Attendance
SID Identifier for Student Varchar
Class id Unique identifier for class Integer
Date of
Attendance
Date of Class for which
attendance is taken
Date
Status Present/absent Char
7
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

Relationship , Cardinality and participation
1) Based on the case study that any student can enroll for one or many course
(mandatory) but for Course it can be possible that zero or many students has enrolled.
Hence the relationship between student and course is shown below:
2) Similarly if we look for teacher and course relationship, then one teacher can teach
many courses but one course is taught by one teacher only.
3) One Course can have many classes but one class belongs to one course.
4) Attendance for each class is captured, one class can have many students and one
attendance belongs to only one student.
8
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

ENTITY RELATIONSHIP DIAGRAM (ERD)
9
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

Business Rules / Assumption
1. It is the role of system administrator to create an account for the student. Only after
providing access to the student, he/she can access the system.
2. The student can register for one course at a time.
3. The student should clear all their payments before enrolling into another course for the
trimester.
4. The account for all the users can only be created and deleted by the administrator.
5. As soon as the student finishes his course and offerings for the year his/her account gets
deleted.
6. As soon as the contract of the lecturer with the college expires his/her account gets deleted.
7. The student can view their course material, announcements and results on the system.
He/she does not have any rights to edit them.
8. The date of enrolment must be in the form of DD/MM/YYYY.
9. Only one lecturer should be assigned for one course.
10. Payment should be done at once.
11. The student should get enrolled for at least one course.
12. The student as well as the lecturers should have only one address, however they can have
more than one contact number
13. All the Identification number and registration number for each and every entry should be
unique
10
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

Data Dictionary
Entity Attributes Size Data type Primary Key Foreign Key
Student SID 10 Integer Yes
Name 50 Varchar
Address 100 Varchar
Phone number 14 Varchar
Email address 50 Varchar
Program 20 Varchar
Lecturer/instructor Name 50 Varchar
instructor id Integer Yes
Address 100 Varchar
Email address 50 Varchar
skill 20 Varchar
Course Course name 20 Varchar
Course code 20 Varchar
Description 100 Varchar
Class Class ID Integer Yes
Course code 20 Varchar Yes
Semester Integer
Year Integer
11
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

Student
Attendance
Student ID Integer Yes Yes
Class id Integer Yes Yes
Date of
Attendance
Date
Status 1 Char
References:
International business machines (IBM) issued patent titled "determining entity relationship
when entities contain other entities". (2018, Dec 06). News Bites - Computing &
Information Retrieved from https://search.proquest.com/docview/2149952101?
accountid=30552
Jones, T. H., & Il-Yeol Song. (2000). Binary equivalents of ternary relationships in entity-
relationship modeling: A logical decomposition approach. Journal of Database
Management, 11(2), 12-19. doi:http://dx.doi.org/10.4018/jdm.2000040102
Barringer, P. (2011). Oversight of delegated entity relationships: Regulatory framework &
practical strategies. Journal of Health Care Compliance, 13(1), 5-12. Retrieved from
https://search.proquest.com/docview/845441908?accountid=30552
12
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019

13
704 - Information Management & Strategic Decision Taking| Sample Assignment 2019