Property management database, Database Management System

Assignment Help:

You are to write a property management database program that allows a real estate agent to view, add, search, and save property listings. The program is to do the following:

1. On start-up, the program is to prompt the user for the property listings filename (the sample file provided is called properties.txt). The file contains the street address, suburb and price (in whole dollars) of each property listed by the agent. Once opened, the program is to read the data for each property from the file into a single array of structs.

A number of sample lines (two properties) from this file appear below and an entire sample file can be found on the subject web site. (Please note this format as your program must work with this, including the blank line at the end of the file.)

10 Napier St.

Palm Cove

350000

47 Darkien Cl.

Smithfield Heights

265000

2. Once you have read in all of the data, the program is to display a menu and prompt the user for their selection, as follows:

CPProperty - Menu:

1 - List all properties

2 - Property search

3 - Add a property

4 - Save property list

5 - Exit

Please enter option:

3. You are to use a switch statement for the menu selection and implement each option (except exit) as a function (you can have other functions as appropriate). The menu items above are to perform the following tasks (use the sample output below as a guide):

1 - Display all properties in the property list (in the order they were in the file)

2 - Search for and display properties up to a maximum value entered by the user

3 - Add a property to the property list (in memory, not the file yet)

4 - Save the current list of properties to a file. The user is to be prompted for the filename, and the property list is to be saved to the specified file. If the file exists, it is to be overwritten.

5 - Exit the program.


Related Discussions:- Property management database

Extended star schema, Why did SAP introduce the extended star schema? Expla...

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

Objectives of database manangement system, OBJECTIVES After going thro...

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

Explain cursors in sql, Explain cursors in SQL? Cursors in SQL - An o...

Explain cursors in SQL? Cursors in SQL - An object used to store the output of a query for row-through-row processing through the application programs. Cursors are constructs

What do you mean by persistence, What do you mean by persistence? How you w...

What do you mean by persistence? How you will make your data persistent? Persistent data is the data, which has a longer lifetime than program which has created it. Enabling th

Explain growing phase of locking, Explain Growing Phase of locking Grow...

Explain Growing Phase of locking Growing Phase: In this phase the transaction can only obtain locks, but cannot release any lock. The transaction enters the growing phase as so

Project, I have a small project that contains 3 deliverable s. I have done ...

I have a small project that contains 3 deliverable s. I have done the first one and I would like you to help me with second one

Functional Dependencies, What exactly is the concept of Functional Dependen...

What exactly is the concept of Functional Dependencies? And how do we associate this concept with the logic of Super-keys, Candidate Keys, etc? Given Relation R(A,B,C,D,E) with de

Give an example of operations from the functions of a bank, Give an example...

Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper

Attribute, a set of possible data value of an attribute is called??

a set of possible data value of an attribute is called??

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd