WOW !! MUCH LOVE ! SO WORLD PEACE !
Fond bitcoin pour l'amélioration du site: 1memzGeKS7CB3ECNkzSn2qHwxU6NZoJ8o
  Dogecoin (tips/pourboires): DCLoo9Dd4qECqpMLurdgGnaoqbftj16Nvp


Home | Publier un mémoire | Une page au hasard

 > 

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

( Télécharger le fichier original )
par Herménégilde HUNDWITIRO
National University of Rwanda - Bachelor Degree 2009
  

précédent sommaire suivant

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

précédent sommaire suivant






Bitcoin is a swarm of cyber hornets serving the goddess of wisdom, feeding on the fire of truth, exponentially growing ever smarter, faster, and stronger behind a wall of encrypted energy