Skip to main content

ER Model

ER (Entity Relationship) Model in DBMS

  • ER model stands for an Entity-Relationship model. It is a high-level data model. This model is used to define the data elements and relationships for a specified system. 
  • It develops a conceptual design for the database. It also develops a very simple and easy-to-design view of data.
  • In ER modeling, the database structure is portrayed as a diagram called an entity-relationship diagram.

For example, Suppose we design a school database. In this database, the student will be an entity with attributes like address, name, id, age, etc. The address can be another entity with attributes like city, street name, pin code, etc and there will be a relationship between them.



Component of ER Diagram



1. Entity: An entity may be any object, class, person or place. In the ER diagram, an entity can be represented as rectangles.
Consider an organization as an example- manager, product, employee, department etc. can be taken as an entity.


a. Weak Entity - An entity that depends on another entity called a weak entity. The weak entity doesn't contain any key attribute of its own. The weak entity is represented by a double rectangle.


2. Attribute: The attribute is used to describe the property of an entity. Eclipse is used to represent an attribute. 
For example, id, age, contact number, name, etc. can be attributes of a student.



a. Key Attribute - The key attribute is used to represent the main characteristics of an entity. It represents a primary key. The key attribute is represented by an ellipse with the text underlined.



b. Composite Attribute - An attribute that composed of many other attributes is known as a composite attribute. The composite attribute is represented by an ellipse, and those ellipses are connected with an ellipse.


c. Multivalued Attribute - An attribute can have more than one value. These attributes are known as a multivalued attribute. The double oval is used to represent multivalued attribute.
For example, a student can have more than one phone number.


d. Derived Attribute - An attribute that can be derived from other attribute is known as a derived attribute. It can be represented by a dashed ellipse.
For example, A person's age changes over time and can be derived from another attribute like Date of birth.


3. Relationship: A relationship is used to describe the relation between entities. Diamond or rhombus is used to represent the relationship.


Types of relationship are as follows:

a. One-to-One Relationship - When only one instance of an entity is associated with the relationship, then it is known as one to one relationship.
For example, A female can marry to one male, and a male can marry to one female. 


b. One-to-many relationship - When only one instance of the entity on the left, and more than one instance of an entity on the right associates with the relationship then this is known as a one-to-many relationship.
For example, Scientist can invent many inventions, but the invention is done by the only specific scientist. 


c. Many-to-one relationship - When more than one instance of the entity on the left, and only one instance of an entity on the right associates with the relationship then it is known as a many-to-one relationship.
For example, Student enrolls for only one course, but a course can have many students.


d. Many-to-many relationship - When more than one instance of the entity on the left, and more than one instance of an entity on the right associates with the relationship then it is known as a many-to-many relationship.
For example, Employee can assign by many projects and project can have many employees.


Comments

Popular posts from this blog

Joins in DBMS

DBMS Joins: Inner, THETA, Outer, Equi Types of Join Operations Join in DBMS is a binary operation that allows you to combine join product and selection in one single statement. The goal of creating a join condition is that it helps you to combine the data from two or more DBMS tables. The tables in DBMS are associated using the primary key and foreign keys. Types of Join There are mainly two types of joins in DBMS: Inner Joins: Theta, Natural, EQUI Outer Join: Left, Right, Full Inner Join Inner Join is used to return rows from both tables which satisfy the given condition. It is the most widely used join operation and can be considered as a default join-type An Inner join or equijoin is a comparator-based join which uses equality comparisons in the join-predicate. However, if you use other comparison operators like “>” it can’t be called equijoin. Inner Join further divided into three subtypes: Theta join Natural join EQUI join Theta Join Theta Join allows you to merge two tables ba...

Object Oriented and Relational Database

Object Relational and Object-Oriented Database What Is Object Relational Database? An object-relational database (ORD) is a database management system (DBMS) that’s composed of both a relational database (RDBMS) and an object-oriented database (OODBMS). An object-relational database acts as an interface between relational and object-oriented databases because it contains aspects and characteristics from both models. Object-oriented database (ORD) serves two main purposes: It connects the divide between relational databases and the object-oriented modeling techniques that are usually used in programming languages like C#, Java and C++. It bridges the gap between conceptual data modeling techniques for relational and object-oriented databases like entry-relationship diagram (ERD) and object-relational mapping (ORM). What Is Object Oriented Database? An object-oriented database is organized around objects rather than actions and data rather than logic. Therefore, an object database is a d...

Create one Box class and find out area and volume of a box (Using parameterized method, And method should have no return type)

Create one Box class and find out area and volume of a box (Using parameterized method, And method should have no return type). import java.util.Scanner;  public class volumeBox {  public static void main(String[] args) {  Scanner sc = new Scanner(System.in);  System.out.println("Enter the value of length: ");  double l=sc.nextDouble();  System.out.println("Enter the value of width: ");  double w=sc.nextDouble();  System.out.println("Enter the value of height: ");  double h=sc.nextDouble();  box b1=new box();  System.out.println("The area of the box is "+b1.area(l, w, h));  System.out.println("The volume of the box is "+b1.volume(l, w, h));  sc.close();  }  }  class box{  public double area(double l,double w,double h){  return 2*(l*w+l*h+h*w);  }  public double volume(double l,double w,double h){  return l*w*h;  }  } OUTPUT: Enter the value of length: 5 Enter the value of w...