Database Design

1
Database Design

• Shortcuts

2
Whats your problem?

• Sort out the basic idea for the Databasee.g.
  Your local Angling Club is looking to set up a
  Database to manage their Membership Match
  information.

3
Identify the basic elements

• Hold the list of Members
• Manage the renewal of Memberships
• Hold a list of their Venues
• Hold the list of Annual Matches
• Manage the booking of Matches

4
Be a bit more specific !

• Membership list
• Add new Members
• Review /or update Member details
• Allocate new Membership IDs
• Track log the renewal of Memberships

5
And more specific !!

• Add new Member
• Check existing Membership
• Enter new Member details
• Store details in the Members Table
• Generate Issue new Membership ID
• Issue Membership Card

6
Do a diagram
Name, Address, Phone, Date joined, etc
Add a New Member
Store details in Members Table
Issue new Membership ID
(ID, Name, Address, Phone, Date joined, etc)
Membership ID
7
Repeat, repeat, repeat

• Repeat the process for each of the elements
  identified.
• Add more detail where necessary.

8
What Tables ??

• Identify the Tables you need
• tblMembers For the Membership List
• tblMatches Lists Match details
• tblVenues Where we fish
• tblBookings Link Members to Matches and their
  Venues

9
List you Fields

• Fieldnames
• Data Types
• Key Fields
• Formats

10
And Normalise

• Split Fields into appropriate Tables
• No duplication of Data!!
• Dont over-do-it!
• Identify the Relationships

11
Do a Diagram
tblMatches MatchNo VenueID Date Swims Etc
tblMembers MembershipID DateJoined Title FirstName
LastName Etc
tblMatchBookings BookingID MembershipID MatchNo Ve
nueID Date StartTime Fee Etc
tblVenues VenueID Name Location Type Etc
12
Check back with Specs

• Link Design to Specifications
• Does it do what was intended?
• Is the client happy?
• Do the Specs need revising?
• Could someone implement your Design?
• Move to Implementation