project
| Author ID | Last Name | First Name | Phone Number | |
|---|---|---|---|---|
| AU-1 | Adams | Eric | eric168@yahoo.com | (714) 833-2419 |
| AU-2 | Brown | Jennifer | jenniferb@gmail.com | (619) 596-0012 |
| AU-3 | Davis | Keith | keithd@gmail.com | (212) 342-5680 |
| AU-4 | Newport | Kevin | kevinn@hotmail.com | (301) 947-7741 |
| AU-5 | Pham | John | johnpham@gmail.com | (617) 645-3647 |
| AU-6 | Sviokla | Julia | jsviokla@yahoo.com | (805) 498-1688 |
| Author ID | Book ID |
|---|---|
| AU-1 | B-2 |
| AU-1 | B-5 |
| AU-2 | B-6 |
| AU-3 | B-2 |
| AU-3 | B-3 |
| AU-4 | B-2 |
| AU-5 | B-4 |
| AU-6 | B-1 |
| AU-6 | B-6 |
| Book ID | Title | Area | Year | Edition | Publisher |
|---|---|---|---|---|---|
| B-1 | Accounting Principles | Financial Accounting | 2021 | 8 | Wiley |
| B-2 | Cost Management | Management Accounting | 2022 | 3 | McGraw-Hill |
| B-3 | Accounting Information Systems | Information Systems | 2022 | 2 | McGraw-Hill |
| B-4 | Individual Taxation 2017 | Taxation | 2023 | 6 | Pearson |
| B-5 | Intermediate Accounting | Financial Accounting | 2021 | 1 | Wiley |
| B-6 | Advanced Accounting | Financial Accounting | 2022 | 1 | McGraw-Hill |
| Customer ID | Last Name | First Name | |
|---|---|---|---|
| C-1 | Black | Emily | ewb2003@yahoo.com |
| C-2 | Brown | Jack | jackjack@gmail.com |
| C-3 | Easton | Anderson | anderson.easton@gmail.com |
| C-4 | Jennix | May | jennixm@hotmail.com |
| C-5 | Venable | Judy | Judy.Venable@gmail.com |
| C-6 | White | Ashley | Ashley2015@yahoo.com |
| C-7 | Williams | Eric | Williams_e@yahoo.com |
| Sales Date | Customer ID | Book ID | Quantity | Unit Price |
|---|---|---|---|---|
| 2023-09-01 | C-1 | B-6 | 30 | ¤ 195.00 |
| 2023-09-03 | C-2 | B-1 | 1 | ¤ 221.00 |
| 2023-09-02 | C-3 | B-2 | 1 | ¤ 245.00 |
| 2023-09-02 | C-3 | B-4 | 1 | ¤ 160.00 |
| 2023-09-02 | C-3 | B-6 | 1 | ¤ 215.00 |
| 2023-09-02 | C-5 | B-2 | 60 | ¤ 199.00 |
| 2023-09-02 | C-5 | B-5 | 25 | ¤ 210.00 |
| 2023-09-01 | C-7 | B-1 | 1 | ¤ 221.00 |
| 2023-09-01 | C-7 | B-3 | 1 | ¤ 205.00 |