Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have developed an ERD diagram with UML notation in StarUML.

Now, I need to draw a relational schema but due to lack of features in StarUML i must use other tool.

My question is what exactly goes into a relational schema and can someone recommend me a good tool. Visio? but I would have to redraw the whole thing again.

Seems like starUML allows me to export XMI 1.1 for UML 1.3 and XMI 1.1 for UML 1.3 rose extended, i dont understand what these mean or their purpose, perhaps I can import the xmi into other tool? please advise.

Here is my ERD.

Entity relationship diagram

The following is what i am being asked to do next;

A relational schema of your database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys and which attributes are nullable, giving reasons. List any assumptions you need to make

Thanks for your time

share|improve this question
Chances are you won't be able to export it into a non UML-based tool. Visio will let you build an E-R model but you will probably have to re-build it. Alternatively you could write a SQL script that creates the tables in a database and reverse-engineer the database back into Visio. It's not clear if you're required to actually build a set of create table statements for your assignment, though. – ConcernedOfTunbridgeWells Mar 13 '12 at 8:01
What about other flavours constraints (non-primary candidate keys, value range checking, etc?) This is a problem with modelling i.e. it omits numerous constraints. Also you should be aiming for a fully normalized database i.e. at least 5NF. I suggest you go back to the designer and ask them to give good reasons for their explicitly limited requirements. – onedaywhen Mar 13 '12 at 10:51
closing due to lack of response - without further information this is probably not answerable – Jack Douglas♦ Sep 11 '12 at 13:27

closed as not a real question by Jack Douglas♦ Sep 11 '12 at 13:27

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.