a$)$ Let us consider the following scenario:

A video editor uses his computer system to read the raw footage from one database that $s_{?}$ available in one. After he finishes multiple edits, he writes the finished product $($Completed footage$)$ to another database in another node. In such a scenario, explain how CAP theorm allows us to work with the following possible characteristics?

Consistency & Availability $($CA database$)$

Consistency & Partitional Tolerance $($CP Database$)$

Availability & Partitional Tolerance $($AP Database$)$