Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Advisor
|   AdvisorID |   DepartmentID | AdvisorName      |
|------------:|---------------:|:-----------------|
|         101 |           1000 | Giovanni Alford  |
|         102 |           1000 | Milana Hagan     |
|         103 |           1005 | Fletcher Barrett |
|         104 |           1005 | Fariha Redfern   |
|         105 |           1006 | Rahim Contreras  |
|         106 |           1007 | Khalil Hilton    |
|         107 |           1007 | Dione Jefferson  |
|         108 |           1006 | Calum Ellwood    |
|         109 |           1008 | Sinead Coleman   |
|         110 |           1009 | Riaz Baldwin     |


Table: Building
|   BuildingID | BuildingName          | BuildingLocation   |   CampusID |   DepartmentID |
|-------------:|:----------------------|:-------------------|-----------:|---------------:|
|          800 | Smiths                | Westside           |        200 |           1000 |
|          801 | Shilman               | Forsynth Avenue    |        201 |           1001 |
|          802 | Robert Science Center | Brookline          |        202 |           1002 |
|          803 | Margaret              | Backbay            |        203 |           1003 |
|          804 | Sundew                | Milk Street        |        204 |           1004 |
|          805 | Lavender              | Park Street        |        205 |           1010 |
|          806 | Bedford               | Beacon Street      |        206 |           1010 |
|          807 | Elliot                | Mathews Street     |        207 |           1007 |
|          808 | Spearow               | Symphony Street    |        208 |           1008 |
|          809 | Eagle                 | Eastside           |        209 |           1009 |


Table: CourseCatalog
|   CourseID |   CampusID | RevisionDate            | AcademicTerm   |   CourseOffering.CourseID | CourseOffering.CourseName      | CourseOffering.CourseType   |   CourseOffering.Grades.CourseID |   CourseOffering.Grades.StudentID |   CourseOffering.Grades.CGPA | CourseOffering.Grades.Result   | CourseOffering.Grades.Grade   |
|-----------:|-----------:|:------------------------|:---------------|--------------------------:|:-------------------------------|:----------------------------|---------------------------------:|----------------------------------:|-----------------------------:|:-------------------------------|:------------------------------|
|       6004 |        208 | 2021-11-15 00:00:00.000 | Spring         |                      6004 | Design Patterns                | Online                      |                             6004 |                               146 |                         1.46 | Fail                           | F                             |
|       6004 |        208 | 2021-11-15 00:00:00.000 | Spring         |                      6004 | Design Patterns                | Online                      |                             6004 |                               159 |                         1.88 | Fail                           | F                             |
|       6004 |        208 | 2021-11-15 00:00:00.000 | Spring         |                      6004 | Design Patterns                | Online                      |                             6004 |                               216 |                         1.49 | Fail                           | F                             |
|       6004 |        208 | 2021-11-15 00:00:00.000 | Spring         |                      6004 | Design Patterns                | Online                      |                             6004 |                               230 |                         1.81 | Fail                           | F                             |
|       6004 |        208 | 2021-11-15 00:00:00.000 | Spring         |                      6004 | Design Patterns                | Online                      |                             6004 |                               242 |                         2.44 | Fail                           | F                             |
|       6004 |        208 | 2021-11-15 00:00:00.000 | Spring         |                      6004 | Design Patterns                | Online                      |                             6004 |                               274 |                         1.14 | Fail                           | F                             |
|       6004 |        208 | 2021-11-15 00:00:00.000 | Spring         |                      6004 | Design Patterns                | Online                      |                             6004 |                               372 |                         1.34 | Fail                           | F                             |
|       6004 |        208 | 2021-11-15 00:00:00.000 | Spring         |                      6004 | Design Patterns                | Online                      |                             6004 |                               387 |                         2.24 | Fail                           | F                             |
|       6006 |        200 | 2021-11-15 00:00:00.000 | Spring         |                      6006 | Data Science Methods and Tools | InPerson                    |                             6006 |                               119 |                         3.2  | Pass                           | F                             |
|       6006 |        200 | 2021-11-15 00:00:00.000 | Spring         |                      6006 | Data Science Methods and Tools | InPerson                    |                             6006 |                               134 |                         2.13 | Fail                           | F                             |


