Top 6 Important Concepts Of DBMS

Fig-a
Step-1
Step-2
Step-3
Fig-b
ER Diagram
  • One to One ( Ex: One student have one roll number)
  • One to Many ( Ex: A doctor have Multiple Patients )
  • Many to One ( Ex: Many products from one store )
  • Many to Many ( Ex: Many products from many stores)
  • Minimizing redundancy.
  • Minimizing insertion, deletion, and update anomalies.
  • Inner Join
    — It returns the common values in both tables
  • Outer Join
    — It returns all records when there is a match in either left or the right table.
  • Left Outer Join
    — It returns all records from the left table and common records from the right table.
  • Right Outer Join
    — It returns all records from the right table and common records from the left table.
  • Self Join
    — It means to join a table to itself.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store