Predicting results in an embryo (4 pts) A) predict the phenotype at a specific stage of the organism for each experimental/mutant scenario. B) explain the reasoning that led you to your prediction.   A frog egg at gastrulation that is maternal zygotic (the embryo is affected because the mother had a mutation) that caused sperm GPCR receptors  localize to the vegetal pole of the oocyte.

Describe events prior to and during fertilization that help lead to establishing the localized signaling pathway that creates an anterior/posterior axis of dorsal mesoderm. You can choose this in any animal that was discussed in this section. (sea urchin, fly, frog, avian, mammal, human). Choose the animal you feel most confident in describing how these events occurred.

During gastrulation in frogs the bottle cells are the first cells to initiate the inward motion of creating the dorsal lip.  Design an experiment in which you determine if the dorsal lip cells are sufficient for gastrulation.

Spemann used his daughter’s hair to aide in his demonstration that the early newt embryo has an organizing center that is either conditionally or autonomously specified.  (4 pts) Explain how the first division had to occur before he separated the two-cell embryo into two individual cells to demonstrate autonomous specification. Explain the molecular signaling that was discovered almost 40 years later to back up Spemann’s experiments that was discussed in class related to frogs.

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.