Hi, I have a database of users (Clients, Admin, and workers), but I need to
split these into different tables so that I can open remote links to external
servers. Does anyone know of a template to guide me in the right direction as
I am a complete novice but need to learn how to do this?
There's really no "one size fits all" template, since all data is different, and business needs are also different. In
general, try to model your data after real-life entities. You appear to be dealing with a list of People, so you might
need only to add a column to your table to indicate the Type of person, and not break out the data into separate tables.
If, however, you need to store different information about Clients than you do about Workers, then each would need their
separate tables.
There are plenty of books on Relational Database design; one of the better ones is Database Desing for Mere Mortals by
micheal Hernandez. WROX has published one titled Beginning Database Design; I've never read or used it, but have always
been pleased with WROX publications.
There are also many sites that explain the ins-and-outs of relational design; search on "relational database design" or
"relational database theory" for more reading than you really want.
