I am trying to model relationship between 2 tables Orders and OrderDetails. I draw "relationship" arrow from OrderDetails to Orders table with Foreign key OrderID. But in DatabaseProperties for relationship arrow, I get unknown parent and unknown child. How do I connect the 2 tables with relationship arrow properly. ...
Hey guys, I just downloaded Mysql Workbench and noticed they use the term EER Diagram? I thought that Entity Relationship diagram were a conceptual representation of data (Conceptual schema), a bit like this: http://www.ncgia.ucsb.edu/giscc/units/u045/figures/figure1.jpg I mean, Mysql Workbench's Diagrams have tables with foreign keys a...
I have no problem with converting ER to SQL tables, but I don't know how can I convert EER to SQL tables? as you Know that EER has "is a" specification and inheritance, but I don't know how relational databases can connect with inheritance specification ...
Hello, I have approval to buy one tool which can help programmers of my team to write better code. Most of my team members either do UML (.NET developers) or they do ER (database developers) Can you please recommend a tool for me which can do both of these type of diagrams? Please don't recommend Visio because my team already evaluat...
in chen's notation partial keys (discriminator) were shown as dashed lines, how are they shown in uml er (entity-relationship) diagram? ...
Hi, I'm a little confused, I'm developing a program, the program consist in two parts, the server and the clients, there are groups, places, messages... stored in the server, and the clients has to connect with it. I've design the use cases diagram, the activity diagrams, and I have design the class diagram too. The thing is that I want...
Hello. Somehow I can't figure out how to implement the following relations using Doctrine 2 syntax: I have Items and Shops. Each item has different price and different quantity at each shop. So, I have Items table, Shops table and ItemsAtShops table. How do I reflect the last one in Doctrine? I guess I need to create ItemsAtShops enti...
a supplier located in only one city supplies various parts for the projects to different companies located in various cities.Draw ER diagram for this scenario. Thanks. ...