Business database technology systems and applications

Business Database Technology

Scenario

The focus of this project is to design a database program for a company called Home Sweet Home that specializes in the management of properties on behalf of owners. The company offers a complete rental service for customers willing to rent furnished properties. The services delivered by the Home Sweet Home include advertising of properties in then local and national press. The company also carries out the interview and organize visit to prospective renters as well as negotiating the lease agreement. Once a customer rent a property, the company assumes the responsibilities of carrying out the regular property inspection.

Entities are the object used to track the database, and each entity is stored in the database. The entity assists in designing the ERD (entity relation diagram). This paper identifies the entities that need to be used in the database design for the Home Sweet Home. The principal entities needed in the design of ERD (entity relation diagram) are as follows:

Entities

Branch office: The Company has branch offices scattered across the United States.

Staff: The company staff is in charge of day-to-day administration of the company.

Staff next of Kin: The person very close to a member of staff.

Property for rent: The properties that the company offers to customers.

Property owners: They are the people who own the properties, which the company offers for rent.

Renters: These customers pay for the properties.

Property Viewings: Customers are required to view properties before paid for properties.

Property advertising: The company also offers the adverts in the local and nation press.

Lease agreements: the company the term of the lease draws this.

Property inspections: The company carries out regular inspections of properties to properly maintain properties.

Attributes

Attribute is the information of each attributes in the database. The attributes are the column in the database table that tracks individual fields. The attributes of the database Home Sweet Home are as follows:

Entity

Attribute

Branch offices

Branch number

Address:

street, area, city,

Telephone number

Fax number

Staff

Staff number,

First name

Last name

Address:

street, area, city,

Telephone number,

Gender,

Date of birth,

Social Security Number (SSN),

Job title (position),

Salary,

Date joined the company.

Staff next of Kin

Next-of-kin's Full name,

Relationship to the staff,

Address:

Street

City

Telephone number.

General Work Details / Managerial Staff

Position

Allocated to Branch Office

Branch Number

Joined Company

Date Start

Salary

Car Allowance

Bonus Payment

Typing Speed

Property for Rent

Property Number

Branch Number

Branch Office Address

Telephone Number

Fax Number

Type of property,

Number of rooms,

Monthly rent.

Property owners

Owner Number,

Owner's Name,

Address:

street, city,

Telephone number.

Renter Details

Renter First Name

Renter Last Name

Address:

street, city,

Telephone number.

Property Requirement Details:

Preferred Property Type

Maximum Monthly Rent

General Comments

Seen By

Branch No

Branch City

Property viewings

Date of the viewing

Comments

Property advertising

Property being advertised

Cost

Newspaper name

Address:

street, city,

Telephone number.

Telephone number,

Fax number,

Contact name.

Lease agreements

Renter No

Property No

Full Name

Address

Address (Previous)

Tel No

Payment Details:

Monthly Rent

Rent Start Date

Payment Method

Rent Finish Date

Deposit

Duration

Paid (Y or N)

Property inspections

Property Number

Allocated to Branch