Last updated: Jan 24, 2022

ER Diagram and Relational Models

Entity Relationship diagrams and Relational Models help in defining and visualizing the way in which data is going to be stored in the database and the relationships between them.

Relational Data Models

In this blog, we will discuss Relational Data Models - a vital topic of DBMS(Database Management System).

Author Debarati Ghatak

1 upvote

Anomalies in DBMS MEDIUM

Explore the concept of Anomalies in DBMS in this informative web resource. Read on to discover its types causes,and how to avoid them.

Author Shivani Kumari

1 upvote

Data Integrity Constraints in DBMS EASY

In this article, we will discuss the introduction to data Integrity Constraints, Types of Integrity Constraints, and examples with explanations.

Author Ashish Sharma

1 upvote

Difference between strong entity and weak entity MEDIUM

Learn about the key differences between strong and weak entities and their features in database design, including their definitions, characteristics, and examples.

1 upvote

Hierarchical Model in DBMS EASY

In this blog, we will learn about the Hierarchical Model in DBMS. We will understand its core concepts, syntax, advantages and disadvantages and learn about parameters and much more for better understanding.

Author Rinki Deka

0 upvotes

Dimensional Data Modeling

In this blog, we'll learn dimensional data modeling, different kinds of schemas and see the comparison between these schemas.

Author Purswani Dineshkumar

1 upvote

Data Warehouse Modeling

In this blog, we'll learn about data modeling, data modeling types, and types of data warehouse models. Read the blog to learn more.

Author Purswani Dineshkumar

3 upvotes

Relational Algebra

This article will cover the various operations in relational algebra, along with examples of each of them. We will learn all about relational algebra.

Author Ankit Kumar

2 upvotes

Entity-Relationship Diagram

Entity Relationship Diagram or ER Diagram is a type of structural diagram used in database design. An ER Diagram contains different symbols and connectors to visualize the major entities within the system scope, and the inter-relationships among these entities.

Entity and Attributes

This article covers what entity and attributes are and how it contributes to the ER model with its types and sets.

Author Divyansh Jain

1 upvote

Weak Entity in DBMS EASY

In this article, we will be discussing what is a weak entity.

Author Urwashi27

1 upvote

Composite Attribute in DBMS EASY

Composite attribute is one of the types of attributes used in ER modeling. The attributes that cannot be divided into smaller parts are called simple attributes.

Author Deleted User

0 upvotes

Specialization in DBMS MEDIUM

Specialization is a powerful tool because it helps organise the database and hence reduces redundancy and improves the way the database works.

Author yesdhruv

0 upvotes

Aggregation in DBMS MEDIUM

Aggregation in DBMS refers to the process of summarizing or grouping data to derive meaningful insights, typically using functions like SUM, AVG, or COUNT.

Author Rahul Singh

0 upvotes

Generalization in DBMS EASY

In this article, we will discuss about Generalization in DBMS. Generalization is a process in which a new entity is formed using the common attributes of two or more entities.

Author mishrashriCodes

2 upvotes

In this blog, we will discuss Keys - a fundamental topic of DBMS(Database Management System). Read the blog till the end to understand Keys in-depth.

Author Debarati Ghatak

1 upvote

Types of Relationship in DBMS EASY

Types of Relationship in DBMS 1. One-to-One Relationship 2. One-to-Many or Many-to-One Relationship 3. Many-to-Many Relationship

Author Gaurish Anand

1 upvote

What is Super Keys in DBMS? EASY

Super keys in DBMS are unique identifiers for database records, ensuring each entry has a distinct identification. In this article, we will explore Super Keys in DBMS in detail.

Author siddharth sharma

1 upvote

Multivalued Attributes in DBMS EASY

This article provides an overview of multivalued attributes with the help of examples, along with pros, cons and how it works.

Author Aayoushee ahlawat

2 upvotes

Difference between Generalisation and Specialization in DBMS MEDIUM

In this article we will learn about the difference between generalization and specialization in DBMS with the help of comparison and examples.

Author Ankit Kumar

3 upvotes

Minimization of ER Diagram

In this blog, we'll learn the minimization of an ER diagram. Also, we will look at what cardinality is and three kinds of cardinalities in relationships with feasible examples.

Author Purswani Dineshkumar

2 upvotes

Recursive Relationship in DBMS EASY

In this blog, we will learn about recursive relationships and we will understand this with some easy-to-understand illustrations.

Author Purswani Dineshkumar

2 upvotes

Impedance Mismatch

In this blog, we will learn about object-relational impedance mismatch, and we will try to understand it with the help of some examples.

Author Purswani Dineshkumar

2 upvotes

Convert the ER Diagram into a Table

This blog introduces the ER diagram(Entity Relationship diagram), entity and relationship set, and how to convert the ER diagram into a table. We will study all the cases conversions of ER diagram to a table.

Author PRASHANT SINGH

4 upvotes

Mapping ER to Relational Model

In this article, we will map ER diagrams to a relational model for different cases. This will help us in the easy implementation of relational models.

Author Shivani Kumari

2 upvotes