data-dictionary for mazimbu weathering recording system(mwris)

SOKOINE UNIVERSITY OF AGRICULTURE

FACULTY OF SCIENCE

DEPARTMENT OF INFORMATICS

DEGREE PROGRAMME: BSC. EDUCATION (IM) AND BSC.INFORMATICS

COURSE NAME: INFORMATION SYSTEM DESIGN & ANALYSIS

COURSE CODE:       INF 300

PARTICIPANTS

STUDENT NAME	REG.NO	SIGNATURE
MCHWAMPAKA JOVINA B	INF/D/2014/0026
LUKYAA WITNESS	EIM/D/2014/0066
MWIGEKA OSCAR PETER	INF/D/2014/0004
OUDU FRANK	EIM/D/2014/0078

QUESTION

Create a data dictionary of mazimbu weather recording system.

   Data dictionary: Is a reference work of data about data (metadata), one that is compiled by the systems analyst to guide them through the analysis and design. • It is where the systems analyst goes to define or look up information about entities, attributes and relationships on the ERD (Entity Relationship Design). Is the information you see in the data dictionary.

We shall use the following sysmbols

Equals =  means “composed of”

Plus + means “and”

Braces {} means “repetitive elements”

Brackets [ ] means “either or”

Parentheses ( ) means “optional elements”

DATASTRUCURE FOR  MAZIMBU WEATHER RECORDING SYSTEM

               =                        SUA staff +

                                            students +

                                              television station +

                                              agriculture agency+

                                               Tanzania meteorological agency

STAFF MEMBER DATASTRUCtURE:

SUA staff=name of staff member+

                       ID of staff member+

                       Address+

                       Date of employed+

                      Salary+

Department+

  Telephone +

Name of staff member=Fist-name+

                               (middle-name )+

                                  Last-name        

Element	format	length	Data type
First Name	Alphabetic	10	string
middle name	Alphabetic	12	string
Last-Name	Alphabetic	10	string

ID of staff member=name of staff_member +

                                  Department_name +

(OfficePhone)+

[Sex]+

                             Date issued+

                            Expiry date+

                      Signature of Authorized officer

element	Format	length	Datatype
Firstname	Alphabetic	10	string
Middle name	Alphabetic	12	string
Last name	Alphabetic	10	string
Department name	Alphabetic	9	string
Local number	numeric	6	integer
Country code	numeric	5	integer
Network code	numeric	3	integer

Address=street+

                (Apartment)+

City+

              State+

               Zip+

              (Zip expansion)+

               (Country)

Element	format		length	Data type
street	Alphabetic		2	varchar
Apartment	Alphabetic		4	string
City	Alphabetic		4	string
State	Alphabetic		7	string
Zip	code		8	string
Zip expansion		code	6		string
Country		Alphabetic	6		string

 Date of employed=Date+

                              Month+

Year

Element	format	length	Data type
Day	Alphabetic	2	integer
month	Alphanumeric	4	integer
year	numeric	4	integer

Department=  department_name

Telephone=Local number+

 Country code+

                      Network number

Element	format	length	Data type
Country code	numeric	6	integer
Local number	numeric	6	integer
Network number	numeric	4	integer

DATASTRUCTURE FOR STUDENT

Student= name+student id +

address+

(phone number)

Name=Firstname+

             (Middle name)+

             Last name

                                        

Element	Format	length	Data type
First Name	Alphabetic	10	string
middle name	Alphabetic	12	string
Last-Name	Alphabetic	10	string

 Student ID=name of student+

                                  course_name +

                                   exam number+

                           [Sex]+

 Address= Street+

                 Apartment+

                 city+

                 state+

                (zipcode)+

                (zip expansion)+

                country

Element	format	length	Data type
street	Alphabetic	2	varchar
Apartment	Alphabetic	4	string
City	Alphabetic	4	string
State	Alphabetic	7	string
Zip	code	8	string
Zip expansion	code	6	string
Country	Alphabetic	6	string

Telephone_number = country_code +

                                   local_number +

                                   user_number

Element	format	length	Data type
Country code	numeric	6	integer
Local number	numeric	6	integer
Network number	numeric	4	integer

DATASTRUCTURE FOR TV BROADCASTING.