Table: CourseOffering
|   CourseID | CourseName                                | CourseDescription                                                                                                                                                                                              |   Credits | CourseType   |
|-----------:|:------------------------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------:|:-------------|
|       6000 | Web Design                                | Introduction to basics of HTML,CSS and JavaScript                                                                                                                                                              |         4 | InPerson     |
|       6001 | Web Tools and Methods                     | Introductory course diving into REST API and Java                                                                                                                                                              |         4 | InPerson     |
|       6002 | UX Design and Testing                     | Deals with wireframing and testing softwares                                                                                                                                                                   |         4 | Online       |
|       6003 | Database Management and Design            | Deals with designing databases and running complex queries                                                                                                                                                     |         4 | Online       |
|       6004 | Design Patterns                           | Introducses to the best practices used by experienced object-oriented software developers                                                                                                                      |         4 | Online       |
|       6005 | Datawarehousing and Business Intelligence | Examines the technical and management aspects of building a data warehouse                                                                                                                                     |         4 | InPerson     |
|       6006 | Data Science Methods and Tools            | Introduces the fundamental techniques for machine learning and data science engineering                                                                                                                        |         4 | InPerson     |
|       6007 | Application Engineering Development       | Employs the object-oriented paradigm, visual user experience, and system design principles to put together complicated, powerful, real-world applications                                                      |         4 | Online       |
|       6008 | Network Structures and Cloud Computing    | focuses on the fundamentals of cloud computing, the principal areas of cloud architectures, cloud security, cloud governance, cloud storage, cloud virtualization and cloud capacity                           |         4 | Online       |
|       6009 | Big Data Systems                          | Offers students an opportunity to learn a hands-on approach to understanding how large-scale data sets are processed and how data science algorithms are adopted in the industry through case studies and labs |         4 | InPerson     |


Table: CourseRegistration
|   RegID | RegStatus      | RegDate                 |   CourseID |   StudentID |   CourseOffering.CourseID | CourseOffering.CourseName      | CourseOffering.CourseDescription                           | CourseOffering.CourseType   |   Student.StudentID | Student.StudentName   |   Student.Semester |   RegStatusFlag |
|--------:|:---------------|:------------------------|-----------:|------------:|--------------------------:|:-------------------------------|:-----------------------------------------------------------|:----------------------------|--------------------:|:----------------------|-------------------:|----------------:|
|    1013 | Web Registered | 2021-05-05 00:00:00.000 |       6002 |         158 |                      6002 | UX Design and Testing          | Deals with wireframing and testing softwares               | Online                      |                 158 | latroy abdeldayen     |                  4 |               0 |
|    1230 | Web Registered | 2021-05-05 00:00:00.000 |       6000 |         175 |                      6000 | Web Design                     | Introduction to basics of HTML,CSS and JavaScript          | InPerson                    |                 175 | latu abdula           |                  1 |               0 |
|    1302 | Web Registered | 2021-05-05 00:00:00.000 |       6003 |         291 |                      6003 | Database Management and Design | Deals with designing databases and running complex queries | Online                      |                 291 | mondell renuka        |                  3 |               0 |
|    1326 | Web Registered | 2021-05-05 00:00:00.000 |       6000 |         155 |                      6000 | Web Design                     | Introduction to basics of HTML,CSS and JavaScript          | InPerson                    |                 155 | latronda abdel        |                  2 |               0 |
|    1346 | Web Registered | 2021-05-05 00:00:00.000 |       6000 |         392 |                      6000 | Web Design                     | Introduction to basics of HTML,CSS and JavaScript          | InPerson                    |                 392 | suresh tolin          |                  3 |               0 |
|    1615 | Web Registered | 2021-05-05 00:00:00.000 |       6000 |         285 |                      6000 | Web Design                     | Introduction to basics of HTML,CSS and JavaScript          | InPerson                    |                 285 | mond renton           |                  3 |               0 |
|    1657 | Web Registered | 2021-05-05 00:00:00.000 |       6002 |         150 |                      6002 | UX Design and Testing          | Deals with wireframing and testing softwares               | Online                      |                 150 | latrishia abbs        |                  2 |               0 |
|    1665 | Web Registered | 2021-05-05 00:00:00.000 |       6002 |         160 |                      6002 | UX Design and Testing          | Deals with wireframing and testing softwares               | Online                      |                 160 | latroyia abdella      |                  1 |               0 |
|    1681 | Web Registered | 2021-05-05 00:00:00.000 |       6003 |         321 |                      6003 | Database Management and Design | Deals with designing databases and running complex queries | Online                      |                 321 | raequon repko         |                  4 |               0 |
|    1820 | Web Registered | 2021-05-05 00:00:00.000 |       6000 |         119 |                      6000 | Web Design                     | Introduction to basics of HTML,CSS and JavaScript          | InPerson                    |                 119 | Dom Toretto           |                  1 |               0 |


