It is from this logical model that we can implement the AIS cycle into a database by creating tables in Access from the logical model tables.
using following REA model to create logical model like the example that i show below (example the logical model.png)
Implementation Example-The Logical Model
This is what your logical model should look like.
Table Name. Primary Key, Foreign Keys. Non-key Attributes
tbllnventory: Item#, Description, Standard Cost, List Price, QOH, Beg QOH Date
tbICash: Acct#, Bank, Acct #, Acct Type, Beg Cash Bal, Beg Cash Bal Date
tbICustomer: CustomerlD, First Name, Last Name, Street Address, City, State, Zip, Cell#, Credit limit, Email
tblSalesperson:SalesClerk#. First Name, Last Name, Street Address, City, State, Zip, Cellphone#, Birth date,
Marital status, start date, salary, SS#
tbISales: Sale#, ICustomerlDl. [SalesClerk#], Date
tbIRecCash: CR#. [CustomerlD], [SalesClerk#], [Sale#], [Acct#], Date, Amt Rec’d
tbISales/Inventory: [Sale#] [Item#],Qty Sold,
