Stack Overflow
Stack Overflow

Questions tagged [eer-model]

The enhanced or extended entity–relationship (EER) model is a high-level or conceptual data model incorporating extensions to the original entity–relationship (ER) model, used in the design of databases.

The enhanced or extended entity–relationship (EER) model in computer science is a high-level or conceptual data model incorporating extensions to the original entity–relationship (ER) model, used in the design of databases.

It aims to reflect more precisely the properties and constraints that are found in more complex databases, such as in engineering design (CAD/CAM) or Geographic Information Systems (GIS).

59 questions
2
votes
2 answers

How do I go from a MySQLWorkbench EER model (ERD) to Django?

I designed a database using MySQLWorkbench EER model with many foreign key relationships and tables using Django default naming conventions (like using id for primary keys, *_id for foreign keys). Now that I feel that I have a good back-end design,…
hobbes3
  • 28,078
  • 24
  • 87
  • 116
2
votes
1 answer

MySQL Workbench EER diagram creation

There are two issues here regarding MySQL Workbench. Is there a way to update an existing EER diagram with newly created DB tables, so that the EER diagrams automatically reflects the new tables AND their relationships. OR Is there a way to auto…
andthereitgoes
  • 263
  • 1
  • 6
  • 15
2
votes
1 answer

EER Diagrams, different symbols?

Sometimes when I'm working with EER diagrams I see different symbols, for example, 'd', 'o', 'u' and so on. Like the 'd' here What do they mean and what are they used for? And how many variants do it exists?
BlommaN
  • 95
  • 1
  • 3
  • 8
2
votes
1 answer

How do I see the EER Model for an mySQL database I have created using DDL

I've created a new schema/database in DDL query thing in MySQL Work Bench. (I hope I explain myself well enough since I can't post images without 10 Rep apparently... Like the code below sort of stuff). CREATE DATABASE IF NOT EXISTS…
DevilsD
  • 545
  • 1
  • 5
  • 12
1
vote
1 answer

Best way of Django modeling

Currently we are working like this: Create an EER model using MySQL Workbench, involve at least one person to discuss Generate tables from EER model manage.py inspectdb to create models.py, edit models.py carefully as inspectdb does not work…
xu huanze
  • 269
  • 2
  • 9
1
vote
0 answers

Convert EER-Diagram/Generated Schema to ER Diagram

I'm working on a school project that requires the creation of an ER diagram and a database schema that is derived from that diagram. The schema has some very stringent size requirements (no more than x number of tables). I'm running into an issue…
Schmidget
  • 123
  • 1
  • 7
1
vote
1 answer

ER Modelling - Subclass relationships & Relationship Entities

I have a couple of specific questions regarding ER modelling. To provide some specific context, this is for a university project and I seem to not be able to hunt down specific answers to these questions. Background The ER model is depicting a…
Thomas Watson
  • 25
  • 7
1
vote
1 answer

How do you create a database in mySQL Workbench that you can connect to with php?

I am trying to create a blank database with mySQL Workbench that I can connect to with php. All this is on my local machine. Here's what I think you do. Click on Create New EER Model Create a new Physical Schemata Give it a name Save Model to…
Petras
  • 4,686
  • 14
  • 57
  • 89
1
vote
2 answers

EER mysql workbench diagram

I'm new to CakePHP & Mysql Workbench and i just did a reverse engineer to a a open source application built with cakephp(Croogo CMS). In order to better understand the relations between tables I'll like to draw them, but using the mysql workbench…
dole
  • 343
  • 2
  • 6
  • 23
1
vote
0 answers

SQL: How to model multiple n:m relations in ERM

I have a scenario where I have risks that can occur in many other Entities as in Organizational Units, as depicted in the image below. Is there a best practice for modeling in this scenario or is the modeling I have chosen a good practice?
Wolfgang
  • 66
  • 5
1
vote
1 answer

What is the difference in View and EER Diagram?

I quite confuse with both. First, both might seen the same. May I know how the View and EER Diagram is apply?
King
  • 237
  • 1
  • 6
  • 12
1
vote
0 answers

Extract ORMLite Database documentation and schema

Is there any way to view the ORMLite Database as schema and maybe a documentation for it with all the tables and columns? Or maybe can I do it with SQLite? Edit: I need to make a documentation about the database from my application, so is there are…
Mihai Gabriel Petrescu
  • 41
  • 7
1
vote
1 answer

Error 1005: Can't create table can't find where the issue is

I have created a EER model using MySQL Workbench (latest release). Apparently all is fine but when I try to do a FORWARD ENGINEER I get the common Error 1005: Can't create table. As suggested in this post I check every step on the first answer but…
ReynierPM
  • 17,594
  • 53
  • 193
  • 363
1
vote
1 answer

MySQL Workbench - All diagrams in EER Model update when working in single diagram

I've created an EER Model for a project and I have a couple diagrams inside the model. My problem is that I have tables with the same name in all the diagrams and when I update one table, all with the same name suffer the same alterations. How can…
CIRCLE
  • 4,501
  • 5
  • 37
  • 56
1
vote
2 answers

How to do a query in Mysql WorkBench?

I have an .sql script that contains inserts and creates tables. I used the "Create EER Model From Script" It created the tables but I can't see the data inside these tables. I went to the query menu and tried to make a query but it gives me an error…
chobo2
  • 83,322
  • 195
  • 530
  • 832
1
2
3 4