An ER diagram in DBMS (database management systems) is a lot like a storyboard for an animated TV show – it’s a collection of diagrams that show how everything fits together. Where a storyboard demonstrates the flow from one scene to the next, an ER diagram highlights the components of your databases and the relationships they share.


Understanding the ER model in DBMS is the first step to getting to grips with basic database software (like Microsoft Access) and more complex database-centric programming languages, such as SQL. This article explores ER diagrams in detail.


ER Model in DBMS


An ER diagram in DBMS is a tangible representation of the tables in a database, the relationships between each of those tables, and the attributes of each table. These diagrams feature three core components:


  • Entities – Represented by rectangles in the diagram, entities are objects or concepts used throughout your database.
  • Attributes – These are the properties that each entity possesses. ER diagrams use ellipses to represent attributes, with the attributes themselves tending to be the fields in a table. For example, an entity for students in a school’s internal database may have attributes for student names, birthdays, and unique identification numbers.
  • Relationships – No entity in an ER diagram is an island, as each is linked to at least one other. These relationships can take multiple forms, with said relationships dictating the flow of information through the database.

Mapping out your proposed database using the ER model is essential because it gives you a visual representation of how the database works before you start coding or creating. Think of it like the blueprint you’d use to build a house, with that blueprint telling you where you need to lay every brick and fit every door.


Entities in DBMS


An Entity in DBMS tends to represent a real-life thing (like the students mentioned previously) that you can identify with certain types of data. Each entity is distinguishable from the others in your database, meaning you won’t have multiple entities listing student details.


Entities come in two flavors:


  • Tangible Entities – These are physical things that exist in the real world, such as a person, vehicle, or building.
  • Intangible Entities – If you can see and feel an entity, it’s intangible. Bank accounts are good examples. We know they exist (and have data attributed to them) but we can’t physically touch them.

There are also different entity strengths to consider:


  • Strong Entities – A strong entity is represented using a rectangle and will have at least one key attribute attached to it that allows you to identify it uniquely. In the student example we’ve already shared, a student’s ID number could be a unique identifier, creating a key attribute that leads to the “Student” entity being strong.
  • Weak Entities – Weak entities have no unique identifiers, meaning you can’t use them alone. Represented using double-outlined rectangles, these entities rely on the existence of strong entities to exist themselves. Think of it like the relationship between parent and child. A child can’t exist without a parent, in the same way that a weak entity can’t exist without a strong entity.

Once you’ve established what your entities are, you’ll gather each specific type of entity into an entity set. This set is like a table that contains the data for each entity in a uniform manner. Returning to the student example, any entity that has a student ID number, name, and birthdate, may be placed into an overarching “Student” entity set. They’re basically containers for specific entity types.



Attributes in DBMS


Every entity you establish has attributes attached to it, as you’ve already seen with the student example used previously. These attributes offer details about various aspects of the entity and come in four types:


  • Simple Attributes – A simple attribute is any attribute that you can’t break down into further categories. A student ID number is a good example, as this isn’t something you can expand upon.
  • Composite Attributes – Composite attributes are those that may have other attributes attached to them. If “Name” is one of your attributes, its composites could be “First Name,” “Surname,” “Maiden Name,” and “Nickname.”
  • Derived Attributes – If you can derive an attribute from another attribute, it falls into this category. For instance, you can use a student’s date of birth to derive their age and grade level. These attributes have dotted ellipses surrounding them.
  • Multi-valued Attributes – Represented by dual-ellipses, these attributes cover anything that can have multiple values. Phone numbers are good examples, as people can have several cell phone or landline numbers.

Attributes are important when creating an ER model in DBMS because they show you what types of data you’ll use to populate your entities.


Relationships in DBMS


As your database becomes more complex, you’ll create several entities and entity sets, with each having relationships with others. You represent these relationships using lines, creating a network of entities with line-based descriptions telling you how information flows between them.


There are three types of relationships for an ER diagram in DBMS:


  • One-to-One Relationships – You’ll use this relationship when one entity can only have one of another entity. For example, if a school issues ID cards to its students, it’s likely that each student can only have one card. Thus, you have a one-to-one relationship between the student and ID card entities.
  • One-to-Many Relationships – This relationship type is for when one entity can have several of another entity, but the relationship doesn’t work in reverse. Bank accounts are a good example, as a customer can have several bank accounts, but each account is only accessible to one customer.
  • Many-to-Many Relationships – You use these relationships to denote when two entities can have several of each other. Returning to the student example, a student will have multiple classes, with each class containing several students, creating a many-to-many relationship.

These relationships are further broken down into “relationship sets,” which bring together all of the entities that participate in the same type of relationship. These sets have three varieties:


  • Unary – Only one entity participates in the relationship.
  • Binary – Two entities are in the relationship, such as the student and course example mentioned earlier.
  • n-ary – Multiple entities participate in the relationship, with “n” being the number of entities.

