0

I have attached a diagram I got it from here only...My question is: How do I convert that to a table form and how do I add relationships between tables according to the diagram? Any samples will be a great help! ER-Model

DrColossos
  • 12,656
  • 3
  • 46
  • 67
limo
  • 225
  • 5
  • 12
  • 1
    What tool generated the diagram? Most of these things should also be able to generate the needed SQL. – Charles Mar 12 '11 at 05:41
  • 3
    An explanation of database design principles is beyond what SO is designed for. If you have no idea how to approach this problem you need more help than you are going to get here. – Jim Garrison Mar 12 '11 at 05:42

1 Answers1

2

I suggest reading the Wikipedia article on ER-diagrams (your graphic is called an Entity-Relationship diagramm)

And as Jim Garrison said in the comment

An explanation of database design principles is beyond what SO is designed for.

If you have some experience with databases, the Wikipedia article may help you. If you still need to create a database (is this homework??), take a look at tools to assist you. Otherwise, make yourself familiar with the principles of DB design.

Community
  • 1
  • 1
DrColossos
  • 12,656
  • 3
  • 46
  • 67