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.
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