Entity Relationship Model: Ternary Relationships

Posted by Ethan on Stack Overflow See other posts from Stack Overflow or by Ethan
Published on 2010-04-08T23:47:01Z Indexed on 2010/04/08 23:53 UTC
Read the original article Hit count: 401

Filed under:

entity

|

entity-relationship

|

ternary

Hi, I am trying to understand why this statement in the book is wrong: "given a C entity, there is at most one related A entity and at most one related B entity". Is it that it doesn't apply to a specific kind of relationship?? So, if I have an example of a student who is in attendance to a course with a type of subject. The entities are student, attendance, course and subject. Student makes attendance in a room. Also, a student can make attendance for a subject. Does this example apply to the statement?

Thanks for your time.

© 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 entity-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
Entity Relationship Model: Ternary Relationships

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to understand why this statement in the book is wrong: "given a C entity, there is at most one related A entity and at most one related B entity". Is it that it doesn't apply to a specific kind of relationship?? So, if I have an example of a student who is in attendance to a course… >>> More
Foreign key onto weak entity set in MS SQL Server 2008?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Microsoft SQL Server 2008 Management Studio to create a relational schema by following an Entity-Relationship diagram. (included below; unrelated details removed) Until now, primary and foreign keys have been working as expected. But when I try to create a foreign key from the entity… >>> More
Entity Relationship diagram - Composition

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am implementing a small database(university Project) and i am facing the following problem. I created a class diagram where i have a class Train {Id, Name, Details} And a class RollingStock which is than generalized in Locomotive and FreightWagon. A train is Composed by multiple RollingStock… >>> More
Entity Relationship Diagramming

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to improve my understanding of cardinality constraints in ER diagrams. I have two entities: User Location But, I want the relationship between these two entities to be many-to-many (a user can be in many locations and a location can have many users). To do this I need to introduce an… >>> More