zip, 36.88 KB
zip, 36.88 KB

Variable Length Record Modelling is an interactive macro-enabled spreadsheet model which allows learners to see how database records making use of a mixture of fixed and variable length fields are managed. Four different data schemas are provided and for each, the learner creates a test data record, enters how the data will be stored following the schema, and calculates how many bytes are required to store the record. The learner can then see which parts of the record stay the same as the data changes, which parts change, and how the space used changes.

As the learner enters their responses, the answers, if revealed, are hidden. Clicking the Reveal button shows the record format and number of bytes used.

The learner can switch between four tabs - each containing a different data schema.

NOTE: for this spreadsheet to work correctly, the copy of Excel in which it is running must allow macros to execute, and ‘Enable Content’ must be clicked when the spreadsheet is opened.

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.