Find the total cost (total blocks transfer) using Merge Join =  _______ If the size of buffer is in memory = 4 blocks for r, 2 blocks for s and using Nested Loop Join,  what is total of block transfer? =  _______ What does the total block seek? =  _______

Given the SQL Database as the following: CREATE TABLE t1 (id integer, name text); INSERT INTO t1 VALUES (generate_series(1,10000), ‘Noname’);   And the NoSQL Database in MongoDB as the following: Collection t1 {     { id: 1, name: “Noname” },     { id: 2, name: “Noname” },     { id: 3, name: “Noname” },      …      { id: 10000, name: “Noname” }, } Create the shell commands in MongoDB that are equivalent as the following SQL Command:   SELECT id FROM t1 WHERE name=”Newname”; For example: SQL Command                                  MongoDB Shell Command SELECT * FROM t1;                          db.t1.find( ); or db.t1.find({ });

Given transaction T2 inserts index 0037. When T2 reached to the leaf node, it is safe? (True/False) 

             Transaction A can commit on this schedule? (True/False) 

                 Which transaction(s) need to rollback?                 (1 Point)         Which transaction(s) have to be killed?                 (1 Point)         Which transaction(s) can execute completely?     (1 Point)

Regarding to the following B+Tree(m=3), If we delete index key = all 3s, all 4s, insert 5 and 7, what is the B+Tree index after the operations?                                                         (5 Points)  (Note: please show each step, not only final answer). Please upload file to answer the question.  

     Given transaction T1 deletes index 0030.       What are the operations of T1 for each timeline (t1, t2 and t3)?      t1 _______ t2 _______ t3 _______

Given the SQL Database as the following: CREATE TABLE t1 (id integer, name text); INSERT INTO t1 VALUES (generate_series(1,10000), ‘Noname’);   And the NoSQL Database in MongoDB as the following: Collection t1 {     { id: 1, name: “Noname” },     { id: 2, name: “Noname” },     { id: 3, name: “Noname” },      …      { id: 10000, name: “Noname” }, } Create the shell commands in MongoDB that are equivalent as the following SQL Command:   SELECT name FROM t1 WHERE id>1000; For example: SQL Command                                  MongoDB Shell Command SELECT * FROM t1;                          db.t1.find( ); or db.t1.find({ });

Given query: Find all the names and phone numbers of the student who take classes in Summer 2025 and in ‘Biology’ department.         A.) Create the SQL command for this query? (3 Points)         B.) According to the SQL command, create the relational algebra expression? (3 Points)         C.) According to relational algebra expression, create an optimized relational expression tree? (4 Points)  Please upload file to answer the question.

              Deadlock occurred in this schedule? (True/False)