reddevil1
Registered User.
- Local time
- Today, 14:43
- Joined
- Nov 12, 2012
- Messages
- 92
Hi,
Please be gentle with me…..J
I would be extremely grateful if anyone would be willing to spend a little time to give a critique/review of the Tables & Relationships and highlight any areas that need to be improved.
Brief Requirements
At this stage, I have done everything within my limited knowledge to create structured Tables & Relationships. But before I start to create the Forms and Reports, it has been recommended that I seek reviews of the Tables & Relationships (which, I have been told, need a thorough overhaul???)
I just need a solid foundation that will not cause me any fundamental problems in the future. I am not looking for perfection, or anything extra special.
Business Model
This will be a small property rental business. Renting apartments on short and long term contracts.
Starting with 2 or 3 full time employees, growing to maybe 10 employees depending upon amount of business generated.
I want the Database to record various details of the Income (rental Income and commission etc) and Expenditure (maintenance work, utility payments, taxes etc)
The DB will also naturally need to capture details of the properties, owners, renters, employees and rental contracts.
Target number of rental properties is 100, but hopefully rising to 1,000 or more in the future.
I want my employees to use the details of the properties so they can suggest suitable properties for potential tenants.
Summary
I am not sure if I have missed anything out? I have attached the Tables & Relationships (with some sample data), but not the Forms or Reports.
Any guidance that you could provide would be very much appreciated.
Thank you.
Paul
Please be gentle with me…..J
I would be extremely grateful if anyone would be willing to spend a little time to give a critique/review of the Tables & Relationships and highlight any areas that need to be improved.
Brief Requirements
At this stage, I have done everything within my limited knowledge to create structured Tables & Relationships. But before I start to create the Forms and Reports, it has been recommended that I seek reviews of the Tables & Relationships (which, I have been told, need a thorough overhaul???)
I just need a solid foundation that will not cause me any fundamental problems in the future. I am not looking for perfection, or anything extra special.
Business Model
This will be a small property rental business. Renting apartments on short and long term contracts.
Starting with 2 or 3 full time employees, growing to maybe 10 employees depending upon amount of business generated.
I want the Database to record various details of the Income (rental Income and commission etc) and Expenditure (maintenance work, utility payments, taxes etc)
The DB will also naturally need to capture details of the properties, owners, renters, employees and rental contracts.
Target number of rental properties is 100, but hopefully rising to 1,000 or more in the future.
I want my employees to use the details of the properties so they can suggest suitable properties for potential tenants.
Summary
I am not sure if I have missed anything out? I have attached the Tables & Relationships (with some sample data), but not the Forms or Reports.
Any guidance that you could provide would be very much appreciated.
Thank you.
Paul
