# Database: SELECT Exercise - Novel Characters

Name: _________________________________

The original problem was

> 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 publication.

Here is a solution.

### Additional problem - SQL Queries

1. (2 points) Show all novels (`novel_year` and `novel_title`). Order by the year first published.
2. (2 points) Show all novels (`novel_title`) and characters (`character_name`) in them.
3. (2 points) Show all characters (`character_name`) that appeared in novels which were copyrighted between 1930 and 1940. Don't include duplicates.