Instructions

Your task is to in this assignment is to understand and extract user needs. Consider

the following scenario:

Jacksonville Property Management $($JPM$)$ manages rental properties owned by

private $($individual$)$ owners. The company stores such property owner information

as name $($First name, middle initial and last name$),$ owner$$s personal home address

$($street$,$ city, state, zip$),$ owner$$s email address and phone numbers $($primary and

secondary$).$ In addition, JPM keeps credit card$($s$)$ information $($name on the card,

card number and expiry date$)$ on all property owners, in case there is a

maintenance expense that needs quick processing. The company also keeps

information about bank$($s$)$ where the deposits would be made of the rental income $-$

bank information $($account type, bank, name, account number and routing number$).$

Each property owner may have one or more properties to rent, JPM keeps

information on each property including street address, city, state, zip code, and the

type $($condo$,$ single$-$family$).$ Also needed are square footage, number of rooms,

bathrooms and garages, monthly rent and deposit amount needed. The company

must keep track of all rental income, deposits, and maintenance costs $$ that

information is needed by the property owners and the IRS.

Each renter$($tenant$)$ signs a rental agreement for a specific property, each rental

agreement would have a unique rental identification number. In addition, rent

amount, date of signing, start and end date of agreement $($lease$)$ are also stored. A

renter can rent multiple properties, a renter$$s name $($first$,$ middle and last$),$ email

address, phone number and address $($street$,$ city, state, zip code$),$ bank information

$($account type, bank, name, account number and routing$)$ are stored.

JPM is a small business with the owner and three employees, they all can enter and

edit the data in the database. In addition, company website allows browsing

available homes to rent and authorized owners can view information about their

own properties, such as$,$ when it was leased and when the lease is expiring, rents

and maintenance costs.

After reading $($and re$-$reading$)$ the above scenario, you would have some questions.

Functionality

$$ List at least two questions about the functionality of the system that you may

still have.

Data Needs

$$ List at least two questions about the project$$s data needs that you may still

have.

Data Integrity

$$ List at aleast two questions about the data integrity that you may still have.

Security

$$ List at least two questions about the data and application security that you

may have.

Environment

$$ List at least two questions about the project$$s surrounding environment that

you may have.

Data for User Interface

$$ Refer to JPM scenario, renters $($tenants$)$ can browse properties to rent, owners

can view data on their own properties and owner$/$employees can view and

edit data. Consider the user interface for each type of user and list what data

would be needed.

Data Integrity

$$ Develop a table that describes each field in the database, whether it is

required to have data integrity, data type $($text$,$ mumber, data or Boolean$)$

and domain $($whether data will be validated or any data will be allowed$).$

Please note that you may need additional fields in your database besides the

ones listed in the scenario. You can use your logical assumptions as

necessary to ensure that the database is