An Entity Relationship Diagram (ERD) is a graphical representation of a database system that illustrates the relationships between entities or concepts within that system. It typically shows the components of the system and the relationships among different parts of the system, such as entities, attributes, relationships, and constraints. ERDs can be used to design a database or to analyze and improve an existing one.
The two notations for ERD’s are Chen’s notation and Crow’s Foot notation.
The primary symbols in literature refer to an object, image, word, or action that has its own meaning and can be used to represent an abstract idea. Examples of primary symbols include a rose for love, a dove for peace, a book for knowledge, and a cross for faith.
The different relationships in crow’s foot notation are one-to-one (1:1), one-to-many (1:N), and many-to-many (N:N).
The 1:1 relationship is indicated by a single line connecting two entities, while the 1:N relationship is indicated by a line connecting one entity to another with an arrowhead at the end of the line pointing to the entity on the other side. The N:N relationship is indicated by two lines with a crow’s foot at the junction of the two lines, indicating that many instances of one entity.
Salesforce is a cloud-based customer relationship management (CRM) platform developed by Salesforce. It provides businesses with a suite of applications designed to help them manage customer relationships, maintain and track customer data, and integrate with other business systems. It also provides tools to help with marketing automation, customer service, analytics, and application building.
1. One-one (1:1) cardinality: This type of cardinality is the most basic relationship, representing a single record in one table that corresponds to a single record in another table. This relationship is typically utilized to build associations between two tables by establishing a primary/foreign key relationship.
2. One-many (1:N) cardinality: This type of cardinality is used to create relationships between two tables, where one table has multiple related records in the second table. This relationship is typically used in more complicated database structures, and one table will contain a foreign key field which will link it
Leave a Reply
You must be logged in to post a comment.