Method signatures

Method signatures define/describe:

  • the name/identifier of the method
  • the parameters of the method (identifier and data type)
  • the return type of the method eg void or int etc

Objectives

Students will be able to:

  • Create Inner Joins in an SQL Query

Relational Databases

Joins

Inner Joins

Normalizing a database often results in multiple tables being needed.

This might be problematic if we want to write SQL queries which need data from one table and related data from another table.

Fortunately we can join related data from database tables to produce a query result.

Watch the video and complete the worksheet.

Practical Activity - Course Enrollment

Objective

Write SQL queries which pull related data from multiple tables in order to produce a result.

Download the 3 csv files and save them in a project folder.

Create a new database in XAMPP called Enrollment.

Import the three files and create the following 3 tables:

  • Students
  • Courses
  • Enrollment

Make sure you identify a primary key for each table.

Now complete the worksheet activities.

Resources

Tags

methodCoding Bat recursion base case recursive call stack overflow returnunwind