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

Database recovery and security, Database Recovery And Security Introdu...

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

Intersection, If R1 and R2 are two union compatible relations or functions,...

If R1 and R2 are two union compatible relations or functions, then the result of R3 = R1 ∩R2 is the relation that contains all tuples that are in both the relations In other words,

Cartesian product, If R1 and R2 are two relations or functions, then the re...

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

01a_ImportCasting.xlsx, 01a_Broadway_LastFirst_yyyy-mm-dd Capstone Exercise...

01a_Broadway_LastFirst_yyyy-mm-dd Capstone Exercises You work as a production assistant in the office of the Green Man Theatre. One of your duties is to maintain the company datab

Develop database academic assignment, Develop Database academic assignment ...

Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

Mention the purpose of sid and sod lines, Mention the purpose of SID and SO...

Mention the purpose of SID and SOD lines SID (Serial input data line): It is an input line by which the microprocessor accepts serial data. SOD (Serial output data line)

What is trigger, What is Trigger? Trigger: A database trigger is proced...

What is Trigger? Trigger: A database trigger is procedural code which is automatically executed in response to specific events on a particular table in a database. Triggers can

Difference between a composite key and attribute, Question: (a) Discuss...

Question: (a) Discuss the difference between a composite key and a composite attribute. How would each be indicated in an E-R diagram? Support your answer with appropriate exam

What are the advantages of object oriented databases, What are the advantag...

What are the advantages of object oriented databases in comparison with others? Why it is still not widely used? Object oriented designs are coherent, efficient and less prone

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