How to design the database of house leasing system?

First, it mainly includes the following modules:

(1) user management

(2) Inquiry and management of housing information;

(3) Basic customer information management

(4) Customer demand management

(5) Housing lease management

Second, the main functional modules

1. User information management

Administrators add and delete accounts of ordinary employees.

2. Housing information query and management

Housing information query: staff can make multi-condition and fuzzy query according to customer information, such as searching for housing in a certain area in a designated community.

Housing information management: staff input, delete and modify housing information, such as housing location, area, contact information, rent, etc.

3. Customer basic information management

Staff register and maintain the basic information of visiting customers, such as name, gender, contact information, etc.

4. Customer demand management

Staff register and maintain the rental requirements of visiting customers, such as housing type, area requirements, rent, etc.

5. Housing lease management

The staff shall register the leasing business, including leasing customers, houses, transaction rent, lease term, completion, etc.

Third, the database design (reference)

User table (user number, user name, password)

House information table (house number, location, area, apartment type ... whether to rent)

Customer information table (customer number, name, gender, age, contact number)

Customer demand table (customer number, room type, floor, area, rent, etc.). ).

House lease form (customer number, house number, completed person).