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

What is disadvantages of dbms, What is Disadvantages Of DBMS ? 1. Cos...

What is Disadvantages Of DBMS ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu

Column constraints-on delete cascade, CREATE TABLE prodtrans ( pno ...

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);

Answer, Describe multi key files

Describe multi key files

Write the queries in relational algebra, Problem: You are given the fol...

Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena

The result of the union operation between r1 and r2, The result of the UNIO...

The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c

What is advantage of two-way association, What is advantage of two-way asso...

What is advantage of two-way association? Two-way association advantages are following: a) Independent of the classes. b) Useful for existing predefined classes that are

Clustering indexes, Clustering Indexes It may be an excellent idea to k...

Clustering Indexes It may be an excellent idea to keep data of the students in the order of the programme they have registered as most of the data file accesses may need studen

Why dml is used for, Why DML is used for? DML is used to Manipulation and...

Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed

Define the terms entity set and relationship set, Define the terms i) Entit...

Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

Wait-die scheme -deadlock prevention, Wait-die" scheme : The idea is based ...

Wait-die" scheme : The idea is based on non-preventive method. It is based on a simple rule:                                 If Ti requests a database resource that is held by T

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