Monday, 8 May 2023

ER Diagram

 ER-DIAGRAM:

 An ER diagram shows the relationship among entity sets. An entity set is a group of similar entities and these entities can have attributes. In terms of DBMS, an entity is a table or attribute of a table in database, so by showing relationship among tables and their attributes, ER diagram shows the complete logical structure of a database. Let’s have a look at a simple ER diagram to understand this concept.

Symbols use ER- diagram 

 

 

 

 

 

 

 

 

 

 

ER- diagram of a college management system

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Timestamp-Based Protocols

Timestamp-Based Protocols Each transaction T i  is issued a timestamp TS( T i ) when it enters the system. •        Each transac...

  • Serialization
      Serializability When multiple transactions are running concurrently then there is a possibility that the database may be left in an in...
  • Introduction to DBMS
    UNIT-1 DBMS stands for Database Management System. Data is nothing but raw facts and figures and unprocessed. Data becomes information when ...
  • Transaction
    A transaction is a unit of program execution that accesses and possibly updates various data items.   (or) A transaction is an execution of ...