Reference no: EM13936921
Realestate First Corp
A friend has a small real-estate business. He handles a small number of clients with their selling and leasing arrangements. He has a small number of clients because he concentrates his business on serious property investors, providing them a superior service. Most of his clients own multiple properties that they lease and are buying and selling properties often.
He currently has an exercise book for each client, with a list of each property owned by that client. The first page of the book has details about the client, like their address and various contact details. This is used to enable contacting the client by either mail, email or by phone.
The other pages of the client exercise books have details about each property that has been bought or sold for the client. These pages first include details about the property, including address and construction type (brick veneer, double brick, weatherboards, etc...), roofing type (steel, tiled, etc.), number of bedrooms, number of toilets, living room size, dining room size, kitchen size,etc... The other details written in the client exercise books, for each property, is the buy and sell details of the property, which includes the amount, stamp duty and settlement date.
Some properties are leased (rented). Currently a seperate exercise book is used to keep a record of the leases. This includes details of the people leasing the property, details of which property is being leased, and details about the lease (like the cost per week, and the length of the lease).
The small real estate company wants the following reports:
• List of customers and their details.
• List of properties currently owned by clients of the real-estate company.
• List of leases currently active and details of the weekly lease payments.
The small real-estate agency wants to computerise the manual system they currently have. What you have been asked to do is provide the database model for the system
To assist the students, try and come up with a small database design for their new website.
Provide the following:
• Entity Relationship Diagram.
• Relational Model (showing fields, primary keys, foreign keys and concatenated keys).
• Justify the choices you have made. Are the entities and relationships you have chosen free of problems ? What assumptions have you made ?
Create the database tables using SQL statements in your own database. Include
• CREATE TABLE queries - that create each of the tables in your design
• INSERT INTO queries - that insert values into your tables (at least 5 rows per table)
Write some queries to test out the database.
• One query should be a simple one involving one table and a selection criteria.
• The second query should involve a join (at least 2 tables)
• The third should be a group by query.
• Fourth query that involves a nested query.
|
Web about toutorial for cooking saudi food
: Will develop a web about toutorial for cooking Saudi food , and have a hard time writing a planing project for my topic. Follow these link in order to complete the assignment Her is the requirements for the assignment This assignment has two part..
|
|
Difference between reproductive and therapeutic cloning
: What is the difference between reproductive and therapeutic cloning? Name one limitation for each technique. Make sure to differentiate between pluripotent and totipotent embryonic stem cells as well as adult and embryonic stem cells.
|
|
Consumer behaviour journal article
: Essay You are to source a qualitative (not quantitative) consumer behaviour journal article from the Journal of Consumer Research. Summarise the article; including the topic, premise, methodology,
|
|
What are the implications
: What are the implications? Incorporate the elements that you believe should be reflected in the guidelines and the implications of governments and sports corporations which might clone and hybrid professional athletes to their specifications. Cite..
|
|
Provide the database model for the system
: The small real-estate agency wants to computerise the manual system they currently have. What you have been asked to do is provide the database model for the system
|
|
What is the xml editor
: should C++ programming language be extended to include an XML editor and parser as is the case for the Java® programming language, or should this be built into the Integrated Development Environment (IDE) that supports the programming language
|
|
The dimboola tiddlywinks association
: The Dimboola Tiddlywinks Association (DTA) has been given the job of managing the draw and results for the 32 regional tiddlywink teams. Each team has a name and a home town. Each match is a competition between two teams and is held at the locati..
|
|
Investigate the improvements in the indian common flying
: Q1. Investigate the improvements in the Indian common flying industry after the division was opened up for the private players. Assess IA's execution. Why do you think IA neglected to hold its piece of the pie against contenders such as Jet Airways?
|
|
Integration of the relevant marketing theory
: Insightful and comprehensive identification and discussion of key scholarly literature concerning the specialist marketing topic. • Advanced understanding and integration of the relevant marketing theory.
|