Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Your Answer


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.