Stack Overflow
Stack Overflow

Questions tagged [identifying-relationship]

Use for both identifying relationships and non-identifying relationships.

15 questions
881
votes
15 answers

What's the difference between identifying and non-identifying relationships?

I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?
Loc Nguyen
  • 9,471
  • 5
  • 22
  • 27
93
votes
4 answers

JPA: difference between @JoinColumn and @PrimaryKeyJoinColumn?

What's the exact difference between @JoinColumn and @PrimaryKeyJoinColumn? You use @JoinColumn for columns that are part of a foreign key. A typical column could look like (e.g. in a join table with additional…
Kawu
  • 13,647
  • 34
  • 123
  • 195
83
votes
8 answers

Still Confused About Identifying vs. Non-Identifying Relationships

So, I've been reading up on identifying vs. non-identifying relationships in my database design, and a number of the answers on SO seem contradicting to me. Here are the two questions I am looking at: What's the Difference Between Identifying and…
JasCav
  • 34,458
  • 20
  • 113
  • 170
23
votes
4 answers

Trouble deciding on identifying or non-identifying relationship

I've read this question: What's the difference between identifying and non-identifying relationships? But I'm still not too sure... What I have is three tables. Users Objects Pictures A user can own many objects and can also post many pictures per…
KdgDev
  • 14,299
  • 46
  • 120
  • 156
11
votes
2 answers

Data Modeling: Logical Modeling Exercise

In trying to learn the art of data storage I have been trying to take in as much solid information as possible. PerformanceDBA posted some really helpful tutorials/examples in the following posts among others: is my data normalized? and Relational…
swisscheese
  • 1,765
  • 4
  • 23
  • 25
3
votes
1 answer

Can a weak entity be involved in both identifying and non-identifying relationships with other tables?

Obviously a weak entity must be involved (as the child) in one or more identifying relationships, otherwise it would not be weak. But can it, at the same time, also be the child in a non-identifying relationship?
S. Jackson
  • 31
  • 1
  • 2
1
vote
2 answers

Should "Product Category" have an identifying relationship with "Product"?

I have a table product(id, name), which contains several groups of products that differ by a model number. i.e. {motor10, motor20, motor30, pipe10, pipe20, pipe30, wrench12, wrench20, etc}. I chose to create a new table called product category that…
Dennis
  • 7,907
  • 11
  • 65
  • 115
0
votes
1 answer

JPA : initializing simultaneously both entities in a parent/child relations

I'm new to JPA and I can't find a way to correctly initialize a set of child entities when saving the parent using its own repository. I have this Parent entity which contains a list of child that I want to instantiate when creating the parent such…
MatthiasN
  • 1
0
votes
1 answer

Identifying relationships in Kotlin

Are nested classes a good way to model identifying relationships in Kotlin? Requirements: an issue can not be without a serno a revocation can not be without an issue an affirmation can not be without a revocation Looks quite verbose: class Have…
ceving
  • 21,900
  • 13
  • 104
  • 178
0
votes
1 answer

Expressing identifying and non-identifying relationships in MySQL

Context I'm learning about identifying and non-identifying relationships, and I'm wondering how I'd express them in MySQL. For practice, I've been working on a database for Pokemon. For context, every few years a new version of the game comes out…
grogTheFrog
  • 19
  • 3
0
votes
1 answer

Identifying and Non-Identifying relationship

First of all, I have read several similar questions with "technical" answers that look like C & P. What I need is a clear example. The normalization is 3NF. In this project, in the administrative panel, you have to create cities and zones and each…
Miguel Alejandro Lazcano
  • 13
  • 4
0
votes
3 answers

one-to-many identifying relationship in sql

I have a big challenge that i am facing right now. I am designing a database when i have a strong entity "CLIENT" with a weak entity "AFFILIATE" which has the primary key of itself combined with the parent's primary key.The identifying relationship…
Ntsinzi-Ezer Ntabwoba
  • 13
  • 1
  • 6
0
votes
1 answer

Entity Framework 5 Identifying Relationship using Code First throws InvalidOperationException

I'm getting the following InvalidOperationException: The changes to the database were committed successfully, but an error occurred while updating the object context. The ObjectContext might be in an inconsistent state. Inner exception message: A…
jlavallet
  • 1,267
  • 1
  • 12
  • 33
0
votes
2 answers

Should this be an identifying relationship or not?

well I've posted this question originally on StackExchange for database adminsitrators: https://dba.stackexchange.com/questions/28356/should-this-be-an-identifying-relationship-or-not But it seems to lack users I guess. So can anyone help me with…
Arturas M
  • 4,120
  • 18
  • 50
  • 80
0
votes
2 answers

Database design issue regarding identifying relationships and many to many relationships

I have a weird database design issue that I'm not sure if I'm doing this right or not. Since my current design is really complicated, I've simplified it in the following diagram with a comparison using houses and occupants (not my actual…
Ryan Mortier
  • 763
  • 1
  • 10
  • 23