Table: CourseRegistrationInsert
|   RegID | RegStatus      | RegDate                 |   CourseID |   StudentID | Action   | ActionDate              |
|--------:|:---------------|:------------------------|-----------:|------------:|:---------|:------------------------|
|    7963 | Web Registered | 2021-05-05 00:00:00.000 |       6009 |         305 | I        | 2021-11-30 14:30:33.780 |
|    4555 | Web Registered | 2021-05-05 00:00:00.000 |       6004 |         305 | I        | 2021-11-30 14:30:33.780 |
|    6224 | Web Registered | 2021-05-05 00:00:00.000 |       6002 |         304 | I        | 2021-11-30 14:30:33.780 |
|    4958 | Web Registered | 2021-05-05 00:00:00.000 |       6002 |         276 | I        | 2021-11-30 14:30:33.783 |
|    4689 | Web Registered | 2021-05-05 00:00:00.000 |       6000 |         275 | I        | 2021-11-30 14:30:33.783 |
|    1615 | Web Registered | 2021-05-05 00:00:00.000 |       6000 |         285 | I        | 2021-11-30 14:30:33.783 |
|    2149 | Web Registered | 2021-05-05 00:00:00.000 |       6001 |         295 | I        | 2021-11-30 14:30:33.783 |
|    7954 | Web Registered | 2021-05-05 00:00:00.000 |       6001 |         292 | I        | 2021-11-30 14:30:33.786 |
|    2122 | Web Registered | 2021-05-05 00:00:00.000 |       6003 |         181 | I        | 2021-11-30 14:30:33.790 |
|    6942 | Web Registered | 2021-05-05 00:00:00.000 |       6008 |         147 | I        | 2021-11-30 14:30:33.790 |


Table: Department
|   DepartmentID | DepartmentName             |
|---------------:|:---------------------------|
|           1000 | Information Systems        |
|           1001 | Data Analytics Engineering |
|           1002 | Industrial Engineering     |
|           1003 | Computer Science           |
|           1004 | Software Engineering       |
|           1005 | Law                        |
|           1006 | Data Science               |
|           1007 | Information Science        |
|           1008 | Health Informatics         |
|           1009 | Regulatory Laws            |


Table: Grades
|   CourseID |   StudentID |   CGPA | Result   | Grade   |
|-----------:|------------:|-------:|:---------|:--------|
|       6000 |         111 |   1.96 | Fail     | F       |
|       6000 |         128 |   1.91 | Fail     | F       |
|       6000 |         155 |   2.18 | Fail     | F       |
|       6000 |         182 |   1.13 | Fail     | F       |
|       6000 |         212 |   1.77 | Fail     | F       |
|       6000 |         226 |   1.18 | Fail     | F       |
|       6000 |         238 |   2.2  | Fail     | F       |
|       6000 |         254 |   2.36 | Fail     | F       |
|       6000 |         268 |   1.78 | Fail     | F       |
|       6000 |         332 |   2.22 | Fail     | F       |


