project

Author ID	Last Name	First Name	Email	Phone Number
AU-1	Adams	Eric	[email protected]	(714) 833-2419
AU-2	Brown	Jennifer	[email protected]	(619) 596-0012
AU-3	Davis	Keith	[email protected]	(212) 342-5680
AU-4	Newport	Kevin	[email protected]	(301) 947-7741
AU-5	Pham	John	[email protected]	(617) 645-3647
AU-6	Sviokla	Julia	[email protected]	(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	Email
C-1	Black	Emily	[email protected]
C-2	Brown	Jack	[email protected]
C-3	Easton	Anderson	[email protected]
C-4	Jennix	May	[email protected]
C-5	Venable	Judy	[email protected]
C-6	White	Ashley	[email protected]
C-7	Williams	Eric	[email protected]

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