Skip to content

Tag Archives: DBMS-ER model

ER Diagram is known as Entity-Relationship Diagram, it is used to analyze to the structure of the Database. It shows relationships between entities and their… Read More
ER Diagram is known as Entity-Relationship Diagram, it is used to analyze to structure of the Database. It shows relationships between entities and their attributes.… Read More
Prerequisite – Types of Attributes 1. Stored Attribute : Stored attribute is an attribute which are physically stored in the database. Assume a table called… Read More
ER diagram is known as Entity-Relationship diagram. It is used to analyze to structure of the Database. It shows relationships between entities and their attributes.… Read More
Entity Relationship model (ER model) contains entities and relationships. ER model enables us to know how these entities are associated with each other. Entities interact… Read More
Prerequisite – ER Model To understand Structural Constraints, we must take a look at Cardinality Ratios and Participation Constraints. Cardinality Ratios of relationships : The… Read More
A Data Model in Database Management System (DBMS), is the concept of tools that are developed to summarize the description of the database. It is… Read More
1. ER (Entity- Relationship) Model : ER model stands for entity relationship model. It specifies the structure of a database by giving the relationship between… Read More
An entity type should have a key attribute which uniquely identifies each entity in the entity set, but there exists some entity type for which… Read More
In ER model, entities have attributes which can be of various types like single-valued, multi-valued, composite, simple, stored, derived and complex. But relationships can also… Read More
In this article, Lets discuss common types of questions in relational algebra which are asked in GATE. Before reading this article, you should have idea… Read More
To understand this, you should have an idea about: ER model Relation model After designing the ER diagram of system, we need to convert it… Read More
ER Model is used to model the logical view of the system from data perspective which consists of these components: Entity, Entity Type, Entity Set… Read More
Entity-Relationship (ER) Diagram is a diagrammatic representation of data in databases, it shows how data is related.  Note: This article for those who already know… Read More