Solved

er diagrams and chen model

Posted on 2010-11-27
4
845 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
  • 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 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

816 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now