Entity Relationships - Can a weak entity take part in a 'one to many' relationship as the 'one'

Posted by jonos on Stack Overflow See other posts from Stack Overflow or by jonos
Published on 2010-03-17T16:40:49Z Indexed on 2010/03/17 16:41 UTC
Read the original article Hit count: 161

Filed under:

entity

|

relationship

|

primary

|

key

|

cardinality

Hi,

With the following entity relationship structure I'm struggling to figure out if the relationship between the LOAN and ITEM is valid?

The weak entity of Loan uses a partial key of 'loan_dateLeant' and the primary keys from CUSTOMER and ITEM to form its primary key. However LOAN has a 'one to many' relationship with ITEM as a loan can consist of more than one item. But surely this means that if more than one item is loaned, then the loan record will have two item_id values for part of its primary key?

alt text

© Stack Overflow or respective owner

Related posts about entity

Entity Framework + AutoMapper ( Entity to DTO and DTO to Entity )

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. i got some problems using EF with AutoMapper. =/ for example : i got 2 related entities ( Customers and Orders ) and theyr DTO classes : class CustomerDTO { public string CustomerID {get;set;} public string CustomerName {get;set;} public IList< OrderDTO Orders {get;set;} } class… >>> More
What .Net Namespace contains Entity for use in a generic repository?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a question that I'm ashamed to ask, but I'm going to have a go at it anyway. I am creating a generic repository in asp.net mvc. I came across an example on this website which I find to be exactly what I was looking for, but there is one problem. It references an object - Entity - and I don't… >>> More
Entity Framework version 1- Brief Synopsis and Tips – Part 1

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
To Do Eager loading use Projections (for e.g. from c in context.Contacts select c, c.Addresses) or use Include Query Builder Methods (Include(“Addresses”)) If there is multi-level hierarchical Data then to eager load all the relationships use Include Query Builder methods like customers.Include("Order… >>> More
Hibernate unknown entity (not missing @Entity or import javax.persistence.Entity )

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a really simple class... import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name = "users") public class User { … >>> More
Prevent Custom Entity being deleted from Entity Framework during Update Model Wizard

as seen on Stack Overflow - Search for 'Stack Overflow'
In Entity Framework v1 If you create a Custom Entity to map it to a Stored Procedure during FunctionImport and then Select "Update Model from Database" the Update Model Wizard removes the Custom Entity (as added Manually in the SSDL XML prior to functionImport) from the SSDL. Does anyone know if… >>> More

Related posts about relationship

Entity Relationship Diagram - Relationship Strength?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to figure out under what circumstances I should use weak (non-identifying) relationships (where the primary key of the related entity does not contain a primary key component of the parent entity), verses when I should use strong (identifying) relationships (primary key of the related… >>> More
Core Data migration of to-one relationship to to-many relationship

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a deployed app that samples measurements from sensors (e.g., Temp °C, Pressure kPa). The user can create Experiments and collect samples. Each sample is stored as a Run, such that there is a one-to-many relationship from Experiment to Run. In the interest of performance, Run has a to-one relationship… >>> More
Accessing the relationship of a relationship with Entity Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
I the School class I have this code: from student in this.Students where student.Teacher.Id == id select student The Student class there are two relationships: Teacher and School. In the School class I'm trying to find out all the students whose Teacher has a given id. The problem is that I get… >>> More
Class model for a many-to-many relationship, where relationship has attributes

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, What would the basic C# code look like to model a many-to-many relationship, where the relationship itself has attributes? And also in this case the many-to-many was referential. So a possible database model for this might look like the following (just to give an example of what I'm talking… >>> More
NHibernate: Many-to-many relationship with field in the relationship table

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm scratching my head; I have a Car table and a Customer table that have a many-to-many relationship. In this relationship table I want to add a column that can tell me what kind of relationship this is; is the customer testdriving the car, do he want to buy the car, ect. What I want to end up with… >>> More