ER Model in DBMS – Entities, Attributes, Relationships

1. What is ER Model?

  • A blueprint of a database.
  • Shows Entities (things), Attributes (properties), and Relationships (links).
  • Helps in designing the database before actual implementation.
ER Digram

2. Elements of ER Model

A. Entities (Things)

  • Strong Entity: Exists independently. Has a primary key.
    📌 Example: Student, Book.
    ▭ Symbol: Rectangle.
  • Weak Entity: Exists only with a strong entity. Needs foreign key + partial key.
    📌 Example: Dependent of Employee.
    🔲 Symbol: Double Rectangle.

B. Attributes (Properties)

  • Simple: Cannot be divided. (Age)
  • Composite: Can be split. (Full Name → First + Last)
  • Derived: Calculated. (Age from DOB)
  • Multivalued: Multiple values possible. (Phone Numbers)

📌 Symbols:

  • Oval = Attribute
  • Dashed Oval = Derived
  • Double Oval = Multivalued

C. Relationships (Links)

  • One-to-One (1:1): Passport ↔ Person.
  • One-to-Many (1:N): Teacher → Students.
  • Many-to-Many (M:N): Students ↔ Courses.

📌 Symbol: Diamond ♦
Lines connect entities, cardinality written (1:1, 1:N, M:N).

3. Special Concepts

  • Key Attribute: Uniquely identifies entity. (Student_ID)
  • Generalization (Bottom → Up): Combine entities. (Car + Truck → Vehicle)
  • Specialization (Top → Down): Divide entity. (Employee → Manager, Engineer)
  • Aggregation: Relationship becomes entity. (Project assigned by Manager to Employee).

4. Steps to Draw ER Diagram

  1. Identify entities (nouns).
  2. Identify attributes (properties).
  3. Identify relationships (verbs/links).
  4. Decide cardinality.
  5. Draw with correct symbols.

5. Quick Examples

  • Bank System:
    Entities → Customer, Account, Transaction
    Attributes → Name, Account_No, Amount
    Relationships → Customer HAS Account, Account PERFORMS Transaction
  • University:
    Entities → Student, Course, Instructor
    Attributes → Name, ID, Credits, Salary
    Relationships → Student ENROLLS Course, Instructor TEACHES Course

6. Memory Trick 🧠

  • Entities = Things (Rectangles)
  • Attributes = Properties (Ovals)
  • Relationships = Links (Diamonds)
  • Generalization = Combine, Specialization = Divide

✅ Exam Shortcut:

  • If asked “What is ER Model?” → “A way to visually design DB using Entities, Attributes, and Relationships.”

7. Last-Minute Learning Tips

  • Mnemonic for the 3 elements:
  • EAR = Entities, Attributes, Relationships.
  • Symbols:
  • Rectangle = Entity, Oval = Attribute, Diamond = Relationship.
  • Focus on Key Terms: Strong/Weak entities, Multivalued/Derived attributes, Cardinality.
  • Practice drawing small ER diagrams for simple systems (e.g., library, bank).

MCQ

Topic 1: Entities

  1. What is an entity in the ER Model?
    A. A relationship between attributes
    B. A uniquely identifiable object in the real world
    C. A derived property of an attribute
    D. A type of database query
    Answer: B
  2. Which of the following is an example of a weak entity?
    A. Book
    B. Order
    C. Dependent
    D. Product
    Answer: C
  3. What is used to uniquely identify a strong entity?
    A. Foreign key
    B. Composite key
    C. Primary key
    D. Derived attribute
    Answer: C
  4. In an ER diagram, how is a weak entity represented?
    A. Rectangle
    B. Double rectangle
    C. Oval
    D. Diamond
    Answer: B
  5. Which of the following statements is true about weak entities?
    A. They can exist independently.
    B. They require a foreign key to identify them.
    C. They do not participate in relationships.
    D. They are represented by a diamond in ER diagrams.
    Answer: B

