| Author |
Topic |
|
talasabz
Starting Member
11 Posts |
 Posted - 2002-07-12 : 18:29:42
|
| here is the database... any ideas how i can make it better? Customer table: Customerid, C.name, C.address1, C.address2, C.postCode, C.country, UKlocation, C.Hphone, C.Mphone, C.e-mail, (rehoming-services? yes/no) Organisation details: Orgid, Org.name, Org.address1, Org.address2, Org.postcode, Org.country Org.Phone, Org.Fax, Org.Email, Org.website, Org.AreaCoverd, Org.activities, Org.addinfo, Org.Logo Members of Org details: MemberId, OrgId, Member_name, Member_email, member_Phone, member_ext. Pets table: OR PetId, (OrgId, CustomerId), p.NAME, P.type, p.breed, p.color, p.d_o_b, p.size, p.personality1, p.personality2, p.personalty3, p.vaccination, p. allergies, pic. pets for sale: Petid, saleID, no.ofMales, PriceperMale, No.ofFemales, PriceperFemale, ps: i do have a feeling that the organisation and the owner tables should be combined... repettitive fields are not so good in database design..;(((( |
|
|
msrviking
Starting Member
7 Posts |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-07-17 : 20:27:17
|
quote:
ps: i do have a feeling that the organisation and the owner tables should be combined... repettitive fields are not so good in database design..;((((
What is the owner table? Is that the one you labeled as Customer? If Owners might belong to an Organisation, then NO do not combine them. If Organisations are just a special type of Owner then go ahead and combine them, but add a flag for which are Orgs. Just because two tables both have an Address field does not necessarily mean they should be combined. You seem to have more fields for Org than for Customer, so I'd question whether they're really the same sort of entity. |
 |
|
|
talasabz
Starting Member
11 Posts |
Posted - 2002-07-23 : 07:22:16
|
| Hi again, I made a few changes to the tables.. do they look any better now? Thanks again:) -------------------------------------- Customer Table: Customer#, C_Fname, C_Lname, C.address1, C.address2, C.postCode, C.fax C.country, UKlocation, C.Hphone, C.Mphone, C.e-mail, (rehoming- services? yes/no) Organisation Table: Org#, OrgName, OrgAdd1, Orgadd2, Org_postcode, Org_Fax, Org.website, Org.AreaCoverd, Org.activities, Org.addinfo, Org.Logo, contact_Name, Contact_e-mail, Contact_phone, Contact_Ext. Host Table customer#, host#, animals accepted?, max_no_days, price_per_day Pets Table: pet#, picture, p_type, p_breed, p.d_o_b Permenant pets for rehoming pet#, pet_perm#, name, p.color, age, p.size, p.personality1, p.personality2, p.personalty3, p.vaccination, p. allergies, microchipped. pets for sale: Pet#, sale#, number_pets, gender, price, additional details.Text |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Normalisation??