| id | first_name | last_name |
|---|---|---|
| 11 | Ellen | Writer |
| 12 | Olga | Savelieva |
| 13 | Jack | Smart |
| 14 | Donald | Brain |
| 15 | Yao | Dou |
| RMA | Book Id | Customer ID | Quantity | Price | Date |
|---|---|---|---|---|---|
| Rma001 | 9 | c1 | 10 | 34.95 | 05/01/2022 |
| rma020 | 8 | c2 | 3 | 29.95 | 05/01/2022 |
| rmA030 | 7 | c2 | 5 | 18.99 | 05/01/2022 |
| RMA040 | 9 | c3 | 1 | 59.99 | 05/02/2022 |
| rma005 | 1 | c1 | 1 | 90 | 05/02/2022 |
| RMA600 | 2 | c4 | 100 | 65.49 | 05/03/2022 |
| Rma701 | 3 | c4 | 150 | 24.95 | 05/03/2022 |
| RmA800 | 4 | c4 | 50 | 19.99 | 05/03/2022 |
| RMA900 | 7 | c1 | 1 | 33.97 | 05/04/2022 |
| rma1010 | 7 | c2 | 100 | 17.99 | 05/04/2022 |
| Invoice | Book Id | Customer ID | Quantity | Price | Date |
|---|---|---|---|---|---|
| I7200 | 9 | C1 | 10 | 34.95 | 05/01/2022 |
| I7201 | 8 | C2 | 3 | 29.95 | 05/01/2022 |
| I7201 | 7 | C2 | 5 | 18.99 | 05/01/2022 |
| I7202 | 9 | C3 | 1 | 59.99 | 05/02/2022 |
| I7203 | 1 | 1 | 90 | 05/02/2022 | |
| I7204 | 2 | C4 | 100 | 65.49 | 05/03/2022 |
| I7204 | 3 | C4 | 150 | 24.95 | 05/03/2022 |
| I7204 | 4 | C4 | 50 | 19.99 | 05/03/2022 |
| I7205 | 7 | C1 | 1 | 33.97 | 05/04/2022 |
| I7206 | 7 | C2 | 100 | 17.99 | 05/04/2022 |
| id | title | type | author id | editor id | translator id |
|---|---|---|---|---|---|
| 1 | Time to Grow Up! | original | 11 | 21 | |
| 2 | Your Trip | translated | 15 | 22 | 32 |
| 3 | Lovely Love | original | 14 | 24 | |
| 4 | Dream Your Life | original | 11 | 24 | |
| 5 | Oranges | translated | 12 | 25 | 31 |
| 6 | Your Happy Life | translated | 15 | 22 | 33 |
| 7 | Applied AI | translated | 13 | 23 | 34 |
| 9 | Book with Mysterious Author | translated | 1 | 23 | 34 |
| 8 | My Last Book | original | 11 | 28 |
| ID | Name | Address | City | Phone | |
|---|---|---|---|---|---|
| C1 | Numereo Uno | 101 One Way | One Point City | 9051112111 | bigOne@gmail.com |
| C2 | Dewy Tuesdays | 202 Second St. | Second City | 4162022222 | twoguys@gmail.com |
| C3 | Tres Buon Goods | 3 Way St | Tres City | 5193133303 | thrice@hotmail.com |
| C4 | ForMe Resellers | 40 Four St | FourtNight City | 2894441234 | fourtimes@hotmail.com |
| C5 | Fe Fi Fo Giant Tiger | 5 ohFive St. | FifthDom | 4165551234 | fiver@gmail.com |
| C6 | Sx in Cars | 6 Seventh St | Sx City | 6661116666 | gotyourSix@hotmail.com |
| C7 | 7th Heaven | 7 Eight Crt. | Lucky City | 5551117777 | timesAcharm@gmail.com |
| id | first name | last name |
|---|---|---|
| 13 | Jack | Smart |
| 21 | Daniel | Brown |
| 22 | Mark | Johnson |
| 23 | Maria | Evans |
| 24 | Cathrine | Roberts |
| 25 | Sebastian | Wright |
| 26 | Barbara | Jones |
| 27 | Matthew | Smith |
| 50 | Jack | Dumb |
| 51 | Daniel | Smart |
| id | first_name | last_name |
|---|---|---|
| 31 | Ira | Davies |
| 32 | Ling | Weng |
| 33 | Kristian | Green |
| 34 | Roman | Edwards |