REA Model Individual Project

The Computer Warehouse sells computer hardware, software, and supplies (such as paper). Individual customers just walk into the store, select merchandise, and must pay for their purchases in full before leaving the store. Corporate customers, however, call in orders in advance, so that the items are waiting to be picked up. Corporate customers may charge their purchases to their account. The Computer Warehouse mails corporate customers monthly statements that summarize all purchases made the prior month. Corporate customers pay the entire balance, as listed on the monthly statement, with one check or EFT transaction.

a) REA diagram for the computer warehouse revenue cycle:

https://docs.google.com/document/d/1WxNwLOiJzGnp8tFMtje3ScOncbumYNlmXBCRFofBzx4/edit

link shares with everyone

b) Data dictionary

Tables	Primary Key	Foreign Key(s)	Other Attributes (Sample Attributes)
Customer	CustomerNum		CustomerName, CustomerAddress, ContactNumber, CreditLimit
Employee	EmployeeNum		EmployeeName, EmployeeAddress, DateHired
Sales	InvoiceNum	CustomerNum, EmployeeNum, RemittanceNum	SaleDate, InvoiceTotal
Receive Cash	RemittanceNum	CustomerNum, EmployeeNum, AccountNum	ReceiveCashDate, ReceiveCashTime
Cash	AccountNum		Beginning-balance, TypeOfAccount
Inventory	ProductNum		Description, ListPrice, QuantityOnHand, ReorderQuantity, ReorderPoint
InverntorySale (bridge table)	InvoiceNum, ProductNum (one composite primary key)	InvoiceNum, ProductNum (two foreign keys)	NumberofSale, QuotedPrice

Based on the above REA diagram and data dictionary, implement this database design to MS ACCESS by finishing the following steps. Please note that Access workshop tutorial is an excellent resource for helping with this project.

1. Make a set of tables. For each table, identify a primary key, identify foreign key(s) if any, identify several other attributes. The Data Dictionary shows sample examples of primary key, foreign key(s), and other attributes for your reference.
2. Show relationships between tables
3. If there is a many to many relationship, create a bridge table and identify the primary key, foreign keys and other attributes.
4. Make at least five rows sample data for each table
5. Make the following forms: customer, employee, inventory, cash, sales, receive cash. Please make sure to create at least one form with subform.
6. Make at least two financial reports
7. MAke a switchboard to navigate to all forms and reports