Topic 2: Attributes

  1. What is a multivalued attribute?
    A. An attribute that is derived from other attributes
    B. An attribute with multiple sub-parts
    C. An attribute with multiple values for a single entity
    D. An attribute that acts as a foreign key
    Answer: C
  2. Which attribute type can be divided into smaller sub-parts?
    A. Simple attribute
    B. Composite attribute
    C. Multivalued attribute
    D. Derived attribute
    Answer: B
  3. Which of the following is a derived attribute?
    A. Name
    B. Age (calculated from Date of Birth)
    C. Phone Number
    D. Employee ID
    Answer: B
  4. In an ER diagram, how is a multivalued attribute represented?
    A. Rectangle
    B. Oval
    C. Dashed oval
    D. Double oval
    Answer: D
  5. What is a key attribute in an entity?
    A. An attribute that holds multiple values
    B. An attribute used to uniquely identify an entity
    C. An attribute derived from other attributes
    D. An attribute that is not stored directly
    Answer: B

Topic 3: Relationships

  1. What is a relationship in an ER Model?
    A. A connection between entities
    B. A type of attribute
    C. A derived entity
    D. A duplicate record in a database
    Answer: A
  2. What type of relationship exists when one entity is associated with multiple entities of another type?
    A. One-to-One
    B. Many-to-Many
    C. One-to-Many
    D. Recursive
    Answer: C
  3. How is a relationship represented in an ER diagram?
    A. Rectangle
    B. Oval
    C. Diamond
    D. Double diamond
    Answer: C
  4. In the relationship “Employee WORKS_FOR Department”, which is the relationship?
    A. Employee
    B. WORKS_FOR
    C. Department
    D. Both Employee and Department
    Answer: B
  5. What is the term for the number of entities involved in a relationship?
    A. Degree
    B. Cardinality
    C. Multiplicity
    D. Participation
    Answer: A
  6. What does cardinality specify in a relationship?
    A. The type of entities involved
    B. The number of entities participating in the relationship
    C. The attributes of the relationship
    D. The type of attributes involved
    Answer: B
  7. Which of the following is a Many-to-Many relationship?
    A. A student can enroll in multiple courses, and each course can have multiple students.
    B. A student has one ID card, and one ID card belongs to one student.
    C. An employee works in one department, and one department has many employees.
    D. A product has a unique barcode.
    Answer: A

Topic 4: Special Concepts

  1. What is generalization in the ER Model?
    A. Combining multiple entities into a higher-level entity
    B. Dividing an entity into lower-level entities
    C. A type of weak entity
    D. A type of relationship
    Answer: A
  2. Which of the following is an example of specialization?
    A. “Vehicle” split into “Car” and “Truck”
    B. “Employee” combined with “Manager”
    C. “Course” related to “Student”
    D. “Book” generalized into “Item”
    Answer: A
  3. What is aggregation in the ER Model?
    A. A relationship involving another relationship
    B. A higher-level entity combining multiple attributes
    C. A derived relationship between two entities
    D. A multivalued attribute
    Answer: A

Topic 5: Practical Applications

  1. In a university database, what could be entities and relationships?
    A. Entities: Student, Course; Relationships: ENROLLS_IN
    B. Entities: ENROLLS_IN; Relationships: Student, Course
    C. Entities: Marks, Grade; Relationships: Student, Teacher
    D. Entities: Student; Relationships: Attributes
    Answer: A
  2. Which is true about the ER Model?
    A. It represents data in tables only.
    B. It describes data with entities, attributes, and relationships.
    C. It focuses on physical storage of data.
    D. It cannot model real-world scenarios.
    Answer: B
  3. In a hospital database, what is the best representation of a “Patient undergoes Treatment”?
    A. Patient is an attribute of Treatment.
    B. Treatment is a weak entity related to Patient.
    C. Patient and Treatment are unrelated entities.
    D. Treatment is a derived attribute of Patient.
    Answer: B