Cal Poly Pomona ACC 305 - Project 3 (3 pages)

Previewing page 1 of 3 page document View the full content.
View Full Document

Project 3



Previewing page 1 of actual document.

View the full content.
View Full Document
View Full Document

Project 3

56 views


Pages:
3
School:
California State Polytechnic University, Pomona
Course:
Acc 305 - Advanced Accounting Information Systems

Unformatted text preview:

Project 3 100 pts 1 Design the Acquisition Payment AIS for a retail establishment of your group s choosing Write a narrative describing your purchasing procedures your store your supplier credit policies product pricing inventory tracking and costing REA events business process rules cardinalities anything that would aid in our understanding of the acquisition purchasing process of your business Explain all events in the narrative helps the design of tables 2 Design REA model complete with cardinalities and links on paper or in Excel Then implement your model completely into Access The links and model on the paper should match the ones in Access REF the model in Ch 9 pg 263 If the links on your group s REA model do not match the Access implementation the project receives no credit You design the model If you change something in Access it is up to you to go back and change it on the REA model 3 Design data in all tables able to use pictures Make the database professional a Inventory table should be at least 250 records research into inventory attributes adds points to the score The vendor table must be at least 100 records Event tables should have at least 100 records per table except for purchase returns that can be 25 records Cash table should have at least 10 cash accounts Employee table should have 50 employees If you rig the data in the table to make the database work it is quite easy to see that in the data structure Rigging the data structure in this fashion brings the grade of the project below C b Contents field and data are up to you Use the text for guidance as to table attributes 4 Queries at least 30 for groups of 3 and 40 for groups of 4 a Simple queries are based on 1 table b Complex queries are based on 2 or more tables c Include a description as to what question each query is asking in your narrative When I grade the project I will compare the query with the description in your write up Ask questions that will help you run the business efficiently



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Project 3 and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Project 3 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?