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
0
votes
1 answer

Tool for EER Modeling

Is there a good free conceptual modeling tool for EER modeling? It should support specialization, generalizaton, union, etc. I came across MySQL Workbench but it seemed to belong to the physical modeling stage(examples that I saw included 'VARCHAR'…
user1909491
  • 31
  • 1
  • 5
0
votes
0 answers

Trying to recreate a university database in MySQL Workbench

I am trying to recreate a university database and have created the following EER model. I am still fairly new to MySQL and was just wondering if there should be any changes made to this model in order for it to work correctly. I am not overly sure…
Godin1
  • 71
  • 1
  • 11
0
votes
2 answers

How to apply collation changes from SQL Alter script to EER model?

I'm experiencing troubles while trying to change collations of existing tables in my EER model inside MySQL Workbench (5.2.40, rev 8790) on Linux Debian (3.2.41-2). My alter script looks like this: ALTER TABLE `my_db`.`articles` COLLATE =…
Radek Simko
  • 15,886
  • 17
  • 69
  • 107
0
votes
2 answers

Differences between EER and UML

I've downloaded MySQL workbench and can create a EER diagram. What's the difference between this and a UML diagram? Where does a ERD come into this?
sark9012
  • 5,485
  • 18
  • 61
  • 99
0
votes
0 answers

MySQL Workbench - Synchronize EER model with DB - Erno 150 Can't create table

I'm trying to synchronize my EER model with my DB in MySQL Workbench, and one table fails to synchronize. I also checked that my foreign keys have the same datatype as the column they refer to. Here is the output: Executing SQL script in…
svdotbe
  • 168
  • 1
  • 3
  • 16
0
votes
2 answers

Reverse Engineer a FoxPro/dBsae database to create the EER model

I'm currently developing a webapp to a costumer and I need to import data from their old application. As far as I can tell, the database is dBase written with FoxPro. I have the application exe and lots of dbf/dbb/dbi files and I can open the dbf…
Hugo Marabutt Nogueira
  • 77
  • 8
0
votes
2 answers

How to automatically update database in MySQL Workbench?

I just downloaded MySQL Workbench 5.2 and really like it. I created a database using New Connection and created my database like normal. I then created an EER Model and used the database. Then i edited some fields in my database (in the non EER…
NeXtMaN_786
  • 661
  • 2
  • 12
  • 23
0
votes
1 answer

how to synchronize changes on mysql EER diagram with table

I create my relations in EER diagram and I want to see foreing key on my table. I readed this article but when I do it, there is and error like this: Executing SQL script in server ERROR: Error 1064: You have an error in your SQL syntax; check…
cagin
  • 5,772
  • 14
  • 74
  • 130
0
votes
1 answer

MySQL Workbench: Which collation will allow the widest range of characters, including foreign/acented characters?

I am creating an EER Model and want to find the collation that will provide me the most amount of characters to use. The characters that will be stored are generally standard English but on occasion the brands will have foreign and or accented…
Jeremy
  • 3,620
  • 9
  • 43
  • 75
0
votes
1 answer

MySQL won't create my modeled database

I'm modeling my database with MySQL Wordbench in a EER Model, which is this : So after modeling my database I export to a SQL script and try to run it, but it creates only three tables: Why is that happening ? It shouldn't create all tables ? This…
Valter Silva
  • 16,446
  • 52
  • 137
  • 218
-1
votes
1 answer

How to convert EXCEL to SQL (I have 143864 row and 100 column in excel) total 48,316 KB

I convert excel to csv first, then import to phpmyadmin only import 100 rows, I changed config.inc buffer size but still did not changed the result. Could you please help me ??? My main idea to do this, compare two tables on mysql workbench, I have…
developer123
  • 11
  • 3
-1
votes
1 answer

Open Source - EER Modeling Tool

What is a good open source or reasonably priced EER modeling tool for MySQL besides MySQL Workbench? I find the MySQL Workbench interface to be clunky. I would like to be able to manage my production schema beginning all design changes in the EER…
Nick Fergis
  • 7
  • 2
-1
votes
2 answers

EER diagram in mysql workbench

I need to make an EER diagram of my database. When I connect my database to MySQL Workbench it puts lines only between two tables with a FK on them. Do I need to manually put in the other lines where I don't have FK's but I connect two tables with a…
S.I.
  • 3,250
  • 12
  • 48
  • 77
-1
votes
1 answer

Criteria to choose between EER and UML

What criteria should I use to choose between EER and UML Class Diagram to model user requirements for a large database application? What are the advantages or disadvantages of each?
user1909491
  • 31
  • 1
  • 5
1 2 3
4