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
Solved

er diagrams and chen model

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

829 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