Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
talasabz
Starting Member
11 Posts |
 Posted - 2002-08-27 : 15:40:16
|
| Hi All,I need the following details for my website..do i need to join them all in one table?or am i applying the rules of normalisations here?many thanks----------Pet DetailsPet#,User#, pic, petype, petbreed, pet_dob, datePosted.--------------------------Pets Rehomedpet#, pet_perm#, name, petcolour, age, p_size, personality, allergies, microshipped--------------------------Pets for salepet#, sale#, number_pets, gender, price, additional details. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-27 : 16:38:48
|
| With just a brief look at the info you've provided, it looks like the fields listed under Pets Rehomed all describe the pet (except perhaps microshipped, whatever that is) so they should probably be in the Pet table (or perhaps a 1-to-many Pet Attribut table). However the fields listed under Pets for sale seem to apply mostly to the sale and not to the pet specifically, so those probably should be their own table. |
 |
|
|
|
|
|
|
|
Do I join them ? or leave them like this?