Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Relationship among entities

Photo of author

By Team EasyExamNotes

RELATIONSHIP AMONG ENTITIES

Relationship
A relationship is represented by diamond shape in ER diagram, it shows the relationship among entities. There are four types of relationships:
1. One to One
2. One to Many
3. Many to One
4. Many to Many

1. One to One Relationship
When a single instance of an entity is associated with a single instance of another entity then it is called one to one relationship. For example, a person has only one passport and a passport is given to one person.

2. One to Many Relationship
When a single instance of an entity is associated with more than one instances of another entity then it is called one to many relationship. For example – a customer can place many orders but a order cannot be placed by many customers.

3. Many to One Relationship
When more than one instances of an entity is associated with a single instance of another entity then it is called many to one relationship. For example – many students can study in a single college but a student cannot study in many colleges at the same time.

4. Many to Many Relationship
When more than one instances of an entity is associated with more than one instances of another entity then it is called many to many relationship. For example, a can be assigned to many projects and a project can be assigned to many students.

More topics from DBMS to read:

EasyExamNotes.com covered following topics in these notes.

Download as PDF

Related posts:

  1. Introduction of IOT
  2. Marketing Managment RGPV Diploma Paper Solved
  3. Value of function in programming
  4. Hardware components and device solved paper RGPV Diploma
  5. USE CASE for MCQ application
  6. OS Interview Q & A | Part 01 | Prof. Jayesh Umre
  7. Compilation
  8. OOPs in C# | PPL | Prof. Jayesh Umre
  9. Overloaded subprograms
  10. Static and Dynamic scope
  11. Type Checking
  12. Testing Levels | Software engineering | SEPM | Prof. Jayesh Umre
  13. Static and Dynamic Analysis | Software Engineering| SEPM| Prof. Jayesh Umre
  14. Code Inspection | Software engineering | SEPM | Prof. Jayesh Umre
  15. Code Inspection
  16. Characterstics of IOT
  17. IOT Internet of Things
  18. Monitors
  19. Static and Stack-Based Storage management
  20. Message passing
  21. Exception handler in Java
  22. Exception Propagation
  23. Concept of Binding
  24. Data mining and Data Warehousing
  25. Introduction to Concurrency Control
  26. Introduction to Transaction
  27. Introduction to Data Models
  28. Coaxial Cable
  29. DHCP
  30. DNS
  31. Introduction to SNMP
  32. Introduciton to SMTP
  33. Introduction to NFS
  34. Introduction to Telnet
  35. Introduction to FTP
  36. Internet Intranet Extranet
  37. UGC NET Notes
  38. Computer Terminologies
  39. UGC NET Paper 1 December 2012
  40. UGC Net paper 1 June 2011
  41. closure properties of regular languages
  42. Functional programming languages
  43. Virtualization fundamental concept of compute
  44. Dia software for UML, ER, Flow Chart etc
  45. DAVV MBA: Business Communication
  46. Mirroring and Striping
  47. RGPV Solved Papers
  48. CD#08 | Semantic analysis phase of compiler in Hindi video | Semantic tree | Symbol table | int to real
  49. COA#27 | Explain the Memory Hierarchy in short. | COA previoys years in Hindi video
  50. Infix to Postfix expression
  51. Array implementation of Stack
  52. Stack Data Structure
  53. DBMS#03 | DBMS System Architecture in Hindi video
  54. Java program method overloaing
  55. Java program use of String
  56. DS#33 | 2 Dimensional Array | Data Structure in Hindi video
  57. SE#10 | Function point (FP) project size estimation metric in Hindi video
  58. ADA#02 | Define Algorithm. Discuss how to analyse Algorithm | ADA previous years in Hindi video
  59. Principles of Programming Languages
  60. Discrete Structures
  61. Machine Learning
  62. R Programming Video Lectures
  63. Internet of Things (IOT)
  64. Digital Circuits
  65. Number Systems
  66. Computer Organization and Architecture Video Lectures
  67. UGC NET
  68. There are five bags each containing identical sets of ten distinct chocolates. One chocolate is picked from each bag.The probability that at least two chocolates are identical is ______
  69. C Programming Questions
  70. What is Software ? What is the difference between a software process and a software product ?
  71. Difference between scopus and sci/scie journal
  72. Human Process Interventions: Individual and Group Level & Organization Level Topics Covered: Coaching, training and development, conflict resolution process process consultation, third-party interventions, and team building.
  73. Leading and Managing Change & Emerging Trends in OD
  74. Designing and Evaluating Organization Development Interventions
  75. Tutorial
  76. Data Dictionary and Dynamic Performance Views
  77. Anna University Notes | Big Data Analytics
  78. What is Map Reduce programming model? Explain.
  79. Features of Web 2.0
  80. Describe in brief the different sources of water.
  81. RGPV BEEE
  82. Define data structure. Describe about its need and types.Why do we need a data type ?
  83. Interview Tips
  84. Find output of C programs Questions with Answers Set 01

Leave a Comment