Philipp Post wrote:
>> Does anyone have some suggestions about good resources that could help
guide me in designing the structure of the databases? <
>
> Database Design For Mere-Mortals by Michael Hernandez is a good start
> to get into this.
Oh, I didn't read it, but I flipped through it and saw this in chapter 8:
> Note
>
> I commonly create an ID field (such as EMPLOYEE ID, VENDOR ID,
DEPARTMENT ID, CATEGORY ID, and so on) and use it as an artificial
candidate key. It always conforms to the Elements of a Candidate Key,
makes a great primary key (eventually), and, as you'll see in Chapter 10,
makes the process of establi****ng table relation****ps much easier.
If that is how he constructs his other examples, his POV greatly limits
the scope of the book. I would not recommend it.
tongue-in-cheek reference:
http://thedailywtf.com/Articles/A_Truly_ID-iotic_Design.aspx
|