Your ER diagram in DBMS needs relationships to show how each entity set relates to (and interacts with) the others in your diagram.


ER Diagram Notations


You’ll use various forms of notation to denote the entities, attributes, relationships, and the cardinality of those relationships in your ER diagram.


Entity Notations


Entities are denoted using rectangles around a word or phrase, with a solid rectangle meaning a strong entity and a double-outlined rectangle denoting a weak entity.


Attribute Notations


Ellipses are the shapes of choice for attributes, with the following uses for each attribute type:


  • Simple and Composite Attribute – Solid line ellipses
  • Derived Attribute – Dotted line ellipses
  • Multi-Valued Attribute – Double-lined ellipses

Relationship Notations


Relationship notation uses diamonds, with a solid line diamond depicting a relationship between two attributes. You may also find double-lined diamonds, which signify the relationship between a weak entity and the strong entity that owns it.


Cardinality and Modality Notations


These lines show you the maximum times an instance in one entity set can relate to the instances of another set, making them crucial for denoting the relationships inside your database.


The endpoint of the line tells you everything you need to know about cardinality and ordinality. For example, a line that ends with three lines (two going diagonally) signifies a “many” cardinality, while a line that concludes with a small vertical line signifies a “one” cardinality. Modality comes into play if there’s a minimum number of instances for an entity type. For example, a person can have many phone numbers but must have at least one.


Steps to Create an ER Diagram in DBMS


With the various notations for an ER diagram in DBMS explained, you can follow these steps to draw your own diagram:


  • Identify Entities – Every tangible and intangible object that relates to your database is an entity that you need to identify and define.
  • Identify Attributes – Each entity has a set of attributes (students have names, ID numbers, birthdates, etc.) that you must define.
  • Identify Relationships – Ask yourself how each entity set fits together to identify the relationships that exist between them.
  • Assign Cardinality and Modality – If you have an instance from Entity A, how many instances does it relate to in Entity B? Is there a minimum to consider? Assign cardinalities and modalities to offer the answers.
  • Finalize Your Diagram – Take a final pass over the diagram to ensure all required entities are present, they have the appropriate attributes, and that all relationships are defined.

Examples of ER Diagrams in DBMS


Once you understand the basics of the ER model in DBMS, you’ll see how they can apply to multiple scenarios:


  • University Databases – A university database will have entities such as “Student,” “Teacher,” “Course,” and “Class.” Attributes depend on the entity, with the people-based entities having attributes including names, dates of birth, and ID numbers. Relationships vary (i.e., a student may only have one teacher but a single teacher may have several students).
  • Hospital Management Databases – Entities for this type of database include people (“Patients,” “Doctors,” and “Nurses”), as well as other tangibles, such as different hospital buildings and inventory. These databases can get very complex, with multiple relationships linking the various people involved to different buildings, treatment areas, and inventory.
  • E-Commerce Databases – People play an important role in the entities for e-commerce sites, too, because every site needs a list of customers. Those customers have payment details and order histories, which are potential entities or attributes. Product lists and available inventory are also factors.

Master the ER Model in DBMS


An ER diagram in DBMS can look like a complicated mass of shapes and lines at first, making them feel impenetrable to those new to databases. But once you get to grips with what each type of shape and line represents, they become crucial tools to help you outline your databases before you start developing them.


Application of what you’ve learned is the key to success with ER diagrams (and any other topic), so take what you’ve learned here and start experimenting. Consider real-world scenarios (such as those introduced above) and draw diagrams based on the entities you believe apply to those scenarios. Build up from there to figure out the attributes and relationships between entity sets and you’re well on your way to a good ER diagram.

Related posts

Times of Malta: Malta-based OPIT launches innovative AI tool for students, academic staff
OPIT - Open Institute of Technology
OPIT - Open Institute of Technology
Sep 22, 2025 5 min read

Source:

4 min read


The launch was officially unveiled during an event held at Microsoft Italia in Milan, titled AI Agents and the Future of Higher Education.

A tech-focused higher education institution based and accredited in Malta has developed a new AI assistant designed to support both students and faculty.

In a statement, the Open Institute of Technology (OPIT), announced the launch of the OPIT AI Copilot.

With the Fall Term starting on September 15, OPIT said it has already launched beta testing with faculty champions and is currently piloting full-course integrations.

Students who will be part of the pilot-phase will be able to prompt the entire OPIT – Open Institute of Technology knowledge base, personalized to their own progress.

The platform was developed entirely in-house to fully personalize the experience for the students, and also make it a real-life playground for in-class projects. It is among the first custom-built AI agents to be deployed by an accredited European higher education institution.

