Accounting Information Systems Database Fundamentals Exercise (using Access) - General Instructions Version 8 This exercise is intended to help you know how a database is formed and structured. You will build this database from scratch using Access, define data elements (fields), establish relations, and query the database to generate meaningful summarized information. Although Access has been packaged into or superseded by more advanced database software, it is more than adequate to demonstrate and learn the database concepts required for this course. The Islanders Supreme Company is an electronics wholesale company that opened on 1/1/YY. In order to support the Company's operations, you are required to help set up a database to store data and transactions and eventually run queries to answer management inquiries. Requirement - Part 1 There are different types of tables forming a database; mainly 'master' tables and 'transaction' tables. After reviewing the master files and the business processes described by the data on next pages, design and build the database in Access (when you save and name the file in Access, use your first and last name, a hyphen then the version number [V#] assigned to you based on the last digit of your A#). Only include the tables and fields that are given AND used in the accounting cycle pertinent to your accounting cycle (one table given may end up not being used, so that table can be left out). Thirty (30) points will be taken off if certain fields which are not given in any transaction or activity are added to certain tables to go around database rules and design requirements (tables' relationships). Do not forget to link the tables using the relationships window (it is required to organize tables where Resources are on left, Events or transactions are in the center, and Agents are on the right; see REA Model of Chapter 17). Enforce referential integrity when linking tables (15 points off if no referential integrity is enforced). Requirement - Part 2