courses below consists of columns
PRIMARY KEY. There’s another table called
teachers, which has columns
id being the
Write a set of statements to:
create a new table
studentswith the following columns, data types and constraints.
column data type constraint id INTEGER NOT NULL, PRIMARY KEY name TEXT NOT NULL courseId INTEGER FOREIGN KEY on id in courses teacherId INTEGER FOREIGN KEY on id in teachers
add these record rows to the created table
students, in the given order.
id (INTEGER) name (TEXT) courseId (INTEGER) teacherId (INTEGER) 1 Grant 4 1 2 Henry 7 3