The implementation of web based system for the improvment of good governance in the development of rwandan districts.

4.3.8 Data Dictionary

Data dictionary is that part of database management system that defines the structure of user data and how they are to be used.

Data dictionary of our system is represented in the following tables. 1) Applicant2

Field Type Collation Attributes Null Default Extra

Applicant_Id Int(2) - No - Auto_increment

Tender_id Announcement_Id Names Telephone Occupation Address Quantity Price	Int(11) Int(2) Varchar(50 Varchar(50 Varchar(50 Varchar(50 Varchar(50 Varchar(50			No	-	-
			-	No
		Lattin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ci		No No No No No No

Duration Varchar(50) Latin1_general_ci No

Accoumt_no Varchar(50) Latin1_general_ci No

Bank Varchar(50) Latin1_general_ci No

Date Date Latin general ci No

Table 4.3. Applicant table Source Own drawing

2) Announcement

Field Type Collation Attribute Nul Defaul Extra

s l t

Announcement_id Int(2) No Auto_increme

nt

Announcement_Na Varchar(5 Latin1_general_ No

me 0) ci

No

Announcement Varchar(5 Latin1_general_

0) ci No

Announcement_Dat

e Varchar(5 Latin1_general_

0) ci

Table 4.4 Announcement
Source: Own drawing

3) Chat

Field Type Collation Attributes Null Default Extra

User_id Int(2) No Auto_increment

Name Varchar(50) Latin1_general_ci No

Message Varchar(50) Latin1_general_ci No

4) Comment

Field Type Collation Attributes Null Default Extra

Comment_id User_id Name E_mail Address Comment

Int(2) Int(11) Varchar(20) Varchar(20) Varchar(20) Varchar(20)

^Latin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ci

No No No No No

Auto_increment

Table 4.6 : Comment Source: Own drawing

5) Password

Field Type Collation Attributes Null Default Extra

User_id First_name Last_name Password Access_level Level_number E_mail

Int(2) Varchar(20) Varchar(20) Varchar(20) Varchar(20) Varchar(20) Varchar(20)

Latin1_swedish_ciLatin1_swedish_ciLatin1_swedishl_ciLatin1_swedishl_ciLatin1_swedishl_ciLatin1_swedishl_ci

No No No No No No No

Auto_increment

Table 4.7: Password Source: Own drawing

6) Results

Field Type Collation Attributes Null Default Extra

Id Names Address Quantity Price Details Date District

Int(2) Varchar(20) Varchar(20) Varchar(20) Varchar(20) Longtext Date Varchar(20)

Latin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ci

Auto_increment

Table 4.8: Results Source: Own drawing

7) Attachfile

Field Type Collation Attributes Null Default Extra

Attach_id Applicant_id Bordereau Lettre Photocopie ^Le_delaiAttestation Icyemezo_ko_nta_mwenda Icyemezo_ko_yaguze Icyemezo_cy'_ingwate Date

Int(11) Int(11) Text Text Text Text Text Text Text Text date

Latin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ciLatin1_general_ci

No No No No No No No No No No No

None None None None None None None None None None None

Auto_increment

4.3.9 Implementation 4.3.9.1 Screen Glossary

Screen number Screen name Purpose

MAIN PAGE

1.1 Login area This area, allow to login in account as

administrator.

1.2 Home area Informs about the district invitation to tender

management information system (DITMIS).

1.3 Announcement Informs about the announcement on tenders

area available in the district.

1.4 Tender area Informs about the details about the tenders

and it allows also to apply for any tender.

1.5 Contact us

1.6 Login here area

1.7 Register here

1.8 Chat area

1.9 Add comment area

Informs about the contact of the district.

Allows to login as an existing user.

Allows to register as a new user.

Allows members and users of the system to send each other message.

Allows sending any comment about the system and tenders.

SYSTEM ADMINISTRATOR INTERFACE

2.1 View all applicants

2.2 View all comments

2.3 View all users

2.4 Print announcement

2.5 Print tender

2.6 Create Account

2.7 View attached file

2.8 Logout Allows viewing all applicants.

Allows viewing all comments.

Allows viewing all users.

Allows printing announcement for any tender.

Allows printing the details about the tender available.

Allows to create accounts

Allows to view other additional files attached by applicants.

Allows to quit the administrator interface.

Table 4.10: Screen Glossary Source: Own drawing