Member Avatar for bubblellicious

Hi everyone, that's my first post in these MySQL forums :) In college they gave us a E/R in order to make it on MySQL Workbench and I'm not sure if it is OK. If you could help me it'd be great :D Because I started with MySQL just a few days ago...

All this is about a league of soccer since here in Spain we love soccer so much.

Here's the picture of the E/R model:
http://img39.imageshack.us/img39/7931/shotc.png

And here the file I created with MySQL workbench:
http://www.mediafire.com/?cniuw0dzlkl

I'm sure you will realize if that's correct or not in a few secs but I'm still a n00b in MySQL subjects... I hope I'm not abusing of you, but that's only the question I've got *¬* My main problems are the foreign keys and all that stuff.

Cheers from Spain, bubblellicious.

  • 2 Contributors
  • 1 Reply
  • 171 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by qualitybrains
Member Avatar for qualitybrains

Hey bubblellicious ! This E/R model is not incorrect. You just need to drill down a bit and understand it. This is the most simple form of E/R. You will need to define the primary/foreign keys on your own, based on the relations Model (1:1, 1:N etc).

Thanks
Vivi
[First, solve the problem. Then, write the code]

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.