I think someone mentioned this analogy but, think of a flat file database as a single box of index cards. You can sort them, you can search through them, but there's a lot of duplicated information. This is fine if you only have a few things to worry about. To use Johannes' example, say you store the name and address of the person who's borrowing a particular set of parts. If her address changes, you'll have to change each card that the borrower is associated with.

A relational database could be described as numerous boxes of index cards, sitting on a desk. You'd have a box of cards for borrowers, a box of cards for the scores, and maybe even a box for the parts. You then have a spot on each card to "relate" the borrower to a part. For example, say I'm borrower #10110. Instead of entering all my information on each card I borrow, you simply write 10110. If I move, you only change card 10110 in the box of borrower cards.



On Aug 19, 2008, at 10:09 PM, John Howell wrote:

Could we define our terms for the non-experts here? What the heck is a"flat database," and why do you say (in another message) that FMP is one when David says it is something else?

_______________________________________________
Finale mailing list
[email protected]
http://lists.shsu.edu/mailman/listinfo/finale

Reply via email to