OpenEuphoria

Setting up a simple database using EDB

• Posted by Alex Caracatsanis <sunpsych at ncable.com.au> Jan 27, 2005
• 566 views

I need to create a database of CUSTOMERS. Each customer has a unique number -
ID - going sequentially from #0001 to #9999. We record the SURNAME, FORENAME,
MIDDLE_NAME, DATE_OF_BIRTH, ADDRESS, and TEL_NO.

Using EDS, I think it would be correct to make CUSTOMERS the TABLE - yes?
What should the KEY be? The ID sounds ideal, but then how do we search for 
customer Smith, John James; born 01/01/2005; at ADDRESS; etc... ?

Sometimes we need to find a particular ID (Eg: "Get the details for customer
#00345"). But usually we've forgotten his ID, and our question is "Get the
details for Smith - I forget his first name". Occasionally we're left a 
garbled message to ring TEL_NO xx xxxx xxxx. Our task then becomes "Get the
details for the customer with that number".

So what should be the KEY, and what should be the DATA, in a database that
will make it possible for us to find that customer using any of his details?
And what routine(s) will make that search possible?

Thank you

Alex Caracatsanis