Added several transactions, a new advanced query, and made some changes in the desing to implement the functionalities