Accounting information systems access and data analytics
Download the Fall_2019 database posted in the Access and Data Analytics Test Module under CONTENT on BeachBoard. 2.Ensure that primary keys are set and establish appropriate relationships among the tables: Stores, Vendors, Purchases, and Purchase_Items. Stores and Vendors should be linked to Purchases. Purchases should be linked to Purchase_Items. 3. Prepare the following queries, naming the queries qa, qb, qc, qd, corresponding to the identifying […]