Create a file of fixed length records from the data provided

Assignment Help Other Subject

Reference no: EM132767061

Assignment: Objective: You are to implement a simple database using a sorted file of fixed length records. The data that you are to use for testing is in file: Parks.csv Windows compatible (cr lf). This data contains the visitation records for the US National Parks from 1904 to 2016.. The goal of this assignment is to understand and practice using file management techniques to implement a database system. Your file-based database needs to handle overflow by writing records to an overflow file that contains unsorted records.

First, create a file of fixed length records from the data provided interleaved with blank records. Your file should create space for insertions by writing one blank record between each real record. Meta-information should be stored in a non-fixed length way in a separate configuration file, e.g., "Parks.config". The config file must also store useful data like the names of the fields (for display), the number of records, and anything else you would want to add.

So, the initial file will have 764 records, half of which are blank. When a record is inserted, the file is searched (using binary search) to find the correct location. If there is a blank record where the new record needs to go, then the blank record is simply overwritten. However, if there is no empty record available in the correct location, the original file should be re-written with new blanks inserted, including after the new record. For example, if we do 3 inserts into blank records, we would now have 385 real records in our file of 764 total records. If the next insert fails, we would create a new file with 770 total records in it (the 385 real records, each with one blank record after it).

You must not read the whole data file into memory at a time

Program Description

Create a program which offers the user the following menu of operations:

1) Create new database

2) Open database

3) Close database

4) Display record

5) Update record

6) Create report

7) Add record

8) Delete record

9) Quit

Reference no: EM132767061

Questions Cloud

Discuss the sierpinski gasket : This week's discussion has introduced working with graphics programming, particularly with respect to primitives and attributes. One of these applications.

What would be hope finished goods inventory cost : What would be Hope's finished goods inventory cost under the variable (direct) costing method at December 31, 2015

Example of very poorly implemented database : Describe an example of a very poorly implemented database that you've encountered that illustrates the potential for really messing things up.

What amount should be reported as dividend income : Homer Company when the quoted market price of Homer's ordinary share was P10. What amount should be reported as dividend income for 2018?

Create a file of fixed length records from the data provided : First, create a file of fixed length records from the data provided interleaved with blank records. Your file should create space for insertions by writing one.

Validate the correctness of security controls : A comparison of existing security controls and settings with one or more baselines helps to validate the correctness of security controls.

Identify total of two principles or rules that are relevant : Identify a total of two principles or rules that are relevant to the accounting policy issue, stating the source (such as an Accounting Standard)

Indicate the minimum taxable benefit : Ignore all GST/PST/HST implications. Indicate the minimum taxable benefit that would be allocated to Ms. Smith in each of the following Cases

Expectations regarding the various skills : Discuss your views and expectations regarding the various skills both technical and non-technical that a CIO should possess in order to effectively

User Account

All Pages