MobileRead Forums - View Single Post - Database: custom_columns: What is 'normalized'?

theducks · 12-18-2022, 08:03 PM

Many years ago Borland's Paradox DOS had an example
An Airline ticket with multiple stops.

There was the Passenger Table with all the info (tel, charge method...)
There was the Ticket (parent) issued to Passenger

There was the Hop table that had an entry for each hop Linked to the ticket. there was no limit on how many hops
There was a schedule table that detailed Flights to flesh out the hop details
All the tables were really narrow (few columns)

12-18-2022, 08:03 PM	#5
theducks Well trained by Cats Posts: 31,086 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Many years ago Borland's Paradox DOS had an example An Airline ticket with multiple stops. There was the Passenger Table with all the info (tel, charge method...) There was the Ticket (parent) issued to Passenger There was the Hop table that had an entry for each hop Linked to the ticket. there was no limit on how many hops There was a schedule table that detailed Flights to flesh out the hop details All the tables were really narrow (few columns)