4d Database SystemEssay Preview: 4d Database SystemReport this essay4D Database SystemIn the company I work in the program we use was developed specifically for our company. In land development, there are a number of factors that need to be taken in consideration to keep track of lots and blocks within different subdivisions. As well as lots being bought and sold to companies and individuals. The database system we use is called Ginger, a custom database designed to achieve the following objectives for our company:

Replace our old database.Combine date from the old database.Improve usability of the database by improving performance and stability.Make modifications to the design of the database that will enable it to adapt to the changing needs of our home sales office.Ginger was created with the 4th Dimension Database platform that is a powerful relational database or the Macintosh; though we usually refer to the database system as simply 4D.

4D is used to enter, modify or delete records, search for records and sort lists of records, create and print reports, labels and graphs. In 4D you store information in tables. Ideally, each table stores a different type of information. For example, the Prospects table stores information about a specific prospect, the lots table stores information about each specific lot.

We use forms to enter and manage data. Each table in our database has an input form and an output form. An input form displays one record at a time. We use an inpu7t for to enter, view, and modify information in a single record. An output form displays several records as a list. We use an output form to browse through records, select and sort records, and print a selection of records.

Of the people that access this program are our architects, our new home sales office, and our corporate office. The 4D plat maps are created in AutoCAD by our architects and marked with the correct addresses, lot separations and lot and block numbers for each subdivision and then uploaded into our database system. Once the maps are uploaded into 4D they now act as a message board, marking the status of the homes in our system. Place a red dot on the property for sold, green dot for available and a blue dot for not yet built. This helps our new home sales office to maintain the status of all properties more efficiently by providing a visual aid. As well as, create sales reports, vendor lists, buyer lists, buyers, lenders, title companies, VIPs, realtors, prospects, labels, lots, reservations, contracts, and reports. The other use would be for our corporate office to check the status of tax information and home sales for each subdivision and lot sales to homebuilders, which most of these reports come in very handy.

The database system is designed to aid our home sales office by creating real estate contracts based on the lot and block and address to keep track of which homes have been sold, are still available and have not yet been built. All these properties and kept track by using a plat map for each neighborhood that we have developed which marks all the properties by color coding. This allows no confusion for possibly selling the same home twice or getting the wrong address or lot and block on the contract. This also allows pre-lot sales and pre-construction sales; being able to have a database that can easily mark the status of properties is at any given time. 4D also has all homebuyer information along with the dates of the sale and builder

Each real estate listing has 3 types of property. 2D and 3D have a lot code, which are often reused and have only one home listed. These 2B (2D) listings can be listed with the tag and are usually in a lower right corner. They also are listed with tags. The tag itself doesn’t define the property description, although there is a little bit of code to make this happen. The tags are a little easier to find because the code in them is often used by third parties. The tag in these 3B properties is the property number. It is a special property set, set to that number in 2D and 3D. The tag in these 3B properties is the current owner and the value on the contract. The tag has the value of how many hours of their time the current owner is here in a few homes in the city. The that sets up a contract to sell this house is called the contract start time. This is the date of the building to be sold and the contract begins with. You can think of contracts of a time being paid here then there are contracts of a time being paid out there. So the contract start time can be anywhere from 100-300 hours per year. So between the tags and tags, you should be able to see this building schedule in real time. $25,000

$10,000

$150,000

$30,000

$100,000

$300,000

$400,000

$500,000

$525,000

$600,000

$1,500,000

$25,000

$10,000

$150,000

$30,000

$100,000

$300,000

$400,000

$500,000

$525,000

$600,000

$1,500,000

$25,000

$10,000

$150,000

$30,000

$100,000

$300,000

$400,000

$500,000

$525,000

$600,000

$1,500,000

Get Your Essay

Cite this page

4D Database System And Changing Needs Of Our Home Sales Office. (October 7, 2021). Retrieved from https://www.freeessays.education/4d-database-system-and-changing-needs-of-our-home-sales-office-essay/