0000 ER Diagram Notations | MyCareerwise

View

30000

Login Register

Home
Materials
- Science
  - Computer Science
    - NTA NET
    - Gate
- Govt. Exam
  - BANK
    - Bank Clerk
Mocks
Code
Current Affairs
Previous Year
Exams & Jobs

FOR FREE MATERIALS

Sign Up

Materials

DBMS and Database definition
Data Model
Schema and Instance
Data Independence
Database Languages
Different Types of database users and Administrators

ENTITY RELATIONSHIP MODEL (ER Diagram)

Definitions and introduction
Various types of Attributes

Relationship (ER Diagram)

Introduction of Relationship
Relationship (One to One)
Relationship (many to many)
Recursive Relationship

Attributes to Relationship
ER Diagram Notations

Relational Model

Introduction to Relational Model
Relational constraints
Actions upon Referential Integrity violations
ER Diagram to Relational Model
GATE and NET questions on ER Diagram
GATE and NET questions on ER Diagram
Super key,Candidate key,Primary key
Calculate Super key

Functional Dependencies

Functional Dependencies Concept
Trivial and Non-Trivial Functional Dependency
Properties of Functional Dependency
Check Functional Dependency equivalent
Remove Redundant Functional Dependency

Attribute Closer

Concept of Attribute Closer
Find Super and Candidate Key from Attribute Closer
Question: GATE and UGC NET
Find Prime and Non-Prime Attribute
Find Candidate Key Examples and GATE question
Exercise: Find Candidate Key

Functional Dependency Closer
Membership Test
Schema Refinement

Lossless Join Decomposition

Concept of Lossless and Lossy Join Decomposition
Q: GATE and example Lossless Join Decomposition
Examples on Lossless Join Decomposition
Q: GATE and NET on Lossless Join Decomposition

Functional Dependency Preserving

Concept of Functional Dependency Preserving
Examples on Dependency Preserving

Normalization

Concept of Normalization
1NF
2NF
3NF
BCNF and normal forms comparison table
Normalization Examples
Normalization More Examples
Normalization: GATE and NET questions
Comparison table of 1NF, 2NF, 3NF and BCNF

One Liner

No items found

Formula

No items found

Question Answer

No items found

Subject Mock

Programming

No items found

Previous Year

Previous Year Mock
Previous Year Solve

Reference Book

No items found

ER Diagram Notations:

Please Login to Bookmark

Ask:
support@mycareerwise.com

Contribute:
contribute@mycareerwise.com

Useful Link

Home
About Us
Privacy Policy
Terms of Use

Exams

NTA NET
Gate
Bank Clerk

Contact

Contact Us
Help Center

Newsletter

To get updated news and information subscribe:

2025 © MyCareerwise - All rights reserved