The launch was officially unveiled during an event held at Microsoft Italia in Milan, titled AI Agents and the Future of Higher Education

The gathering brought together academics and technology leaders from prominent European Institutions, such as Instituto de Empresa (IE University), OPIT itself and the Royal College of Arts, to explore how artificial intelligence is reshaping the university experience.

The OPIT AI Copilot has been trained on the institute’s complete academic archive, a collection created over the past three years that includes 131 courses, more than 3,500 hours of recorded lectures, 7,500 study resources, 320 certified assessments, and thousands of exercises and original learning documents.

Unlike generic AI tools, the Copilot is deeply integrated with OPIT’s learning management system, allowing it to track each student’s progress and provide tailored support.

This integration means the assistant can reference relevant sources within the learning environment, adapt to the student’s stage of study, and ensure that unreleased course content remains inaccessible.

A mobile app is also scheduled for release this autumn, that will allow students to download exercise and access other tools.

During examinations, the Copilot automatically switches to what the institute calls an “anti-cheating mode”, restricting itself to general research support rather than providing direct answers.

For OPIT’s international community of 500 students from nearly 100 countries, many of whom balance studies with full-time work, the ability to access personalised assistance at any time of day is a key advantage.

“Eighty-five per cent of students are already using large language models in some way to study,” said OPIT founder and director Riccardo Ocleppo. “We wanted to go further by creating a solution tailored to our own community, reflecting the real experiences of remote learners and working professionals.”

Tool aims to cut correction time by 30%

The Copilot will also reduce administrative burdens for faculty. It can help grade assignments, generate new educational materials, and create rubrics that allow teachers to cut correction time by as much as 30 per cent.

According to OPIT, this will free up staff to dedicate more time to teaching and direct student engagement.

At the Milan event, Rector Francesco Profumo underlined the broader implications of AI in higher education. “We are in the midst of a deep transformation, where AI is no longer just a tool: it is an environment that radically changes how we learn, teach, and create,” he said.

“But it is not a shortcut. It is a cultural, ethical, and pedagogical challenge, and to meet it we must have the courage to rethink traditional models and build bridges between human and artificial intelligence.”

OPIT was joined on stage by representatives from other leading institutions, including Danielle Barrios O’Neill of the Royal College of Art, who spoke about the role of AI in art and creativity, and Francisco Machin of IE University, who discussed applications in business and management education.

OPIT student Asya Mantovani, also employed at a leading technology and consulting firm in Italy,  gave a first-hand account of balancing professional life with online study.

The assistant has been in development for the past eight months, involving a team of OPIT professors, researchers, and engineers.

Ocleppo stressed that OPIT intends to make its AI innovations available beyond its own institution. “We want to put technology at the service of higher education,” he said.

“Our goal is to develop solutions not only for our own students, but also to share with global institutions eager to innovate the learning experience in a future that is approaching very quickly.”

Read the full article below:

Read the article
E-book: AI Agents in Education
OPIT - Open Institute of Technology
OPIT - Open Institute of Technology
Sep 15, 2025 3 min read

From personalization to productivity: AI at the heart of the educational experience.

Click this link to read and download the e-book.

At its core, teaching is a simple endeavour. The experienced and learned pass on their knowledge and wisdom to new generations. Nothing has changed in that regard. What has changed is how new technologies emerge to facilitate that passing on of knowledge. The printing press, computers, the internet – all have transformed how educators teach and how students learn.

Artificial intelligence (AI) is the next game-changer in the educational space.

Specifically, AI agents have emerged as tools that utilize all of AI’s core strengths, such as data gathering and analysis, pattern identification, and information condensing. Those strengths have been refined, first into simple chatbots capable of providing answers, and now into agents capable of adapting how they learn and adjusting to the environment in which they’re placed. This adaptability, in particular, makes AI agents vital in the educational realm.

The reasons why are simple. AI agents can collect, analyse, and condense massive amounts of educational material across multiple subject areas. More importantly, they can deliver that information to students while observing how the students engage with the material presented. Those observations open the door for tweaks. An AI agent learns alongside their student. Only, the agent’s learning focuses on how it can adapt its delivery to account for a student’s strengths, weaknesses, interests, and existing knowledge.

Think of an AI agent like having a tutor – one who eschews set lesson plans in favour of an adaptive approach designed and tweaked constantly for each specific student.

In this eBook, the Open Institute of Technology (OPIT) will take you on a journey through the world of AI agents as they pertain to education. You will learn what these agents are, how they work, and what they’re capable of achieving in the educational sector. We also explore best practices and key approaches, focusing on how educators can use AI agents to the benefit of their students. Finally, we will discuss other AI tools that both complement and enhance an AI agent’s capabilities, ensuring you deliver the best possible educational experience to your students.

Read the article