# Database: Relational Schema Exercise - Novel Characters Authors

Name: _________________________________

5 points.

## Original problem and solution

> 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 copyright year.

Here is a solution.

## Additional problem - multiple authors

This database has proven so popular that other English majors want to add their information to it, but they are studying other authors. How would you use an Author table (arbitrary id and name fields) to solve this problem?

Show the Author table and the necessary foreign keys, bridging tables, or whatever Show relationships with the appropriate cardinality.

### Constraints

Assume the following.

- The only personal infomation you need about an author is the name.
- An author can write more than one novel.
- Each novel is written by only one author.
- A character can appear in the novels of more than one author (eg, the president of the US appears in many spy novels).