SOKOINE UNIVESITY OF AGRICULTURE
FACULTY OF SCIENCE DEGREE PROGRAMMES: BSc. EDUCATION (INFORMATICS & MATHEMATICS) COURSE NAME: SYSTEM DESIGN AND ANALYSIS COURSE CODE: INF 300
S/NO NAME
REG NO.
1
MTANGA GREATER BEN
EIM/D/2014/0053
2
MBILINYI JOSHUA JONAS
EIM/D/2014/0040
3
AMAN REVOCATUS
EIM/D/2014/0007
4
MNENWA STANFORD
EIM/D/2014/0072
5
FANTA IBRAHIM
E1M/D/2013/0087
INSTRUCTOR: PROF. SANGA
SIGNATURE
DATA DICTIONARY DATA FLOW Name:
Appeal Payment
Description:
Contains Appellant information used to make appeal request and in general appeal process.
Source :
Appellant External Entity
Destination:
Process 1, Collect Appeal Fee
Type:
Screen
Data Structure :
Appellant Information
Comments:
Appellant information contains registration number, Appellant name and degree program.
STRUCTURAL RECORD Appeal Payment = Appellant Regno + Appellant name + Degree program +Course code Appellant Name = First name + Last name + (middle name) Appellant Reg No = program + [direct or equivalent] + year + Enrollment No
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
Regno
varchar
20
First name
varchar
20
Middle Name
varchar
20
Last name
varchar
20
Degree program
varchar
100
DATA FLOW Name:
Payment Receipt
Description:
Contains Payment information of a particular appellant.
Source :
bank External Entity
Destination:
Process 1, Collect Appeal Fee
Type:
Screen
Data Structure :
Bank Information
Comments:
Bank information contains Branch name and invoice number amount paid and date of payment.
STRUCTURAL RECORD Payment Receipt= Branch name +invoice number+ Address Address = City + Street
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
Branch name
varchar
20
invoice number
varchar
20
Street
varchar
20
City
varchar
20
DATA FLOW Name:
Examination Officer Views
Description:
Contains information of the examination officer involved in viewing the appellant request.
Source :
Examination Officer External Entity
Destination:
Process 2, Submitting Appeal
Type:
Screen
Data Structure :
Officer Information
Comments:
Officer information contains ID, Officer name and Office number.
STRUCTURAL RECORD Examination officer views = ID +Name+ Office Number Name = First name + (middle name) + (Last name)
DETERMINING ELEMENT LENGTH ELEMENT
DATATYOE
LENGTH
ID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
Office number
integer
5
DATA FLOW Name:
Senate Decision
Description:
Contains decisions made to each appellant.
Source :
Senate External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Senate Information
Comments:
Appeal information contains senate name and senate date.
STRUCTURAL RECORD Senate Decision= Senate name + Senate date Senate date = Day + Month + Year
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
Senate name
varchar
20
Day
integer
2
Month
varchar
10
Year
integer
4
DATA FLOW Name:
Academic advisor views
Description:
Contains information of the academic advisor involved in viewing the appellant request.
Source :
Academic advisor External Entity
Destination:
Process 3, Appeal processing
Type:
Screen
Data Structure :
Officer Information
Comments:
academic advisor information contains ID, Officer name and Office number.
STRUCTURAL RECORD Academic advisor views = ID + Name + Department Name Academic advisor Name = First Name + (middle name) + Last Name
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
ID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
Department name
varchar
50
DATA FLOW Name:
Head of Department comments
Description:
Contains information of the head of a particular department involved in viewing the appellant request.
Source :
E Officer External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Officer Information
Comments:
Officer information contains ID, Officer name, name of department and Office number.
STRUCTURAL RECORD Head of department comments = HID + Name + Phone Number + Office Number Head of department Name = First Name + (middle _name) + Last Name Phone Number = Country code + Personal Number
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
HID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
Country code
varchar
4
Personal number
integer
10
Office number
integer
5
DATA FLOW Name:
Resident medical officer Views
Description:
Contains information of the head of a particular department involved in viewing the appellant request.
Source :
E Officer External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Officer Information
Comments:
Officer information contains ID, Officer name, name of department and Office number.
STRUCTURAL RECORD Resident Medical Officer Views = RID + Name Name = First Name + (Middle Name) + Last Name DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
RID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
DATA FLOW Name:
Head of Department Views
Description:
Contains information of the head of a particular department involved in viewing the appellant request.
Source :
E Officer External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Officer Information
Comments:
Officer Information contains ID, Officer name, name of department and Office number.
STRUCTURAL RECORD Dean_ of_Facult Views = DID + Name + Office Number Name = First Name + (Middle Name) + Last Name
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
DID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
Office number
integer
5
DATA FLOW Name:
Head of Department Views
Description:
Contains information of the head of a particular department involved in viewing the appellant request.
Source :
Head of Department External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Officer Information
Comments:
Officer Information contains ID, Officer name, name of department and Office number.
STRUCTURAL RECORD
Head of department Views = HID + Name + Phone Number + Office Number Head of department Name = First Name + (middle _name) + Last Name Phone Number = Country code + Personal Number
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
HID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
Country code
varchar
4
Personal number
integer
10
Office number
integer
5
DATA FLOW Name:
Resident Medical Officer Views
Description:
Contains information of treatment of the appelant.
Source :
Resident Medical Officer External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Officer Information
Comments:
Officer information contains ID, Officer and name,
STRUCTURAL RECORD Resident Maedical Officer Views = RID + Name Name = First Name + (Middle Name) + Last Name
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
RID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
DATA FLOW Name:
Dean of Faculty Views
Description:
Contains information of the students involved in appealing process
Source :
Dean of Faculty External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Dean information
Comments:
Dean views, name, and Dean ID, Department name.
STRUCTURAL RECORD Dean of Faculty Views = DID + Name + Office_Number Name = First_Name + (Middle_Name) + Last_Name
DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
DID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
Office number
integer
5
DATA FLOW Name:
Suaso Minister Views
Description:
Contains information of the students involved in appealing process
Source :
Suaso Minister External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Minister information
Comments:
Minister views, name, and Registration number.
STRUCTURAL RECORD Suaso Minister Views = ID + Name Name = First_Name + (Middle_Name) + Last_Name DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
ID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
Office number
integer
5
DATA FLOW Name:
Dean of Students Views
Description:
Contains information of the students involved in appealing process
Source :
Dean of Students External Entity
Destination:
Process 3, Appeal Processing
Type:
Screen
Data Structure :
Dean Information
Comments:
Dean views, name, and Dean ID.
STRUCTURAL RECORD Dean of Student Views = DID + Name + Office_Number Name = First Name + (Middle Name) + Last Name DETERMINING ELEMENT LENGTH ELEMENT
DATATYPE
LENGTH
DID
varchar
20
First name
varchar
20
Middle name
varchar
20
Last name
varchar
20
Office number
integer
5