View
107000
Login
Register
Home
Materials
Science
Computer Science
NTA NET
Gate
Govt. Exam
BANK
Bank Clerk
Mocks
NTA NET
Computer Science
Gate
Computer Science
Bank Clerk
BANK
Code
Current Affairs
Previous Year
NTA NET
Computer Science
Gate
Computer Science
Bank Clerk
BANK
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
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
Share
.png)
.png)
.png)
