What is a Transaction Processing System?

Assignment Task

You are to develop a transaction processing system (TPS) in the form of a relational database. Along with the database you will need to develop a report.

The report will explain how each of the information processes is carried out in the developed TPS and the social and ethical issues impacting on the TPS and its users.

Description

You have been hired to design and develop a working TPS (database) that can be used to run a clothing store. The requirements for your information system are:

• A main menu that is hyperlinked to the main aspects of the database.
• A Minimum of three connected tables each table containing a minimum of twenty records.
• Appropriate input masks and data validation rules.
• A form for the tables that require frequent data entry by the store employees.
• Four appropriate queries insuring that at least two of the queries draw information from more than one table also one of the queries needs to be entered into the database using SQL. Where appropriate the queries should make use of participant data entry (variables).
• Two reports at least one of which includes a calculation.
• Appropriate use of macros to run the database.

This IT Computer Science has been solved by our PhD Experts at My Uni Paper.