create table Student( id integer primary key, name text, ... ); create table Enrolled( stude integer references Student(id), subj text references Subject(code), ... ); create table Subject( code text primary key, title text, ... );