Table: GradesChange
|   CourseID |   StudentID |   CGPA | Result   | Grade   | Action   | ActionDate              |
|-----------:|------------:|-------:|:---------|:--------|:---------|:------------------------|
|       6007 |         107 |   1.29 | Fail     | F       | I        | 2021-11-30 14:30:34.020 |
|       6000 |         111 |   1.96 | Fail     | F       | I        | 2021-11-30 14:30:34.023 |
|       6001 |         112 |   1.55 | Fail     | F       | I        | 2021-11-30 14:30:34.023 |
|       6005 |         117 |   2.12 | Fail     | F       | I        | 2021-11-30 14:30:34.023 |
|       6007 |         120 |   1.62 | Fail     | F       | I        | 2021-11-30 14:30:34.026 |
|       6008 |         123 |   1.5  | Fail     | F       | I        | 2021-11-30 14:30:34.026 |
|       6000 |         128 |   1.91 | Fail     | F       | I        | 2021-11-30 14:30:34.026 |
|       6001 |         129 |   1.22 | Fail     | F       | I        | 2021-11-30 14:30:34.026 |
|       6003 |         131 |   2.28 | Fail     | F       | I        | 2021-11-30 14:30:34.026 |
|       6006 |         134 |   2.13 | Fail     | F       | I        | 2021-11-30 14:30:34.030 |


Table: NoOfStudentsAssignedbyAdvisor
|   advisorid | advisorname      |   departmentid |   NoOfStudents |
|------------:|:-----------------|---------------:|---------------:|
|         101 | Giovanni Alford  |           1000 |             18 |
|         102 | Milana Hagan     |           1000 |              9 |
|         103 | Fletcher Barrett |           1005 |             13 |
|         104 | Fariha Redfern   |           1005 |              9 |
|         105 | Rahim Contreras  |           1006 |             14 |
|         106 | Khalil Hilton    |           1007 |             16 |
|         107 | Dione Jefferson  |           1007 |             16 |
|         108 | Calum Ellwood    |           1006 |             13 |
|         109 | Sinead Coleman   |           1008 |             18 |
|         110 | Riaz Baldwin     |           1009 |             13 |


Table: NoOfStudentsByCourse
|   courseid | coursename                                |   TotalStudents |
|-----------:|:------------------------------------------|----------------:|
|       6000 | Web Design                                |             121 |
|       6001 | Web Tools and Methods                     |              17 |
|       6002 | UX Design and Testing                     |              60 |
|       6003 | Database Management and Design            |              53 |
|       6004 | Design Patterns                           |              57 |
|       6005 | Datawarehousing and Business Intelligence |             106 |
|       6007 | Application Engineering Development       |              54 |
|       6008 | Network Structures and Cloud Computing    |              10 |
|       6009 | Big Data Systems                          |              56 |
|       6010 | Program Structures and Algorithms         |              13 |


Table: NumberofCoursesByProfessors
|   professorID | professorName   |   CountOfCourses |
|--------------:|:----------------|-----------------:|
|           500 | Jadon Ponce     |                2 |
|           503 | Jacob Porter    |                2 |
|           505 | Haidar Jacobs   |                1 |
|           506 | Shakir Goulding |                2 |
|           508 | Ranveer Stamp   |                2 |
|           509 | Sumaiyah Herman |                2 |
|           511 | Vinny Norton    |                3 |
|           514 | Ann Storey      |                2 |
|           517 | Alara Rivera    |                2 |
|           518 | Angela Weston   |                2 |


Table: ProfContract
|   CProfID |   HourlyRate |
|----------:|-------------:|
|       503 |         60   |
|       504 |         55.5 |
|       507 |         65   |
|       508 |         70   |
|       514 |         66   |
|       515 |         67   |
|       516 |         62   |
|       517 |         68   |
|       518 |         72   |
|       519 |         77   |


Table: Professor
|   ProfessorID |   DepartmentID | ProfessorName   | Location      | ProfessorType   |
|--------------:|---------------:|:----------------|:--------------|:----------------|
|           500 |           1000 | Jadon Ponce     | Robinson 411  | P               |
|           501 |           1000 | Tess Steadman   | ISEC 321      | P               |
|           502 |           1002 | Jaydan Travis   | Richards 175  | P               |
|           503 |           1001 | Jacob Porter    | Richards 345  | C               |
|           504 |           1003 | Barry Duran     | Ell 250       | C               |
|           505 |           1003 | Haidar Jacobs   | Snell 001     | P               |
|           506 |           1004 | Shakir Goulding | Snell 004     | P               |
|           507 |           1006 | Gillian Hoffman | Churchill 345 | C               |
|           508 |           1008 | Ranveer Stamp   | Churchill 175 | C               |
|           509 |           1009 | Sumaiyah Herman | Richards 411  | P               |


