DREAM HOME PART ONE

SOKOINE UNIVERSITY OF AGRICULTURE

DEPARTMENT OF INFORMATICS                                                                                                                                    FACULTY OF SCIENCE COURSE CODE: INF 300. COURSE NAME: INFORMATION SYSTEM ANALYSIS AND DESIGN.

S/NO NAME REG.NO SIGNATURE 1 AXWESSO ROBERT B EIM/D/2014/0001 2 MTYABA EDIVINA EIM/D/2014/0034 3 MACHELE VEREDIANA MBALILO EIM/D/2014/0060 4 KALOLO SALOME BENEDICT EIM/D/2014/0012

INSTRUCTOR NAME: PROF. C.SANGA

ASSIGNMENT FOR DREAMHOME

i.                    Context diagram

ii.                  Data flow diagram (DFD) level 0

iii.                Data flow diagram (DFD) level 1

\

      

iv. Entity relationship diagram

v.                  Relational schema

Branch (BrachNo, PhoneNo, Street, City, Postcode)

PropertyForRent (PropertyNo, Postcode, street, RoomNo, type, MonthlyRent, details, BranchNo, StaffNo, OwnNo, NewspaperName, ClientNo)

Client (ClientNo, Name, PhoneNo, Accomodation, AmountPay, RegistrationName, StaffNo)

Staff (StaffNo, Name, Address, position, salary, BranchNo)

PrivatePropertyOwner (OwnerNo, Name, Address, Phone, PropertyNo)

BusinessPropertyOwner (PropertyNo, BusinessName, Type, Address, TelephoneNo, ContactName)

Lease (LeaseNo, Name, StartDate, FinishDate, Duration, MethodOfPayment,  PropretyNo, ClientNo)

Newspaper (Name, Address, ContactsName, telephoneNo, PropertyNo)    

vi.                DATA STRUCTURE

A.                Branch =Branch Number + Staff Name + Phone number + Address

Branch Number= int

Staff Name= First name + (middle name) + last name

First name= VARCHAR (30)

Middle name= VARCHAR (30)

 Last name = VARCHAR (30)

Phone Number= Area code + local number

Area code = VARCHAR (4)

Local number = int

Address = street + city + postcode

Street= VARCHAR (20)

City = VARCHAR (20)

Postcode = VARCHAR (30)

B.                 Staff = staff number + Name + Address + Position + salary

Staff number = int

Name= First name + (middle name) + last name

First name= VARCHAR (30)

Middle name= VARCHAR (30)

 Last name = VARCHAR (30)

Address = VARCHAR (30)

Position = VARCHAR (25)

Salary = float

C.                 Client= Client Number + Name +  Phone Number +  Accomodation type + AmountPay + Registrar name + Staff Number

Client Number = int

Name = First name + (Middle name) + Last Name

First name= VARCHAR (20)

Middle name = VARCHAR (20)

Last name = VARCHAR (20)

Phone number = Area code + Local number

Area code= VARCHAR (4)

Local number = int

Accommodation type = VARCHAR (15)

Amount pay= real

Registrar name= VARCHAR (30)

Staff number = VARCHAR (30)

D.                Lease = Lease number + Name + Date + Duration + Method Of Payment +  Property Number + Client Number

Lease number = int

Name = VARCHAR (30)

Date = start date + finish date

Start date = datetime

Finish date = datetime

Duration = float

Method of payment = VARCHAR (20)

Property number = int

Client number = int