TV Broadcasting = Station Id+

                              Station frequency +

                              Address +

                             Telephone Number +

                              Location +

                              Payment +

                              Email  +

                             Manager +

                             Weather forecasting date

Station Id = integer(6)

Element	Format	length	Datatype
StationId	Alphanumeric	6	string

Station frequency = varchar(5)

Element	Format	length	Datatype
Station frequency	symbol	5	string

address = street +

                 city +

                postcode

Element	format	length	Data type
street	Alphabetic	6	string
city	Alphabetic	6	string
postcode	Alphanumeric	4	string

telephone_number = country_code +

                                     local_number +

                                     user_number

Element	format	length	Data type
Country code	numeric	6	integer
Local number	numeric	6	integer
Network number	numeric	4	integer

Location = country+

                    region

Element	format	length	Data type
street	Alphabetic	9	string
city	Alphabetic	9	string
region	Alphabetic	8	string

Payment =   check +

                     cash +

                   mobile money

Payment record file = date + amount + type of payment + type of item

§  date = day + month + year

§  type of payment = [mobile payment; credit card; cash; cheque]

Element	format	length	Data type
Day	numeric	20	Integer
amount	numeric	9	integer
year	numeric	4	integer
cash	numeric	9	integer
Type of item	alphabetic	5	string

 Email= UserName+

  @ symbol +

  Last_Name

Element	format	length	Data type
Username	Alphabetic	9	string
@	symbol	1	Special character
LastName	Alphabetic	11	string

Manager = Manager Name +

                    Email +

                   Telephone number +

                    position

Element	format	type	datatype
First Name	Alphabetic	10	string
middle name	Alphabetic	12	string
Last_Name	Alphabetic	10	string
Username	Alphabetic	10	string

@	symbol	1	Special character
Last_Name	Alphabetic	10	string
Country code	numeric	6	integer
Local number	numeric	6		integer
Network number	numeric	4		integer

Weather forecasting date = day +

                                              month +

                                               year

Element	format	length	Data type
Day	Alphabetic	2	varchar
month	Alphanumeric	4	integer
year	numeric	4	integer

DATASTRUCURE FOR AGRICULTURE

 Agriculture= Agency_ID+address+location+Telephone

Agency Id = integer(6)

Element	Format	length	Datatype
Agency Id	Alphanumeric	6	string

Address= Street+

                 Apartment+

                 city+

                 state+

                (zipcode)+

                (zip expansion)+

                country

Element	format	length	Data type
street	Alphabetic	2	varchar
Apartment	Alphabetic	4	string
City	Alphabetic	4	string

State	Alphabetic	7	string
Zip	code	8	string
Zip expansion	code	6	string
Country	Alphabetic	6	string

Location=  street+

                    city+

                  region

               

           

Element	format	length	Data type
street	Alphabetic	9	string
city	Alphabetic	9	string
region	Alphabetic	8	string

                  

Telephone_number = country_code +

                                   local_number +

                                   network_number

Element	format	length	Data type
Country code	numeric	6	integer
Local number	numeric	6	integer
Network number	numeric	4	integer

DATASTRUCURE FOR TMA(TANZANIA METEREOLOGICAL AGENCY)

TMA=location+

            number+

            address+

            name+

            telephone

Location= region+

                  city+

                  street

Element	format	length	Data type
street	Alphabetic	9	string
city	Alphabetic	9	string
region	Alphabetic	8	string

                 

Agency_number= number

Element	format	length	Data type
number	Numeric	9	integer

Address= Street+

                 Apartment+

                 city+

                 state+

                (zipcode)+

                (zip expansion)+

                country

Element	format	length	Data type
street	Alphabetic	2	varchar
Apartment	Alphabetic	4	string
City	Alphabetic	4	string
State	Alphabetic	7	string
Zip	code	8	string
Zip expansion	code	6	string
Country	Alphabetic	6	string

Agency name=name

Element	format	length	Data type
name	alphabetic	9	string

Telephone_number = country_code +

                                   local_number +

                                   user_number

Element	format	length	Data type
Country code	numeric	6	integer
Local number	numeric	6	integer
Network number	numeric	4	integer

REFERENCE

http://www.slideshare.net/kimsteelegrey50/systems-analyst-and-design-data-dictionary