Database Design And ER Diagram || Entity And Attributes

Database Design And ER Diagrams

• What Is ER Model
• Entities And Attributes 
• Relationship (1:1 , 1:N , 1:M)
• Converting ER Diagrams To Tables

∆  ER Diagrams In DBMS (Entity Relationship Diagram)

An ER Diagrams (Entity Relationship Diagram) Is A Graphical Representation Of Entities And Their relationship In A Database Design Phase To Visually Map Out How Data Is Connected And Structured

• Key Components OF ER Diagram 

• Entity :- An object Or Thing In the Real World That has Data Stored about it 
• Attributes :- properties or Details Of An Entity 
• Relationship :- Shows How Entities Are Related To Each Other 

∆ What Is An Entity 

An Entity Is real-world Object Or Concept That Can Be Identified Distinctly And About Which Data Can Be Start In A Database 

• Key Point 

• Entity Represents A Thing Or Object 
• Each Entity Is Described Using Attributes.
• Used to Design Tables In A Database 

∆ Type Of Entities 

1.  Strong Entity 

• Has Its Own Primary Key Independent And Does Not Depend On Other Entity 
• Explain :- Student (Student ID , Name ,Age)

2. Weak Entity 

• Does Not Have A Primary Key Of It's Own.
• Depends On A Strong Entity 
  
• Explain :- Dependent (Name , Age) (Depends On Employee)

∆ What Is An Attributes?

An Attribute is A property or Characteristics That Describes An Entity In A Database in Simple terms, Attributes Hold The Data For Each Entity 

• Key Points 

• Attributes Describe The Characteristics Of Entity 
• Help Define The Structure Of Tables In The Database 
• Some Attributes (Like Primary Key Help In Uniquely indentify Record

Follow And Learn More..... 

Thankyou