Hi guys,
I was searching for a software with wich you can design databases,
and I wanted a tool that directly puts this database with fkeys etc, in a sql code to create a database or just in an XML document or something like this so that it would be easy to make changes in the Grafic-model parallel to the actual Model.

I'm not sure if something like this exists but it would be great, does anyone knows something about the existence of such a tool,
if possible it should be a tool with demo available.

And I'd like to have an design with 2 sides relationship naming
an relationship should look like this (just sketch)

participates in
Student ---------------------------------------- Course
enrolled by
I appreciate all answers

hey

ive been using DBDesigner4 http://www.fabforce.net/

im new to all this really, so perhaps theres better out there, should do everything youve requested though.

In SQL Server 2000, create your schema in Enterprise Manager, then script all your objects, Primary & Foreign keys, Indexes, etc. (Tools / Generate SQL Script)

Check out

http://www.datamodel.org/

it might point you to a product. There are many more.