GeekInterview.com
Series: Subject: Topic:
Question: 53 of 92

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?
Asked by: Interview Candidate | Asked on: May 24th, 2007

This Question is not yet answered!

Related Open Questions

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Btrieve Interview Questions

Clipper Interview Questions

Database Admin Interview Questions

Firebird Interview Questions

Informix Interview Questions

Microsoft Access Interview Questions

MYSQL Interview Questions

PostgreSQL Interview Questions

Progress Interview Questions

SAP DB Interview Questions

SQL Interview Questions

SQL Server Interview Questions

Stored Procedures Interview Questions

Sybase Interview Questions

Teradata Interview Questions

Unify Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.