Table: professorInfo
| campusname        |   campusid |   professorid | professorname   |   departmentid | departmentname         |   courseid | coursename            |
|:------------------|-----------:|--------------:|:----------------|---------------:|:-----------------------|-----------:|:----------------------|
| North East Campus |        200 |           500 | Jadon Ponce     |           1000 | Information Systems    |       6000 | Web Design            |
| North East Campus |        200 |           511 | Vinny Norton    |           1002 | Industrial Engineering |       6000 | Web Design            |
| West Campus       |        201 |           509 | Sumaiyah Herman |           1009 | Regulatory Laws        |       6001 | Web Tools and Methods |
| West Campus       |        201 |           517 | Alara Rivera    |           1010 | Bioinformatics         |       6001 | Web Tools and Methods |
| West Campus       |        201 |           500 | Jadon Ponce     |           1000 | Information Systems    |       6002 | UX Design and Testing |
| North Campus      |        202 |           500 | Jadon Ponce     |           1000 | Information Systems    |       6002 | UX Design and Testing |
| East West Campus  |        205 |           500 | Jadon Ponce     |           1000 | Information Systems    |       6002 | UX Design and Testing |
| West Campus       |        201 |           506 | Shakir Goulding |           1004 | Software Engineering   |       6002 | UX Design and Testing |
| North Campus      |        202 |           506 | Shakir Goulding |           1004 | Software Engineering   |       6002 | UX Design and Testing |
| East West Campus  |        205 |           506 | Shakir Goulding |           1004 | Software Engineering   |       6002 | UX Design and Testing |


Table: ProfPermanent
|   PProfID |   Salary |
|----------:|---------:|
|       500 |    50000 |
|       501 |    75000 |
|       502 |    80000 |
|       505 |    60000 |
|       506 |    70000 |
|       509 |    70000 |
|       510 |    50000 |
|       511 |    35000 |
|       512 |    40000 |
|       513 |    40000 |


Table: Section
|   SectionID | Location       |
|------------:|:---------------|
|           1 | Ell Hall       |
|           2 | Hayden Hall    |
|           3 | West Village   |
|           4 | East Village   |
|           5 | Dodge Hall     |
|           6 | Richards Hall  |
|           7 | Dodge Hall     |
|           8 | Robinson Hall  |
|           9 | Churchill Hall |
|          10 | Dodge Hall     |


Table: Staff
|   StaffID | StaffName      | StaffType   |
|----------:|:---------------|:------------|
|       300 | Arla Traynor   | P           |
|       301 | Niyah Solomon  | P           |
|       302 | Blythe Holt    | P           |
|       303 | Sherri Roman   | P           |
|       304 | Eren Cullen    | P           |
|       305 | Salim Patrick  | P           |
|       306 | Kaycee Duncan  | P           |
|       307 | Teresa Buckley | C           |
|       308 | Leanna Byrne   | C           |
|       309 | Kai Sharpe     | C           |


Table: StaffContract
|   CStaffID |   HourlyRate |
|-----------:|-------------:|
|        307 |         35.2 |
|        308 |         40.2 |
|        309 |         45.2 |
|        310 |         45   |
|        311 |         38   |
|        312 |         35   |
|        314 |         42   |
|        317 |         41   |
|        318 |         33   |
|        319 |         26   |


Table: StaffPermanent
|   PStaffID |   Salary |
|-----------:|---------:|
|        300 |    30000 |
|        301 |    40000 |
|        302 |    45000 |
|        303 |    50000 |
|        304 |    35000 |
|        305 |    15000 |
|        306 |    25000 |
|        313 |    35000 |
|        315 |    50000 |
|        316 |    47000 |


