| 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 |
| 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 |
| Name |
|---|
| Mystery |
| Thriller |
| StudioID | Studio |
|---|---|
| 1 | Warner Bros |
| 2 | Disney |
| 3 | Universal |
| 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 |
| 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 |