The table courses below consists of columns id, name and abbreviatedName with id as PRIMARY KEY. There's another table called teachers, which has columns id and name, with id being the PRIMARY KEY.
Write a set of statements to:
- create a new table
students with 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 |