[thelist] Database Design

[Dominik Wee]

Hi Derry,

If you have access to an Enterprise Version of Visio 2000 you might try
to use that for ER-modelling. It let's you engineer the database in the
way it is meant to be done, i.e. working from the visual model to the
table descriptions and not the other way around (which happens when you
use Access). I use it myself for SQL-Server and it works very well, up
to automatically scripting the DDL. Though you might need to process the
DDL to make it understandable by mySQL.

Cheers,

Dominik

-----Original Message-----
From: Derry Talvainn [mailto:artema at artema.com.au]
Sent: 06 August 2001 02:20
To: Thelist
Subject: [thelist] Database Design


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 !