1CREATE TABLE track(
2 trackid INTEGER,
3 trackname TEXT,
4 trackartist INTEGER,
5 FOREIGN KEY(trackartist) REFERENCES artist(artistid)
6);
1CREATE TABLE supplier_groups (
2 group_id integer PRIMARY KEY,
3 group_name text NOT NULL
4);
5
6CREATE TABLE suppliers (
7 supplier_id INTEGER PRIMARY KEY,
8 supplier_name TEXT NOT NULL,
9 group_id INTEGER NOT NULL,
10 FOREIGN KEY (group_id)
11 REFERENCES supplier_groups (group_id)
12);
13Code language: SQL (Structured Query Language) (sql)