Suppose Bob Snyder has many single family houses for rent. He wish to hire you to build a database to manage his rental business. After you have interviewed with him, you get the following information: (1) A person who wish to rent a house for his family can find all details of each house on the website, www.zhangproperty.com, such as the location, size, number of bedrooms, garage capacity, number of bathrooms, year built, etc. It also shows the current status: rented, pending, or available. (2) A person who wish to rent a house must submit an application with an application fee. The application form is available online also that asks basic information of the applicant such as name, telephone, email, yearly income, how many family members to live in, and credit score. The monthly rental rate and deposit are available online also. (3) A person may apply for renting more than one house, but at most 3 houses can be rented at most. Moreover, he needs to submit a separate application for each house. Bob wish to keep track the following information: (1) The current status of each house, either being rented or not. If it is being rented, whose family lives in that house, what date the renting started and the expiration date. (2) The status of each application. There are 3 kinds of status: The application has been approved and a contract has been signed. If this is the case, Bob needs to know who is the applicant, the start date of the contract became or becomes effective, and the expiration date of the contract. The application has been approved but the applicant has not signed a contract yet (pending). There is a deadline for the applicant to sign the contract. If Bob does not receive the signed contract back, he will deny the application. The application has been denied. (3) Bob wish to have a separate table structure to keep track the status of those houses that are currently being rented. He also wish to have a separate table to keep track the status of pending houses to make sure they will not be rented to new applications. Further, a table of available houses would help him to understand market situation and to adjust rental rate and other policies. (4) Contact information of applicants include address, phone number, email, etc. Any applicant will be included even his applications are denied or he has gone long time ago.