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
1
vote
1 answer

Draw EER Model to create Store Database system

I asked the following question on a database site: I am trying to build an EER Model for a Autostore that has 5 locations and offers a range of auto products. They offer car repairs and roadworthy tests as a service also. I need to be able to…
Jacob Rich
  • 11
  • 1
1
vote
2 answers

MySQL and Java: table doesn't exist

I have created MySQL DB using MySQL Workbench 5.2.40 CE. At first, I created New EER Model and named it test. Then created schema named: testdb, then table named: table1. Also, created a connection. The following class to create connection with my…
Jury A
  • 19,192
  • 24
  • 69
  • 93
0
votes
1 answer

Forming relations from EER diagrams

I'm really trying to wrap my head around the concept of transforming EER Diagrams into relations. I understand that simple attributes must be mapped directly on the relation. My problem arises when dealing with composite and multivalued attributes.…
user799910
0
votes
1 answer

Can MySQL Workbench sync a model diagram with more than one database?

I'd like to use the Database->Synchronize Model feature in MySQL Workbench to modify both my production database and a test database (used for automatic phpunit testing of a yii webapp). In the past I've copied the MWB EER model within MySQL…
hobs
  • 18,473
  • 10
  • 83
  • 106
0
votes
1 answer

EER : Superclass/subclass Entity relationship, primary key mapping

Here is the scenario. STUDENT, FACULTY are sub-classes of PERSON entity, and they have specialized attributes. Normally, we store common attributes in PERSON table (with p_id as pk) and store specialized in the subclasses. We map the subclass to…
Firefox
  • 941
  • 2
  • 14
  • 22
0
votes
1 answer

MySQL EER database model that stores download information?

I am trying to create an EER model for a database, but I am unsure of how to go about it. I am currently learning out of a book and trying the end-of-chapter exercises and I am finding myself more and more confused. The exercise I am trying to…
jason
  • 1
  • 4
0
votes
1 answer

Can a relationship type attribute be a derived attribute?

Is it possible to have this? Assuming there are many attributes in the relations A and B
jaegarmaster176
  • 27
  • 5
0
votes
4 answers

Usage of Primary and Foreign keys in an EER diagram

In my db I have three tables (I have more but for case is equal, users can be companies or single people). Users has a primary key id_user; Company has a primary key id_company and a foreign key users_id_user; job_offers has a primary key…
anvd
  • 3,997
  • 19
  • 65
  • 126
0
votes
1 answer

can a conceptual model have this?

I was told by a student that a conceptual model includes major entities and their relationships but not such high detail level of information about the attributes and their values. Is this true? Is this the limitation to the conceptual model?
LearningToProgram
  • 13
  • 7
0
votes
2 answers

What's the best way to design an Entity / Relationship Model?

For example if I have 20 tables, I have to design it by section? i.e CLIENT (id, name...) -- orders -- ODERS_DETAIL(id, products...) . . . lives --- ADDRESS(...) Or I can use The MySQL Workbench EER Model (To me, it looks like the Pysical Model)?…
jartaud
  • 375
  • 5
  • 19
0
votes
0 answers

EER Diagram, am I doing this right?

For every table I'm adding a row id_company (relationship) to the companies table, because each company will have its own records. Am I doing it right?
Thiago Yoithi
  • 495
  • 1
  • 6
  • 13
0
votes
1 answer

What does the "C" symbol means in EER diagrams?

What does the "C" symbol that exists for example in disjoint in EER diagrams mean. I don't ask what disjoint mean I'm just interested in what the "C"-symbol means? I assume that it's not a union? So what is it then?…
sdasd
  • 3
  • 1
  • 2
0
votes
1 answer

MySQL WorkBench EER model not show PK

I can't find that in the settings. Where I can set that in table will show primary keys (PK) like it is showing foreign keys (FK).
Wizard
  • 10,985
  • 38
  • 91
  • 165
0
votes
1 answer

Execute script from MySQL workbench EER model?

There's a facility in MySQL Workbench's EER Modelling mode to write an SQL script that's stored with the model. But I've looked all over the place and can't see any way of executing such a script, other than by copying and pasting it into a window…
Jules
  • 14,841
  • 9
  • 83
  • 130
0
votes
1 answer

Conceptual model vs normalization. ER diagrams EER diagrams

I have a question about those four thing because they confuse me. Whats the difference between conceptual model and normalization ? Also where ER and EER are belongs to Conceptual model or normalization? Thank you
user3045939
  • 67
  • 1
  • 1
  • 6
1 2
3
4