Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've tried a couple database creation tools (MS SQL Server, MySQL Workbench, etc.) and I cannot figure out how to create a super-type relation (complete, disjoint). Below is an example of how it looks in crow's foot notation. Even a link to a tutorial would help a lot, as the subject states, I'm a total noob at SQL / Databases.

enter image description here

share|improve this question
    
I think you're going to have to give a bit more detail on what you're trying to do. It seems to me that you'd just create your three entities, then declare whichever fields are your foreign keys from D and E to B. –  DerfK Mar 1 '11 at 22:47
    
Maybe that's what I want to do... let me give the correct diagram –  Eric Fossum Mar 1 '11 at 22:53
add comment

1 Answer

up vote 1 down vote accepted

Hi a good start might actually be with an MS Access Database. If you are looking for a good graphical interpretation I think what you might want would be what they call relationships.

I would start with Access, and then move in to SQL server. While they differ in a lot of ways it could be a good stepping stone for you.

http://office.microsoft.com/en-us/access-help/create-edit-or-delete-a-relationship-HA010072597.aspx

You can also import/export from SQL to Access, but I wouldn't make that a habit due to the differences between the systems.

Otherwise there is a few tutorials over at the MySql Workbench website, the one by Djoni Darmawikarta was pretty good for beginners.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.