Write the pseudocode to format the data for the report in the generic case.

You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has a variable amount of columns and a variable amount of rows. The goal is to produce a display which is user friendly from a typical browser screen.

For example, consider a system for a gift wishlist. The main object is a person and different categories of items are stored in separate tables (movies, books, clothing, etc.) and has columns specific to that category of item. So the movies table might have columns like title, format, language, etc. But certainly the clothing table would have a different set of columns. A given person might have 0 or more items from any category on their wishlist. This report would show all the items on a given person's wishlist, and display all columns for each category.
Write the pseudocode to format the data for the report in the generic case (do not use the example above). What aspects of the implementation will make it most usable for the analysts who will need to reference this data every day to validate client inquiries?

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions