View Single Post
  #1  
Old June 6th, 2010, 11:23 AM posted to microsoft.public.access.tablesdbdesign
jase118 via AccessMonster.com
external usenet poster
 
Posts: 3
Default i have a good 'schema, where do i go from here?

Hi, I have used this and many other forums to develop what i believe is a
good table layout and have established my relevant relationships between the
tables.
My knowledge of Access is limited (i have built DB's but a long time ago).
I am now trying to build the second phase of my database, the queries.
My DB is a water sports booking system and we are run on a low budget so i
can not afford to get this done professionally.
The functionality i need is to:
Add/remove Courses
Add/remove Sessions to the courses (a course may run 5 sessions a year)
Add/remove members to each course

I require a lot more functions down the line but this is the basics of my DB.
I am not sure were to start with bringing all the tables together to get the
desired results.
This is my table layout:
tblMembers
-pkMembersID
-txtFirstName
-txtLastName
-fkRank
-txtNumber
-txtAddress1
-txtAddress2
-txtCity
-txtCounty
-txtPostcode
-txtMil
-txtTel
-txtMobile
-txtEmail
-ActivInd

tblRank
-pkRankID
-txtRank

tblCourses
-pkCourseID (1 to many link to fkCourseID)
-fkCourseType
-numMax (maximum places available on the course)
-curPrice
-logIsAvailable

tblCourseType
-pkCourseTypeID (1 to many link to fkCourseType)
-txtCourseType

tblSessions
-pkSessionID (1 to many link to fksessionID)
-dteStartDate (session start date)
-dteEndDate (session end date)
-fkCourseID

tblSessionMembers
-pkSessionMembersID (1 to many link to fkMembersID)
-fkSessionID
-fkMembersID
-logPaid
-logInstructionsSent
-numPlacesRequired

Where do i go from here?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201006/1