Database schemas (IT/Computing people?)

Big Red S

I've got to draw one, but while I've got a good idea of how I want the db to work, I can't remember much of the 'standard' way of laying it out.

Anyone know any good online tutorials?

<hr noshade size="1"><font size="1"> README
[url=mailto:avisforwardedemails@gmail.com?subject=MBUK Moderation]E-mail me if you think i've moderated something wrong[/url] (but don't change the subject or I won't get it)</font id="size1">

Crinion

Erm, dont know if its a good tutorial but it is a tutorial.

http://www.databaseanswers.org/tutorial ... /index.htm


www.grandmas-attic.co.uk

Big Red S

I've just been following that one, seems a bit, er, crap. It's doing more to confuse than confirm at the minute.

<hr noshade size="1"><font size="1"> README
[url=mailto:avisforwardedemails@gmail.com?subject=MBUK Moderation]E-mail me if you think i've moderated something wrong[/url] (but don't change the subject or I won't get it)</font id="size1">

majorbloodnock

Big Red S wrote:

I've got to draw one, but while I've got a good idea of how I want the db to work, I can't remember much of the 'standard' way of laying it out.

Anyone know any good online tutorials?

I don't suppose you've got access to Visio, have you? If so, that pretty much does it for you.

Basically, I'm guessing all you're wanting to do is detail the tables you want, which fields you want in each table, which field(s) in each table are used to create a unique reference for each record (i.e. the primary keys) and which fields in which tables contain common data (the relational links). If so, I'd forget any standards and simply lay that information out in the way that explains itself best. However, if you're referring to the term "schema" in its Oracle or SQL Server connotation (i.e. user ownership of objects), that's something completely different, and you might want to mail me so I can point you in the right direction.

Tartanyak

One question though Avi... Are you any good at database normalisation?