Authors

AuthorIDNameBirthDate
1John Smith1970-01-01
2Jane Doe1982-06-15
3Alice Johnson1963-08-22
4Bob Brown1958-11-11
5Tom Davis1969-05-25

Books

BookIDTitlePublishYearGenreCrime_FictionStudio
(→ Genres.Name)(→ Studios.Studio)
1The Mysterious Case2000MysteryYesWarner Bros
2Deadly Secrets2001MysteryNoDisney
3Twisted Fate2002ThrillerYesWarner Bros
4Dark Desires2003ThrillerNoUniversal

Genres

Name
Mystery
Thriller

Studios

StudioIDStudio
1Warner Bros
2Disney
3Universal

Characters

CharacterIDNameRoleBookIDAUTHOR_ID
(→ Books.BookID)(→ Authors.AuthorID)
1Detective AceLead Detective11
2Dr. EvelynMedical Examiner11
3Agent LeeFBI Agent22
4Morgan BlackCriminal Mastermind22
5Chris RedfieldPolice Officer33
6Silva HightowerGang Leader33

Reviews

ReviewIDRatingTextBookID
(→ Books.BookID)
15Great book! Loved it.1
24Interesting story but could have been better.2
33Not my favorite mystery novel.1
45Excellent thriller! Highly recommended.3
53Good story but lacked suspense.2