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 |