System Analysis and Design Report for ICT40115 Certificate IV IT

This report presents a system analysis and design solution, including a noun/verb analysis, an entity-relationship matrix, data dictionaries for entities (Course, Prereq, Section, Room, Student, Transcript), an ER diagram with normalization, a context diagram, level data flow diagrams (0 and 1), and a CRUD matrix. The analysis focuses on a course section registration system (CSRS) and a human resources (HR) system, detailing the relationships between entities, data flow, and process interactions. The report concludes with a bibliography referencing relevant academic sources.

Running head: SYSTEM ANALYSIS AND DESIGN
SYSTEM ANALYSIS AND DESIGN
Name of the Student
Name of the University
Author Note

1SYSTEM ANALYSIS AND DESIGN
Noun/Verb Analysis
Nouns are highlighted in yellow
Verbs are highlighted in green
The student enters course and requests for a section. The system then verifies the prerequisite
of the student. The prerequisite of the student is verified by “referring the student’s on-line
transcript of classes completed and grades received.”. Then the next measure by the system is
to verify the availability of room in the section. If room is available, then the student is added
to the waitlist and the student is sent an enrolment notification.
In the second scenario, if the prerequisite of the student is not clear then a not enrolled
notification is sent to the student. In the third scenario, if the student prerequisite is valid and
the room is not available then also a not enrolled notification is sent to the student.
Entity Relationship Matrix
Student Course Section transcript Room
Student x  request verify available
Course x prerequisite   done in
Section  belongs to x verify x
transcript  belongs to own x x
Room belongs to x x x x
Table 1: Entity Relationship Matrix
(Source: Created by Author)

2SYSTEM ANALYSIS AND DESIGN
Task 3:
DATA DICTIONARY
FOR ENTITIES
ENTITY COURSE
:
Attibute
Data
Type
N
ull
Defaul
t Constraint/Criteria/Options/Comments
CID int(8) No
999999
99
CONSTRAINT COURSE CHECK
(COURSE > 9999999), Primary Key
Title
varchar(
50) No INDEXED UNIQUE
ENTITY PREREQ
:
Attribute
Data
Type
N
ull
Defaul
t Constraint/Criteria/Options/Comments
PID int(8) No
999999
99
CONSTRAINT PREREQ CHECK (PID>99999999),
Primary Key
CID int(8) No
999999
99 Foreign Key (CID) refernces COURSE (CID)
ENTITY
SECTION :
Attribute
Data
Type
N
ull
Defaul
t Constraint/Criteria/Options/Comments
sec_ID int(4) No 999
CONSTRAINT SECTION CHECK (sec_ID>999),
Primary Key
CID int(8) No
999999
99 Foreign Key (CID) refernces COURSE (CID)
Faculty
varchar(
30) No INDEXED
R_id int(4) No 999
CONSTRAINT ROOM CHECK (RID>999), Foreign
Key
ENTITY ROOM :
Attribute
Data
Type
N
ull
Defaul
t Constraint/Criteria/Options/Comments
R_id int(4) No 9999
CONSTRAINT ROOM CHECK (RID>999), Primary
Key
available_seat int(2) No 99 CONSTRAINT SECTION CHECK (sec_ID>15)
available_room bit No BOOLEAN
ENTITY
STUDENT :
Attribute
Data
Type
N
ull
Defaul
t Constraint/Criteria/Options/Comments
SID int(4) No 999
CONSTRAINT SECTION CHECK (SID>999),
Primary Key
s_name
varchar(
30) No Composite Key

3SYSTEM ANALYSIS AND DESIGN
F_name
varchar(
30) No
L_name
varchar(
30) No
Std_address Composite Key
street
varchar(
30) No
state
varchar(
30) No
Zipcode int(6) No 999999
ENTITY
TRANSCRIPT :
Attribute
Data
Type
N
ull
Defaul
t Constraint/Criteria/Options/Comments
TID int(10) No
999999
9999
CONSTRAINT TRANSCRIPTION CHECK
(TID>9999999999), Primary Key
T_Name
varchar(
30) No
T_content
varchar(
30) No
T_type
varchar(
30) No

4SYSTEM ANALYSIS AND DESIGN
Figure 1: ERD diagram of CSRS
(Source: Created by Author using MS Visio)

5SYSTEM ANALYSIS AND DESIGN
Task 4: ER Diagram and Normalization:
Figure 3: ER DIAGRAM HR SYSTEM
(Source: Created by Author using MS Visio)

6SYSTEM ANALYSIS AND DESIGN
2NF table structure of HR System:
Sales Staff
Staff_id f_name l_name email
phone_n
o salary
Staff_ofc_i
d Cus_id
Staff office
Staff_ofc_i
d Location_id
Country_i
d
Region_i
d Office_id
Region
Region_id
Region_nam
e
Countries
Country_i
d
Country_nam
e Region_id
Location
Location_i
d
Street_addre
ss
Postal_co
de City
Country_i
d
Customer
Cus_id Customer 1 Customer 2 Customer 3
Staff_i
d

7SYSTEM ANALYSIS AND DESIGN
Task B
Figure 3: CONTEXT DIAGRAM
(Source: Created by Author using MS Visio)

8SYSTEM ANALYSIS AND DESIGN
Figure 4: LEVEL DATA FLOW DIAGRAM
(Source: Created by Author using MS Visio)
Figure 5: LEVEL 1 DATA FLOW DIAGRAM
(Source: Created by Author using MS Visio)

9SYSTEM ANALYSIS AND DESIGN
CRUD MATRIX
Processes Course Section Enrolment Transcrip
t
Student Waitlist
Verify Prerequisite
Room availability
Enrol
Notification
Registration Request
Add waitlist
Table 2: CRUD Matrix
(Source: Created by Author)

10SYSTEM ANALYSIS AND DESIGN
Bibliography
Btoush, E.S. and Hammad, M.M., 2015. Generating ER diagrams from requirement
specifications based on natural language processing. International Journal of Database
Theory and Application, 8(2), pp.61-70.
Greenyer, J., Brenner, C. and La Manna, V.P., 2013. The ScenarioTools play-out of modal
sequence diagram specifications with environment assumptions. Electronic Communications
of the EASST, 58.
Xu, Y., Mou, L., Li, G., Chen, Y., Peng, H. and Jin, Z., 2015. Classifying relations via long
short term memory networks along shortest dependency paths. In Proceedings of the 2015
Conference on Empirical Methods in Natural Language Processing (pp. 1785-1794).