Question Locked

I want to learn how to design a database, how do I start

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I will like to know how to design a database

9 replies

by purpleskys

what software are you going to use? Access, oracle, etc? then find some tutorials on it and read

by tobif

Try to imagine for yourself, what you could use your new database for.
How would you model the reality you want to describe?
What relationships?
What features would help you to make your system useful?
Etc.

by santeewelding

If this database serves as the algorithm of existence: screw up the relationships and the model makes life hell for everyone.

by ansugisalas

it could make carbon dioxide gas spontaneously congeal into diamonds.
And maybe they could be really really big diamonds, and they could fall on top of people I hate from very very high up in the air.
O - How I would laugh.
And then collect, wipe, sell.
And then I would laugh more. Much more.
But maybe that's what you meant?

by tony hopkinson

Get a book/course/tutorial on database theory.

Learn the fundameantals.
Nullability, normalisation, relations.
Then pick a tool (my pick would be sql server express 2008 (free from ms)).
Choose what you want to design a database for and apply the fundamentals with it.
If you really want to learn it, do not start with the graphical tools. Do it in SQL.

If you are stuck for a starter example
Orders, Customers and invoices is nice and the classic hospital, patients and beds is a lot of fun.

Can a patient be in two beds?
Can one bed have two patients?
Can the bed switch wards?

Or change can to should or would?

Ah memories...

by brian

well technically speeking, a bed can have two patients ;) lol however yes, the fun memories that come back when i was trying to learn sql (though i am still not very strong but getting better :) ) On a suggestive side however, check out w3schools.com...there are some nice starter tutorials there for sql and it helped me start out, since then i have gotten more and more advanced, however i don't think i will EVER get the cross joins right lol...

by tony hopkinson

not dragging arrows about on a GUI.

I'm always forgeting join syntax. It's not what I'd call intuititive. As long as you know it's there, F1 and Google will rescue you.

The real trick is to realise that a table is no more a rectangular array of cells than it is a piece of furniture.

This discussion is closed to new replies.