In: Accounting
1. draw a UML diagram that describes the Tablet Store's purchases and payment process.
2. using microsoft access implement a relational database from your UML class diagram. Identify at least three fields per table.
3. describe how you would use the relational database to determine the Tablet store's account payable
Answer:-
1-
.
2-
.
3-
In relational database, it’s easy to eliminate redundancy and
inconsistencies. Both the sales and accounts payable departments
may look up information about the customers. The information about
the company such as Dells, Apple and Samsung are entered only once
where both departments can access.
Relational database stores and retrieves data which is stored in
tables. It stores interrelated data. This interrelationship
therefore helps in querying the information about payments,
invoices ,and receipts hence it helps in determining the accounts
payable. The relational database therefore helps in query the
information which includes the tax system. This system helps in
determining the accounting phenomena as well as setting objects
with similar properties.