Logo

Specifies enterprise schema that represents the overall logical structure of a database graphically.

Pasted image 20240808170440.png

 Consists of Entities, Attributes, and Relationships among Entities

Pasted image 20240808170617.png

Entities

A Unit object , can be of two types:

  1. Strong: Independent (has primary key)
  2. Weak: Dependent on other Entity - double rectangle

Example:

Pasted image 20240808170843.png

Attributes

Properties that define the entity type

Represented as: Pasted image 20240808171024.png

Key (ex: Roll_No) - underlined Composite (ex: Address) - has Derived (ex: Age) - dotted Multivalued (Phone_No)

© 2025 All rights reservedBuilt with DataHub Cloud

Built with LogoDataHub Cloud