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

Define deadlock avoidance, Define Deadlock avoidance These protocols a...

Define Deadlock avoidance These protocols as well ensure that the system will never enter a deadlock state although the way it is done is different from deadlock prevention. I

Built online transaction processing, Question: A DBMS built for Online ...

Question: A DBMS built for Online Transaction Processing (OLTP) is generally regarded as unsuitable for data warehousing. Each system is designed with a different set of requir

Define null values, Define null values. In some cases a certain entity ...

Define null values. In some cases a certain entity may not have an applicable value for an attribute or if we do not know the value of an attribute for a certain entity. In the

What is called an evaluation primitive, What is called an evaluation primit...

What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.

Explain generalization and aggregation in e_r diagram, Explain the concept ...

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

Explain what is aggregation, Explain what is Aggregation? Aggregation:...

Explain what is Aggregation? Aggregation: Aggregation is an significant concept in database design whereas composite objects could be modelled during the design of database a

Whst is logical schema, Whst is logical schema ? Logical schema is the ...

Whst is logical schema ? Logical schema is the entire database.

Mention constraints to create command ddl, Mention the type of constraints ...

Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR

What is the meaning of recovery, What is the meaning of Recovery? In d...

What is the meaning of Recovery? In deferred update methods, if a transaction fails before arriving its commit point, it will not have altered the database in any way, so UNDO

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