This paper describes a universal technique for data retrieval from a database file afflicted with repeating groups. The procedure relies on a generic "repeater" table which is joined to the unnormalized table. Though the physical data model may violate first normal form, the proposed technique produces a data view that overcomes that violation. The importance of this technique to the design and use of databases is demonstrated through an actual case study.
All Science Journal Classification (ASJC) codes
- Information Systems
- Hardware and Architecture