Database Design
- From: Sue Wilkes <SueWilkes@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 24 Feb 2008 15:46:01 -0800
I am trying to create a database for dog show entries from which the base
database can be used for many shows. There is usually only one entry form
which have the following details.
Name of Owner/s
Address
Postcode
Telephone Number
Email Address
Appear in Catalogue
Registered Name of Dog (multiple dogs may be entered on the same form)
Breed
Sex
Date of Birth
Breeder
Sire
Dam
Class/es to be entered (their can be multiple entries for the same dog)
First Entry Cost - always £2.00
Subsequent Entries with the same dog (50p each)
Not for Competition - if selected always £1.00
Membership - if selected - Single £1.00, Joint £1.50, Family £2.50
Pre-Paid Catalogue - if selected - always £1.50
A total for all entries from the same form
I have created the following tables
TITLE (for use as a drop down box lookup for selection) Mr, Mrs, Miss, Ms,
Other (to be entered)
SEX (for use as a drop down box lookup for selection) Male, Female
CLASSES (for use as a drop down box lookup for selection) i.e. 1 AV Minor
Puppy Dog, 2 AV Minor Puppy Bitch, 3 AV Puppy Dog, 4 AV Puppy Bitch, 5
Veteran Dog or Bitch etc....
CONTACT DETAILS use entries of Title (as above) First Name, Surname, Address
details, telephone number, email address, appear in catalogue (as a Yes/No
option)
DOG DETAILS (for each dog entered) Registered Name, Breed, Sex (as above),
Date of Birth, Breeder, Sire, Dam, Class/es entered for each dog (as above).
I would now like to build a form for data entry that places all the data in
a single table (is this the best way? and how do I create a form from many
tables?) the table will be required for running query forms and hard copy
reporting. What would be the best way to ID each record so it has a unique
number.
Sorry for some many questions but I feel the next step is critical in making
the database work effectivley.
Many thanks from this Newbie
.
- Prev by Date: Re: Backup utilitiy?
- Next by Date: Primary Key & Data Entry Forms
- Previous by thread: Re: Scholarship database setup
- Next by thread: Primary Key & Data Entry Forms
- Index(es):
Relevant Pages
|