Table: Student
|   StudentID |   SectionID |   AdvisorID | StudentName         |   Semester |   Advisor.AdvisorID |   Advisor.DepartmentID | Advisor.AdvisorName   |   Section.SectionID | Username            |
|------------:|------------:|------------:|:--------------------|-----------:|--------------------:|-----------------------:|:----------------------|--------------------:|:--------------------|
|         196 |          20 |         105 | lauana candozo      |          3 |                 105 |                   1006 | Rahim Contreras       |                  20 | lauana candozo      |
|         201 |           7 |         110 | laubestein canel    |          3 |                 110 |                   1009 | Riaz Baldwin          |                   7 | laubestein canel    |
|         202 |          14 |         119 | laubin canela       |          3 |                 119 |                   1009 | Elizabeth Kingston    |                  14 | laubin canela       |
|         203 |          20 |         114 | lauby caneles       |          3 |                 114 |                   1000 | King Loius            |                  20 | lauby caneles       |
|         205 |          11 |         114 | lauchlann canellas  |          3 |                 114 |                   1000 | King Loius            |                  11 | lauchlann canellas  |
|         206 |           2 |         108 | lauchlen canelo     |          3 |                 108 |                   1006 | Calum Ellwood         |                   2 | lauchlen canelo     |
|         207 |           1 |         103 | lauchlin canepa     |          3 |                 103 |                   1005 | Fletcher Barrett      |                   1 | lauchlin canepa     |
|         208 |           9 |         112 | lauchlyn canerday   |          3 |                 112 |                   1006 | Henry Lord            |                   9 | lauchlyn canerday   |
|         209 |           6 |         107 | lauchlyn-lee canes  |          3 |                 107 |                   1007 | Dione Jefferson       |                   6 | lauchlyn-lee canes  |
|         210 |          15 |         109 | lauchner canestraro |          3 |                 109 |                   1008 | Sinead Coleman        |                  15 | lauchner canestraro |


Table: StudentsWithLowGrades
|   DepartmentID |   StudentID |   SectionID | StudentName        |   CourseID |   CGPA | Result   | CourseName   | CourseType   |   Semester |   ProfessorID | ProfessorName   | DepartmentName         |
|---------------:|------------:|------------:|:-------------------|-----------:|-------:|:---------|:-------------|:-------------|-----------:|--------------:|:----------------|:-----------------------|
|           1000 |         111 |           2 | Kareem Travers     |       6000 |   1.96 | Fail     | Web Design   | InPerson     |          1 |           500 | Jadon Ponce     | Information Systems    |
|           1002 |         111 |           2 | Kareem Travers     |       6000 |   1.96 | Fail     | Web Design   | InPerson     |          4 |           511 | Vinny Norton    | Industrial Engineering |
|           1000 |         128 |           7 | aadhan abaza       |       6000 |   1.91 | Fail     | Web Design   | InPerson     |          1 |           500 | Jadon Ponce     | Information Systems    |
|           1002 |         128 |           7 | aadhan abaza       |       6000 |   1.91 | Fail     | Web Design   | InPerson     |          4 |           511 | Vinny Norton    | Industrial Engineering |
|           1000 |         155 |          16 | latronda abdel     |       6000 |   2.18 | Fail     | Web Design   | InPerson     |          1 |           500 | Jadon Ponce     | Information Systems    |
|           1002 |         155 |          16 | latronda abdel     |       6000 |   2.18 | Fail     | Web Design   | InPerson     |          4 |           511 | Vinny Norton    | Industrial Engineering |
|           1000 |         182 |           1 | latvieu candelaria |       6000 |   1.13 | Fail     | Web Design   | InPerson     |          1 |           500 | Jadon Ponce     | Information Systems    |
|           1002 |         182 |           1 | latvieu candelaria |       6000 |   1.13 | Fail     | Web Design   | InPerson     |          4 |           511 | Vinny Norton    | Industrial Engineering |
|           1000 |         212 |           3 | lauda canestro     |       6000 |   1.77 | Fail     | Web Design   | InPerson     |          1 |           500 | Jadon Ponce     | Information Systems    |
|           1002 |         212 |           3 | lauda canestro     |       6000 |   1.77 | Fail     | Web Design   | InPerson     |          4 |           511 | Vinny Norton    | Industrial Engineering |


