ID | Name |
---|---|
1 | Fiction |
2 | Nonfiction |
3 | Mystery |
4 | Science Fiction |
5 | Adventure |
ID | GroupName |
---|---|
1 | Children's Book |
2 | Young Adult Book |
3 | Teenage Book |
4 | Adult Book |
5 | Older Readers Book |
ID | FirstName | LastName | Biography |
---|---|---|---|
1 | John | Doe | He is a famous author. |
2 | Jane | Smith | She is an illustrator. |
3 | Emily | Brown | She writes science fiction novels. |
4 | Michael | White | He has written many mystery books. |
5 | Linda | Green | She writes adventure stories. |
ID | Fullname |
---|---|
1 | Jane Smith |
2 | Robert Johnson |
3 | William Brown |
4 | David White |
5 | Mark Green |
ID | CompanyName | Address | PhoneNumber |
---|---|---|---|
1 | Random House | New York, USA | +1 212-598-6000 |
2 | HarperCollins | London, UK | +44 207-867-8000 |
3 | Macmillan Publishers | Berlin, Germany | +49 30-260-00-0 |
4 | Simon & Schuster | New York, USA | +1 212-698-7000 |
5 | Hachette Book Group | Paris, France | +33 1-55-62-20-00 |
ID | Title | Summary | ReleaseDate | Price | GenreID | AgeGroupID | AuthorID | IllustratorID | PublisherID |
---|---|---|---|---|---|---|---|---|---|
(→ Genre.ID) | (→ AgeGroup.ID) | (→ Author.ID) | (→ Illustrator.ID) | (→ Publisher.ID) | |||||
1 | Book A | Summary of book A. | 2021-01-01 | 9.99 | 1 | 1 | 1 | 1 | 1 |
2 | Book B | Summary of book B. | 2021-02-01 | 12.99 | 2 | 1 | 2 | 1 | 2 |
3 | Book C | Summary of book C. | 2021-03-01 | 14.99 | 3 | 2 | 3 | 2 | 3 |
4 | Book D | Summary of book D. | 2021-04-01 | 10.99 | 4 | 1 | 4 | 1 | 4 |
5 | Book E | Summary of book E. | 2021-05-01 | 11.99 | 5 | 2 | 5 | 1 | 5 |