AFM341 Lecture Notes - Lecture 13: Hire Purchase, Class Diagram, W. M. Keck Observatory
Unlike forms, report doesn't allow users to edit database info
○
Financial statements to show stakeholders
e.g. of report: sales invoice to be mailed to customers.
○
The application of reports are limited only by data that have been stored in the database
○
information to decision makers.
Access allows for web
-
based forms
-
pages
, which allow data to be entered into the database in
real time from outside the database system
•
Access offers
macros
which are defined by users to automate processes such as opening a specific
form
•
e.g. PayPal modules that facilitates integration with the organization's PayPal account
○
Access's code can be altered by the use of
modules
•
SSS is a retail store that designs and manufacturers custom sunglasses
•
Requirement is that each payment from a customer must be clearly marked for one specific
sale
○
To promote sales, payments can be made periodically over the time based on a zero
-
interest
installment plan but a down payment is required.
•
Steve only collect data on his customers at the time they make their first purchase at the store. He
stores data on every customer because each customer is entitled to free cleanings and
adjustments.
•
Steve hires two employees Frank and Sandra who grant the customers and also act as cashiers.
They make weekly trips to Bank of America to deposit the cash receipts. The company has a few
bank accounts.
•
Steve's Stylin' Sunglasses
In the following figure, we use a UML class diagram to draft a data model for the sale process
•
Three general categories: resources, events, and agents
•
A data model that attributes for SSS's sale process
This is figure 4
-
2
•
The central column includes two events (i.e., business activities)
-
Sales and Cash Receipt
•
The Sales event involves one resource
-
Inventory and two agents
-
Salesperson and Customer
•
The Cash Receipt event involves Cash and Cashier and Customer
•
The two events are related. One would decrease the resource of SSS (selling inventories) which
leads to an increase in resource of SSS (collecting cash)
•
They are economic events involving exchanging resources with external agents (customer)
•
We can consider Cash as Bank Accounts and each record in Cash Receipt as a check from a
customer
•
Multiplicities in SSS's data model
AFM 341 Page 3
Document Summary
Unlike forms, report doesn"t allow users to edit database info e. g. of report: sales invoice to be mailed to customers. The application of reports are limited only by data that have been stored in the database. Access allows for web-based forms- pages, which allow data to be entered into the database in real time from outside the database system. Access offers macros which are defined by users to automate processes such as opening a specific form. Access"s code can be altered by the use of modules e. g. paypal modules that facilitates integration with the organization"s paypal account. Sss is a retail store that designs and manufacturers custom sunglasses. To promote sales, payments can be made periodically over the time based on a zero-interest installment plan but a down payment is required. Requirement is that each payment from a customer must be clearly marked for one specific sale.