Name of the faculty member:
Course No.CAP 200 Course Title: DATABASE MANAGEMENT SYSTEMS
Class: BBA-IT Semester: 3rd Section: Q3201
Max. Marks: 30 :
Submitted by: Kinley Wangchuk A05 1!202391
Acknowledgement
I have taken efforts in this assignment. However, it would not have been possible without the kind support and help of many individuals. I would like to extend my sincere thanks to all of them.
I highly indebted to Business Department of LPU for their guidance and constant supervision as well as for providing necessary information regarding the assignment & also for their support in completing the assignment.
I would like to express my special gratitude and thanks to all friends for giving us such attention and time.
I thanks and appreciations also go to my colleague in developing the assignment and people who have willingly helped me out with their abilities.
Join Algorithms
An SQL join clause combines records from two or more tables in a database. It creates a set that can be saved as a table or used as it is. A join is a means for combining fields from two tables by using values common to each. ANSI (American National Standards Institute)-standard SQL specifies four types of join,