![]() Topic awaiting preservation: database architecture (Page 1 of 1) |
|
---|---|
Bipolar (III) Inmate From: New York City |
![]() OK. I have been contracted by a client to build a database for his website. My client makes a product > sells to dealers in US > dealers sell directly to customers. Purpose of dbase is to allow customers to search for dealers that sell product in their area. Client is interested in ability to search by zip code or by state. The host he currently uses has MySQL functionality- with a GUI interface built in PHP- called PhpMyAdmin. From this GUI interface I can execute MySQL commands. I am not very familiar with MySQL but willing to learn and the interface will definitely make it easier verses coding from a command line. |
Bipolar (III) Inmate From: |
![]() I would organize the table by dealer! |
Bipolar (III) Inmate From: New York City |
![]() Ahh. I see. |
Bipolar (III) Inmate From: |
![]() I could be wrong (I'm no db expert) but I think 'secondary key' is a generic term for all those fields which aren't primary keys. |
Bipolar (III) Inmate From: New York City |
![]() gracias |
Maniac (V) Mad Scientist From: 100101010011 <-- right about here |
![]() key's create indexes for increased performance. They speed up searches by marking what data is needed for the search most often. |
Paranoid (IV) Inmate From: Den Haag, Netherlands |
![]() As far as I can remember, the principal difference between a primary and a secondary index is that the primary index must contain a unique value for each record, whereas a secondary index is allowed to contain duplicate entries. |
Bipolar (III) Inmate From: Picton, Ontario, Canada |
![]() I'd recommend going to PHPBuilder.com and checking out their articles on database normalization. |
Bipolar (III) Inmate From: New York City |
![]() Been away for bit. Thanks for the response. |