<<< Back - Next >>>

Challenge: Build a table for GPA!

Let's imagine that we want to connect each student to their GPA. How can we do this?

Things to consider:

• Where will we put the GPAs?

• What kind data type will they be?

• How will we connect each GPA to the correct student?

Solution

Step 1: Create a new table for GPAs

CREATE TABLE gpas (
    id INTEGER PRIMARY KEY,
    gpa DOUBLE PRECISION,
    id_student INTEGER,
    FOREIGN KEY (id_student) REFERENCES students(id)
);

Step 2: Populate the GPA table with GPA score and foreign key

INSERT INTO gpas (gpa, id_student) VALUES
    (2.67, 2),
    (3.9, 1),
    (1.23, 3),
    (4.0, 4);

<<< Back - Next >>>