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

62 questions
258
votes
7 answers

How do I enlarge an EER Diagram in MySQL Workbench?

I am working on a moderately complex schema in MySQL Workbench, and the single page of the EER diagram is now full up. Does anyone know how to enlarge it to two or more pages?
Brian Hooper
  • 20,414
  • 23
  • 82
  • 132
67
votes
4 answers

mysql workbench error opening EER

I'm having a lubuntu-64bit and installed MySQL-workbench to open the EER model. but it just doesn't open up.. It shows error Error unserializing GRT data error unserializing object (invalid struct) The same EER file opens fine in windows.. I'm…
rakesh
  • 965
  • 2
  • 11
  • 14
46
votes
4 answers

MySQL Workbench - How to synchronize the EER Diagram

I am creating a visual representation of my existing database with MySQL Workbench and I am able to synchronize the models with the "Database -> Synchronize Model..." menu. However, every time I synchronize (update) my model, I have to recreate the…
Tiago Alves
  • 1,261
  • 1
  • 15
  • 30
30
votes
9 answers

How to copy table between two models in Mysql workbench?

I am doing some databese thing, I need copy one table from one model to another, but i try many ways there no effect. Is there any way for doing this?
DraculaW
  • 345
  • 1
  • 3
  • 7
26
votes
3 answers

Difference between ER diagram and EER diagram

What is the difference between ERD (Entity relationship diagram) and EERD (enhanced entity relationship diagram)?
shaki mandira
  • 289
  • 2
  • 5
  • 9
11
votes
1 answer

How to create EER model from a sqlite db

i'm using sqlitejdbc libraries to create a db using java. Now i need to generate eer model from existing sqlite db stored in a file. In past i used MySqlWorkbench to generate eer from a mysql db, but i don't know how to do that on sqlite db.. can…
JackTurky
  • 12,431
  • 41
  • 126
  • 208
8
votes
3 answers

the difference between mysql server and mysql workbench

I've instaled MySQL workbench in Windows 7 64bit. Unfortunately, I'm facing problems: In the Object Browser, when I click on my DB and right click on tables to create one, I can not insert any column (disabled) and therefore, can not insert tables.…
Jury A
  • 16,048
  • 23
  • 65
  • 85
6
votes
3 answers

Create a new MySQL database using Workbench

I'm just trying to create a new MySQL database with a few simple tables. I created a new EER Model in Workbench so I have the database modeled I want it, with all the tables/fields I need. I don't see any way to take the model and create an actual…
jb.
  • 8,953
  • 10
  • 47
  • 85
5
votes
1 answer

How do I automatically execute a MySQL script or routine after forward engineering from model

I've built a EER Model in MySQL Workbench that I forward engineer to create the database. The forward engineering works perfectly, and the database is created from the diagram as expected. Apart from tables, there are also some Stored Procedures…
sparkyspider
  • 11,590
  • 8
  • 73
  • 113
4
votes
1 answer

EER in MySQL workbench

I have a question in MySQL workbench. How can I make a relation 1 to 0..1 represented visually? I only found this symbol:
user455318
  • 2,940
  • 10
  • 37
  • 62
4
votes
2 answers

Mysql workbench refresh EER Diagram from server

is it possible to refetch or reimport a whole database structure from a server in mysql workbench? I've tried the synchronize options (both Model and any source), but it always works the other way round (workbench->server) and drops new columns…
theColaKid
  • 160
  • 1
  • 10
3
votes
2 answers

Unable to move (click and drag) entities in MySQL Workbench EER Diagram

I am modelling a database using MySQL Workbench - EER model. Now, I would like to move around certain entities so I can wrap them in separate layer for better visual look. My problem is that I am not able to move entities on EER diagram, using…
Vladimir
  • 1,384
  • 5
  • 22
  • 50
3
votes
2 answers

MySQL Workbench generate tables from EER Diagram

I am using MySQL Workbench and created an EER Diagram with several classes, columns, relationships, etc... now I have been looking and wondering if it is possible to let this application auto-generate these tables in my database? Up until now I…
RazorAlliance192
  • 640
  • 7
  • 23
3
votes
2 answers

Extended Entity-Relationship Model to tables (subclasses)

In the EER model there are subclasses entities. I was wondering what's the way to implement that in a real SQL Table or if there is any guide that might help me out to understand how to implement entities subclasses into tables that would help.…
Christopher Francisco
  • 13,553
  • 23
  • 77
  • 181
3
votes
1 answer

How do I import data into a MySQL Model (EER)?

I'm new to EER diagrams and visual database modeling. I have a mySQL model (EER) that I've created that we forward engineer to create our databases with the exported SQL. When editing a table in the EER, you are able to insert data too. In this…
sparkyspider
  • 11,590
  • 8
  • 73
  • 113
1
2 3 4 5