[thelist] Database Design

[Andy Osborne]

Take a look @ beginning java objects - they go through a Student/course 
registration system

Andy

>From: "Derry Talvainn" <artema at artema.com.au>
>Reply-To: thelist at lists.evolt.org
>To: "Thelist" <thelist at lists.evolt.org>
>Subject: [thelist] Database Design
>Date: Mon, 6 Aug 2001 11:19:40 +1000
>
>I am trying to design a database for a website that will be used to view
>information about Training Short Courses and to take bookings for the said
>courses.
>
>Hi all,
>
>I am in the process of designing a database that is far more complex than
>anything I have ever attempted before.
>
>I have put together some tables and their relationships in Access (although
>the final database is to be designed in mySQL) and saved out a snapshot and
>am hoping someone out there could give me some advice (I can send the
>snapshot file to anyone who would like to see the design, but appreciate
>that 'the list' does not take attachments).
>
>The website will allow clients to come on to the site, view courses, 
>details
>and descriptions of courses, a course schedule for times and dates when the
>courses will be run and also show what training organisation is holding the
>course (as a variety of training centres will be involved - not just one).
>Clients will then be able to make a booking for a course if they desire.
>
>I have been reading 'Database Design for Mere Mortals' as the basis for my
>attempt. I haven't got a handle on 'Sub Tables' and  putting the Course ID
>as the primary key in a wide range of tables and all set to autonumber
>doesn't work. Am wondering how to set that up correctly.
>
>Or if I have managed to set anything up correctly!
>
>Any advice greatly appreciated.
>Derry Talvainn
>Artema Interactive Design
>
>The only way to discover the limits of the possible is to go beyond them
>into the impossible - Arthur C Clarke
>
>
>
>
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp