DREAM-HOME

\

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

CONTEXT DIAGRAM FOR DREAM-HOME 

   LEVEL “0” DIAGRAM FOR DREAMHOME

LEVEL “1” DIAGRAM FOR PROCESS ONES

LEVEL “1” DIAGRAM FOR PROCESS TWO

LEVEL “1” DIAGRAM FOR PROCESS THREE

LEVEL “1” DIAGRAM FOR PROCESS  FOUR

LEVEL “1” DIAGRAM FOR PROCESS  FIVE

LEVEL”1” DIAGRAM FOR PROCESS SIX AND SEVEN:

ENTITY RELATIONSHIP DIAGRAM (ERD) FOR DREAMHOME

DATA DICTIONARY FOR PROPERTIES FOR RENT

properties_for_rent = property_no + property_type + no_of_rooms + monthly_rent + property_owner

property_number = {A-Z | 0-9 | special characters}

special characters = {/ -}

property_type = fixed_property + movable_property

fixed_property = {characters}

movable_property = {characters}

character = {A-Z | a-z}

no_of_rooms = integer

monthly_rent = {amount}

property_owner = {staff_no}

DATA DICTIONARY FOR PROPERTY OWNERS

property_owner = private_owner + business_owner

private_owner= owner_no + owner_name + owner_address + owner_telephone_no

owner_no = {integer}+ special_character

special_character= {/}

owner_name ={first_name + (middle_name) + surname}

owner_address = {street + city + postcode}

telephone_no = {country_code + local_number + user_number}

business_owner = business_id + business_name  +  type_of_business  +  business_address  +  business_tel_no

business_name = {character}

business_type = {character}

business _address = {street + city + postcode}

business _tel_no = {country_code + local_number + user_number}

business_contact_name = {characters}

DATA DICTIONARY FOR CLIENT

client= client_no+ name + telephone _number+ accommodation  + max_rent  + staff

client_no=  integer  + (special_char)

integer = 0-9

special_char =[#;/;@ ;$;&]

client_name = {title + firstName + (middleName) + surname}

title = [Mr | Mrs | Miss | Dr | Prof | Rev | Sheikh | Eng]

client_telephone_no ={ country_code + local_number + user_number}

accommodation_type = [permanent |  temporary]

max_rent ={ £}

staff = registration + client_date + branch_details

registration = {integer}

{integer} = 0 – 9

client_date = {date}

branch_details = name+number

name={characters}

number={interger}

DATA DICTIONARY FOR LEASE

lease = lease_no  + client + property

lease_no = {integer}

client = client_no + client_name + client_address

client_no = {characters}

client_name = {title + firstName + (middleName) + surname }

client_address = {street + city + postcode }

property = property_no + monthly_rent + method_of_payment + duration_of_lease

property_no = {characters}

monthly_rent = {£}

method_of_payment = [cash | cheque]

duration_of_lease = date_lease_start + date_lease_finish

date_lease_start = {date}

date_lease_finish = {date}