Property management database, Database Management System

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.

Posted Date: 2/22/2013 5:40:28 AM | Location : United States







Related Discussions:- Property management database, Assignment Help, Ask Question on Property management database, Get Answer, Expert's Help, Property management database Discussions

Write discussion on Property management database
Your posts are moderated
Related Questions
Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

Briefly explain what is to be done during defining problem statement. To define Problem Statement of a system, define what is to be done and how you can go to implement that. Y

Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries

What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical

What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

What is a view in SQL? When can views be updated? A view is a virtual table which consists of columns from one or more tables. Through it is same to a table; it is stored in

intent locking

Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);