Table: Teaches
|   CourseID |   ProfessorID |   Semester | Term   |
|-----------:|--------------:|-----------:|:-------|
|       6000 |           500 |          1 | Fall   |
|       6000 |           511 |          4 | Summer |
|       6001 |           509 |          1 | Fall   |
|       6001 |           517 |          2 | Spring |
|       6002 |           500 |          3 | Summer |
|       6002 |           506 |          2 | Spring |
|       6003 |           503 |          4 | Fall   |
|       6003 |           514 |          3 | Summer |
|       6004 |           511 |          4 | Fall   |
|       6004 |           518 |          1 | Spring |


Table: UniversityCampus
|   CampusID | CampusName        | CampusLocation   |
|-----------:|:------------------|:-----------------|
|        200 | North East Campus | Boston           |
|        201 | West Campus       | Gainsville       |
|        202 | North Campus      | Chicago          |
|        203 | South Campus      | Long Beach       |
|        204 | Main Campus       | Raleigh          |
|        205 | East West Campus  | Buffalo          |
|        206 | South East Campus | Rochester        |
|        207 | North West Campus | New York City    |
|        208 | Sister Campus     | Madison          |
|        209 | Research Center   | Seattle          |

 


tables: name: Advisor
data: Advisor.csv
name: Building
data: Building.csv
name: CourseCatalog
data: CourseCatalog.csv
name: CourseOffering
data: CourseOffering.csv
name: CourseRegistration
data: CourseRegistration.csv
name: CourseRegistrationInsert
data: CourseRegistrationInsert.csv
name: Department
data: Department.csv
name: Grades
data: Grades.csv
name: GradesChange
data: GradesChange.csv
name: NoOfStudentsAssignedbyAdvisor
data: NoOfStudentsAssignedbyAdvisor.csv
name: NoOfStudentsByCourse
data: NoOfStudentsByCourse.csv
name: NumberofCoursesByProfessors
data: NumberofCoursesByProfessors.csv
name: ProfContract
data: ProfContract.csv
name: Professor
data: Professor.csv
name: professorInfo
data: professorInfo.csv
name: ProfPermanent
data: ProfPermanent.csv
name: Section
data: Section.csv
name: Staff
data: Staff.csv
name: StaffContract
data: StaffContract.csv
name: StaffPermanent
data: StaffPermanent.csv
name: Student
data: Student.csv
name: StudentsWithLowGrades
data: StudentsWithLowGrades.csv
name: Teaches
data: Teaches.csv
name: UniversityCampus
data: UniversityCampus.csv
label: Advisor
DepartmentID
Department
DepartmentID
Student
AdvisorID
Advisor
AdvisorID
Building
DepartmentID
Department
DepartmentID
Building
CampusID
UniversityCampus
CampusID
CourseCatalog
CourseID
CourseOffering
CourseID
CourseRegistration
CourseID
CourseOffering
CourseID
Grades
CourseID
CourseOffering
CourseID
Teaches
CourseID
CourseOffering
CourseID
CourseRegistration
StudentID
Student
StudentID
Grades
StudentID
Student
StudentID
Professor
DepartmentID
Department
DepartmentID
Professor
ProfessorID
ProfContract
CProfID
ProfPermanent
PProfID
Professor
ProfessorID
Teaches
ProfessorID
Professor
ProfessorID
Student
SectionID
Section
SectionID
StaffContract
CStaffID
Staff
StaffID
StaffPermanent
PStaffID
Staff
StaffID
NoOfStudentsAssignedbyAdvisor
advisorid
Advisor
AdvisorID
professorInfo
departmentid
Department
DepartmentID
StudentsWithLowGrades
DepartmentID
Department
DepartmentID
NoOfStudentsByCourse
courseid
CourseOffering
CourseID
professorInfo
courseid
CourseOffering
CourseID
StudentsWithLowGrades
CourseID
CourseOffering
CourseID
CourseRegistrationInsert
CourseID
CourseOffering
CourseID
GradesChange
CourseID
CourseOffering
CourseID
NumberofCoursesByProfessors
professorID
Professor
ProfessorID
professorInfo
campusname
UniversityCampus
CampusName
CourseCatalog
CampusID
UniversityCampus
CampusID
CourseRegistrationInsert
StudentID
Student
StudentID
GradesChange
StudentID
Student
StudentID
StudentsWithLowGrades
SectionID
Section
SectionID
CourseCatalog
CourseOffering.Grades.StudentID
Student
StudentID
output: {
    "joins": [
        {
            "from_table": "Advisor",
            "from_column": "DepartmentID",
            "to_table": "Department",
            "to_column": "DepartmentID"
        },
        {
            "from_table": "Student",
            "from_column": "AdvisorID",
            "to_table": "Advisor",
            "to_column": "AdvisorID"
        },
        {
            "from_table": "Building",
            "from_column": "DepartmentID",
            "to_table": "Department",
            "to_column": "DepartmentID"
        },
        {
            "from_table": "Building",
            "from_column": "CampusID",
            "to_table": "UniversityCampus",
            "to_column": "CampusID"
        },
        {
            "from_table": "CourseCatalog",
            "from_column": "CourseID",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "CourseRegistration",
            "from_column": "CourseID",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "Grades",
            "from_column": "CourseID",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "Teaches",
            "from_column": "CourseID",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "CourseRegistration",
            "from_column": "StudentID",
            "to_table": "Student",
            "to_column": "StudentID"
        },
        {
            "from_table": "Grades",
            "from_column": "StudentID",
            "to_table": "Student",
            "to_column": "StudentID"
        },
        {
            "from_table": "Professor",
            "from_column": "DepartmentID",
            "to_table": "Department",
            "to_column": "DepartmentID"
        },
        {
            "from_table": "Professor",
            "from_column": "ProfessorID",
            "to_table": "ProfContract",
            "to_column": "CProfID"
        },
        {
            "from_table": "ProfPermanent",
            "from_column": "PProfID",
            "to_table": "Professor",
            "to_column": "ProfessorID"
        },
        {
            "from_table": "Teaches",
            "from_column": "ProfessorID",
            "to_table": "Professor",
            "to_column": "ProfessorID"
        },
        {
            "from_table": "Student",
            "from_column": "SectionID",
            "to_table": "Section",
            "to_column": "SectionID"
        },
        {
            "from_table": "StaffContract",
            "from_column": "CStaffID",
            "to_table": "Staff",
            "to_column": "StaffID"
        },
        {
            "from_table": "StaffPermanent",
            "from_column": "PStaffID",
            "to_table": "Staff",
            "to_column": "StaffID"
        },
        {
            "from_table": "NoOfStudentsAssignedbyAdvisor",
            "from_column": "advisorid",
            "to_table": "Advisor",
            "to_column": "AdvisorID"
        },
        {
            "from_table": "professorInfo",
            "from_column": "departmentid",
            "to_table": "Department",
            "to_column": "DepartmentID"
        },
        {
            "from_table": "StudentsWithLowGrades",
            "from_column": "DepartmentID",
            "to_table": "Department",
            "to_column": "DepartmentID"
        },
        {
            "from_table": "NoOfStudentsByCourse",
            "from_column": "courseid",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "professorInfo",
            "from_column": "courseid",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "StudentsWithLowGrades",
            "from_column": "CourseID",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "CourseRegistrationInsert",
            "from_column": "CourseID",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "GradesChange",
            "from_column": "CourseID",
            "to_table": "CourseOffering",
            "to_column": "CourseID"
        },
        {
            "from_table": "NumberofCoursesByProfessors",
            "from_column": "professorID",
            "to_table": "Professor",
            "to_column": "ProfessorID"
        },
        {
            "from_table": "professorInfo",
            "from_column": "campusname",
            "to_table": "UniversityCampus",
            "to_column": "CampusName"
        },
        {
            "from_table": "CourseCatalog",
            "from_column": "CampusID",
            "to_table": "UniversityCampus",
            "to_column": "CampusID"
        },
        {
            "from_table": "CourseRegistrationInsert",
            "from_column": "StudentID",
            "to_table": "Student",
            "to_column": "StudentID"
        },
        {
            "from_table": "GradesChange",
            "from_column": "StudentID",
            "to_table": "Student",
            "to_column": "StudentID"
        },
        {
            "from_table": "StudentsWithLowGrades",
            "from_column": "SectionID",
            "to_table": "Section",
            "to_column": "SectionID"
        },
        {
            "from_table": "CourseCatalog",
            "from_column": "CourseOffering.Grades.StudentID",
            "to_table": "Student",
            "to_column": "StudentID"
        }
    ]
}