Entity Relationship Model and its Diagram

Entity Relationship Model  is the model which was introduced by P.P. chen.This model represent system data by its entity and relationships....

Entity Relationship Model is the model which was introduced by P.P. chen.This model represent system data by its entity and relationships.This model is based on real world entities.

Entity Relationship Diagram(ERD):-



Component of ERD:-

1)Entity 
2)Attributes 
3)Relationship

1)Entity:-Entity is a person,place,things,object which is used to grasp,collect,stores the data.

Types  of Entity:-

a)Weak Entity Set:-Weak entity are those entity type which are not formed primary key because of insufficient attributes.

b)Strong Entity Set:-Strong entity are those entity type which are formed primary key because of sufficient attributes.

2)Attributes:-Features of entity is called as attributes example name,address etc.

Type of Attributes:-

a)Simple Attribute
b)Composite Attribute
c)Single value Attribute
d)Multivalue Attribute etc. 

3)Relationship:-Combination of two or ore than 2 entities is called as Relationship.

Type of Relationship(According to connectivity):-

a)1:1 Relationship(One to One Relationship):-One entity related to 1 entity.Example



b)1:M Relationship(One to Many Relationship):-One entity related to more than 1 entities.Example



c)M:1 Relationship(Many to One Relationship):-More than 1 entity is related with one entity set.Example Students learn in class.Example



d)M:M Relationship(Many to Many Relationship):-More than one entity associated with more than 1 entity.Example




That's all about what is ER Modelling and its tools,if you have any query then leave your comments and don't forgot to follow me on Google+,Facebook,Twitter.

COMMENTS

BLOGGER: 1

Name

.Net Framework,8,.Net Tutorials,25,1's,1,2's,1,Addressing mode,1,ASP.NET,2,Associative Memory,1,AVL Tree,1,B-Tree,1,BFS,1,Binary Arithmetic,1,Binary Tree,2,Boolean Algebra,4,Booth's Algo,1,Bubble Sorting,1,C guide,29,C language,2,c plus plus,53,C Plus Plus guide,38,C Programs,16,c#,1,C# Tutorials,15,C++ guide,13,C++ tutorials,38,CASE Tools,1,Circular Linked List,1,Circular Queue,1,Computer Architecture Tutorials,41,Conbinational Circuit,3,Conversion,4,Counter,1,D-Queue,1,Data Bus,1,Data types,1,data-structure,1,Decoder,1,Demux,1,Devices,2,DFS,1,Division Algo,1,Doubly Linked List,1,Encoder,1,ERD,1,FIFO,1,Flip flop,5,flow chart,1,Function Overloading,1,Graph,5,Hashing,1,Infix To Postfix,1,Infix To Prefix,1,Information System,5,Inheritance,1,Insertion Sorting,1,Instate buffer,1,Instruction Cycle,1,Interrupt,1,IT Concepts,13,IT/Networking,27,java,13,K-Map,3,Kruskal's Algorithm,1,LAN,1,Linked List,5,Logic gates,1,Micro-operation,1,MUX,2,Networking,1,Number System,2,Operator Overloading,1,OSI Model,1,Other topics,2,Pipeline,1,Polymorphism,1,Postfix Evaluation,1,Prefix Evaluation,1,Prim's Algorithm,1,Priority Queue,1,Queue,5,Radix Sort Algo,1,Register,1,Router,1,RTL,1,SDLC,13,Searching,3,Security,1,Selection Sorting,1,Shell,1,Shell Sort Algo,1,Shifter,1,Singly Linked List,1,Software,3,Sorting,5,SSAD tutorials,40,Stack,1,Storage Medium,5,String,8,Swiching,1,System,9,System Analyst,1,System Model,6,Tree,5,Unix,2,Virtual Function,1,
ltr
item
All Computer Topics: Entity Relationship Model and its Diagram
Entity Relationship Model and its Diagram
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOfFtF1VDUUYWtIp71QsZbfOXDIyWt1x1Pjf3-8HpbpPnnMN4_gX21-VupHVSIvaxB0PvaQI6QcOznEmOrb2KKHZTzoQdwdugwttA42w2p1djksTXuSqSkB3_L-V23dBHnQ14JNjvbWMg/s320/erd1.jpg
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOfFtF1VDUUYWtIp71QsZbfOXDIyWt1x1Pjf3-8HpbpPnnMN4_gX21-VupHVSIvaxB0PvaQI6QcOznEmOrb2KKHZTzoQdwdugwttA42w2p1djksTXuSqSkB3_L-V23dBHnQ14JNjvbWMg/s72-c/erd1.jpg
All Computer Topics
https://allcomputertopics.blogspot.com/2013/02/entity-relationship-diagram.html
https://allcomputertopics.blogspot.com/
https://allcomputertopics.blogspot.com/
https://allcomputertopics.blogspot.com/2013/02/entity-relationship-diagram.html
true
4800178732260946995
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content