|
talasabz
Starting Member
11 Posts |
 Posted - 2002-07-23 : 07:26:40
|
| Hi again, Wouldnt the table customer and the table Organisation be offering reppetitive fields? are they supposed to be combined? even though the customer as well as the organisation will be posting ads for pets. Does this also mean I have to join the customer table with the pets table using a key# such as pets# + customer#?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 |
|
normalising these tables!!