## Authors

AuthorID | Name | BirthDate
--- | --- | ---
1 | John Smith | 1970-01-01
2 | Jane Doe | 1982-06-15
3 | Alice Johnson | 1963-08-22
4 | Bob Brown | 1958-11-11
5 | Tom Davis | 1969-05-25

## Books

BookID | Title | PublishYear | Genre | Crime_Fiction | Studio
--- | --- | --- | --- | --- | ---
|  |  | (→ Genres.Name) |  | (→ Studios.Studio)
1 | The Mysterious Case | 2000 | Mystery | Yes | Warner Bros
2 | Deadly Secrets | 2001 | Mystery | No | Disney
3 | Twisted Fate | 2002 | Thriller | Yes | Warner Bros
4 | Dark Desires | 2003 | Thriller | No | Universal

## Genres

Name
Mystery
Thriller

## Studios

StudioID | Studio
--- | ---
1 | Warner Bros
2 | Disney
3 | Universal

## Characters

CharacterID | Name | Role | BookID | AUTHOR_ID
--- | --- | --- | --- | ---
|  |  | (→ Books.BookID) | (→ Authors.AuthorID)
1 | Detective Ace | Lead Detective | 1 | 1
2 | Dr. Evelyn | Medical Examiner | 1 | 1
3 | Agent Lee | FBI Agent | 2 | 2
4 | Morgan Black | Criminal Mastermind | 2 | 2
5 | Chris Redfield | Police Officer | 3 | 3
6 | Silva Hightower | Gang Leader | 3 | 3

## Reviews

ReviewID | Rating | Text | BookID
--- | --- | --- | ---
|  |  | (→ Books.BookID)
1 | 5 | Great book! Loved it. | 1
2 | 4 | Interesting story but could have been better. | 2
3 | 3 | Not my favorite mystery novel. | 1
4 | 5 | Excellent thriller! Highly recommended. | 3
5 | 3 | Good story but lacked suspense. | 2