Topic: Hw to build a relational database on e-smith ?

[Arne]

I have been experimenting a bit building php applications with flat file databases in mysql. This works great.

Now I wondering how to take this a little bit further on to build relational databases based on normalising tabels and making entities. I did some training or some small work these things with Access and Oracle a few years ago so I think I remember some of the basic prinsiples. Also have the great book "sql for dummies".

How do I start up to make some relational database prototypes using Mysql ?

Could it be that Mysql is not the tool at all and that it will be neccessary change over to PostgreSQL ??

(But all those smart applications out there like Horde and phproject, they are using the mysql database as an relational database using entities, arent they ??)

I find it a little bit difficult to just get started with theese things. The really stranges thing, I think, is that I can not find anything about the relational database prinsiple and normalisation/entities in the mysql reference documentation.

Could the answer be so simple that Mysql doesen't have any automated prosedures for keeping track of relation models an entities at all, so you will have to organize it all like flat files and then keep track of all relational integrety manually by yourself and via the client and it's sql strings ?

Is this the right way to understand it ? I think if it were possibly to know "how to start thinking", it should also be possible to start making "something".

I would be

[Arne]

I found some info here, but I don't know if it made the whole picture much clearer:

http://www.dbforums.com/archives/t315848.html

[Charlie Brady]

Arne wrote:

> How do I start up to make some relational database prototypes
> using Mysql ?

Log into mysql, and start entering SQL commands.

> Could the answer be so simple that Mysql doesen't have any
> automated prosedures for keeping track of relation models an
> entities at all, so you will have to organize it all like flat
> files and then keep track of all relational integrety manually
> by yourself and via the client and it's sql strings ?

If you design your schema properly, then relational integrity is perforce maintained. That's the process called "normalization".

MySQL doesn't currently support "transaction", which might be what is bothering you.

See http://www.mysql.com for all MySQL specific documentation.

Charlie

[Gregory Baird]

Hello

take a look at

http://www.phptools4u.com/scripts/eskuel/?lang=english

it is easy to install and gives you alot insite on mysql

you will be able to create databases tables & access the data also

change database names tables

hope this helps

Greg