# Database: Relational Schema Exercise - Novel Characters

Name: _________________________________

5 points.

Your friend, an English major, is studying the novels of an author, and is especially interested in the characters and which novels they appear in. Some characters appear in many novels, some in a few, and some only in one.

Show a relational schema that represents this information. Use an arbitrary key for the novels and the characters. For a novel include the title and year of first.