?
Solved

er diagrams and chen model

Posted on 2010-11-27
4
Medium Priority
?
849 Views
Last Modified: 2012-05-10
Anyone have a good resource for learning how the chen model works in terms on relationship types.  Not sure when to use N or M,   when to use two lines,  etc

I also need to know of M:N is manay to many and is 1:N one to many

Looking for something that is easy to understand and has examples
0
Comment
Question by:enigma1234567890
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 44

Expert Comment

by:GRayL
ID: 34223273
0
 
LVL 44

Expert Comment

by:GRayL
ID: 34223274
In addition you might want to Google - Chen Model ERD
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 34227685
1. Well, Chen wrote an article on entity-relationship modeling, but this and the other related concepts (ex.: Normalization) were around way before then.
(Google: Boyce Codd normal forms)

So the term "chen model" is just an attempt to reference this principle to a specific individual's famous work.

So just as "Boyce-Codd Normal form" is associated with Boyce and Codd, the same principles had existed prior to being "Named".

The same applies here for the "Chen Model"
*However* you must fully understand basic ERD, before you can begin to conceptualize the same things using "Chen Modeling"

2. <I also need to know of M:N is manay to many and is 1:N one to many>
Both of these statements are correct.
(Note that there is also 1:1, One To One)


3. Your original post states: "when to use two lines"
?
Can you be a bit more specific as to what you are trying to figure out.
(using a specific example)

If by "Two Lines" you mean as I have in the attached screenshot, ...then in terms of "Cardinality", this means: Mandatory Single
This is ERD Basic theory, and not specific to "Chen".
So again, you need to be familiar with Basic ERD theory and diagrams, then graduate to Chen.

;-)

JeffCoachman
untitled.JPG
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34235161
;-)
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question