Consider the following two-purty communication problem. Alice and Bob are spatially separated, and their only means of coommunication is through a noisy communication channel. Alice wants to send a randoen bit b to Bob using their sharesd channel. At the end of the protocol, Bob has a bit b'. Our goal is that the probability that 6=b is a high as posible. We consider three different protocols for achieving this task, protocols PA, Pn, and Pe. The three protocols are the same, except for steps 2 and 6. 1. Alice picks a bit b at random. She picks b = 0 with probability p = 0.2, and she picks b = 1 with complementary probability p= 0.8. 2A. Alice sets e = b. 21B. Alice sets e b. 20. Alice sets e =1-6. 3. Alice sends the bit e through the channel. 4. The channel is noisy, and it flips the bit with probability (0.1 if e= 0, and it flips the bit with probability 0.3 if e= 1. Let e denote the output of the channel. 5. Bob reccives the bit e. 6A. Bob sets . 6B. Bob ignores the bit e and he sets -1, regardless of whether d =0 or d=1. 6C. Bob sets =1-e. 7. Bob declares that "I am guesing that Alice sent the bit ." 1. For ench of three protocols, compute the probability Pr = 6. Compute the probability as an irreducible fraction (that is, answer eg. instead of #). Show your caleulations and succinetly explain your work. 2. At the top of your answer, include a table with the three probabilities. Give your probabilities with three significant digits, us in the example below. PA Pe 0.123 0.987

DBA time is saved thanks to the DBMS's query optimisation procedures.

Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…

Create Owner Table Insert Data