Discuss ACID properties, the CAP Theorem, and mobile database, as well as the problems of a mobile database. Then, present a high level design of a transaction processing model for the mobile database by applying the CAP Theorem. You can make any specific assumption on the characteristics of the application that the mobile database needs to support to narrow the scope of the design. You need to include the following in the design:

• Use 1 example to describe at least 1 problem with any one of the ACID properties that cannot be ensured for your transaction
• Use 1 example to describe the specific trade-off among CAP properties in your proposed transaction processing model
• Describe the rationale behind the trade-off and the pros and cons of your proposed transaction processing model