Database Design: Normalize Repeating Fields

Database Tips: Normalize Repeating Fields

Formal database design techniques can be described under the general heading of “database normalization.” Good database designers either follow “3rd Normal” database form or break the rules for very important reasons.

One of these normalization rules is to remove repeating fields. If you design your customer table with fields for postal address and delivery address, you have limited your application to only two alternate address values.

A more flexible design would create an address table to allow for companies with more than one postal or delivery address. You could also include other address record types in the system.

An example of a too-rigid design is an insurance claims table developed in MS Access. The original table had fields for four payment dates and amounts. Within a month, this had expanded to six fields. When we saw it six months, the table was being used with multiple records to cover those transactions with more than six values. A more flexible approach would have been to have a payments table with a record for each payment. That would efficiently handle any number of transactions.

Have a look at your table design. Are there any repeating fields that would work better in a subsidiary table?

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.

And then there's the powerful project management part....

Improve Project Management

Generate summary and detailed documentation.
Analyze report complexity metrics to assist with test plan development and maintenance planning.
Easy to use documentation explorer to browse and compare report design settings.
Print report design diagrams.
Print report data dictionaries.
Extensive formula printouts including call trees, object cross references, formatted listing, and conditional formulas.
All documentation can be exported in a variety of formats including PDF, HTML and Word.
Uses Crystal Reports to produce the documentation, enabling complete customization
Plus more!

For pricing and/or purchase, click here.

"Report Analyzer does it all. This is the best Crystal Reports 3rd party application on the market today! The numerous features combined with great performance makes Report Analyzer the ultimate documentation and analysis tool." -- Brian Kuipers, CrystalInfo.Net, USA

Report Analyzer is the ultimate documentation and analysis tool for Crystal Reports users and developers. With a comprehensive library of analysis and documentation reports, Report Analyzer provides you with complete documentation, analysis, and performance suggestions for your Crystal Reports projects. Keep your investment in Crystal Technology at its best performance using Report Analyzer!

How does Report Analyzer Work?

Report Analyzer connects to your local Crystal Reports or Crystal Enterprise APS servers and imports their design definition into a documentation database. These imported reports are organized into documentation groups within the database to organize your information for easy referencing and reporting.

How can Report Analyzer help you?

Report Analyzer now comes in two editions - Standard and Enterprise (click here for Enterprise features).
Both editions of Report Analyzer assist with:

Comprehensive report analysis

Reducing maintenance effort

Performance/design tuning

Change management

Test plan development

Extensive documentation

Improve report performance

Report Analyzer automatically detects potential performance issues in your report design settings, including record selection formulas, grouping options and database options.

Automatically detect reports that do not take advantage of server side database processing.

Detect record selection formulas that use data type conversion functions.

Detect group fields that use formulas instead of SQL Expression fields.

Find report tables which use less than an optimal number of fields.

Discover special fields which cause an additional pass over the report data source.

Improve report reliability and maintenance

Speed development and maintenance

You can easily view dependencies between report objects such as formulas, SQL expression fields, parameters, and database fields with the dependency viewer. Additionally, the powerful query feature lets you view dependency information across reporting projects.

View report designs in a design window similar to the one in the Crystal Reports designer program.

Select design objects and view/print settings, formula code (including conditional formatting formulas), dependencies with other design objects, and call stacks (for formulas only).

Use interactive diagrams (trees) of formula hierarchies, object dependencies and report design elements.

Click to enlarge

Query and print over 600 report settings across all documented reports. Perform instant impact assessment for database changes and formula changes across all documented reports.

Locate which reports use specific functions, parameters, and design settings.

Project Management

Report Analyzer generates comprehensive documentation of your reports, with over 100 presentation quality reports. Complexity metrics assist with test case planning and maintenance estimates.

Generate summary and detailed documentation.

Analyze report complexity metrics to assist with test plan development and maintenance planning.

Easy to use documentation explorer to browse and compare report design settings.

Print report design diagrams.

Print report data dictionaries.

Extensive formula printouts including call trees, object cross references, formatted listing, and conditional formulas.

All documentation can be exported in a variety of formats including PDF, HTML and Word.

Uses Crystal Reports to produce the documentation, enabling complete customization.

Plus more!