SQLite foreign key examples

I am not an expert in sql / sqlite.. suppose we have two tables:

CREATE TABLE child (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
);

CREATE TABLE MyTableB(
  dog TEXT, 
  FOREIGN KEY(dogList) REFERENCES child(id)
);

how will the INSERT? is correct my createTable operations? I would like to have: a child can have more than one dog a dog can have more children

EDIT

What if I wanted all the children and for each child a list of dogs associated with that child?