Solved

er diagrams and chen model

Posted on 2010-11-27
4
847 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

726 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