1.Create two related tables (e.g., Customers, Orders)
- Database of College
- 1st Table of Departments
- 2nd Table of Students
2.Use INNER, LEFT, RIGHT, FULL JOIN
- Inner Join with 'DeptID' column of Students Table and 'DeptID' column of Department Table
- Right Join with 'DeptID' column of Students Table and 'DeptID' column of Department Table
- Left Join with 'DeptID' column of Students Table and 'DeptID' column of Department Table
- Full Outer Join (Left Join UNION Right Join in MySQL Workbench) with 'DeptID' column of Students Table and 'DeptID' column of Department Table