Q1 1,2 Q2 3,4 03 2,3 04 4,9 Program Outcomes Learning Outcomes 3,4 2 1,2,3,4 15 1) Database (25 Points) a) For a cellular telephone company design a table to store each phone call transaction. Show the field names and type according to your design. b) Add a new record to this table (values depend on your design you can assign any value) c) Each phone belongs to a person which information should be store for billing? Design a new table for this new table. d) Update the phone number of a record whose name is your name. (Values depend on your coice and design) e) How you can connect these two tables? (in 'a' and 'b') 2) Operating System (25 Points) Process Id Arrival time Burst time Priority PO 0 4 1 P1 1 2 3 P2 2 7 4 P3 2 5 P4 18 8 2 P5 20 3 5 P6 21 12 3 P7 23 2 P8 5 4 P9 29 9 5 a) Draw The Gannt Chart and calculate Average Turn Around time Average waiting time for the above process order with the Round Robin Algorithm. And Priority Based Algortihm. Explain your answer. b) Draw the Gannt Chart with the First Come First Serve Algorithm if we have 3 PROCESSORS. Explain your answer. 25 No