Introduction to Computer Engineering Assignment for material covered in Weeks 9 and 10 15-12-2021 Due date: 25-12-2020 : Q1. Solve the following two parts and show all the steps of your work (refer to slides 23-24 in Lecture 1) Q4. Given the following Entity-relationship diagram, convert into table as discussed in the lecture. Remember the rectangle is an entity which becomes a table, and a relationship likes Has becomes a table. (refer to slide 31 in lecture 2 (Relational Model) Nome User M a) Consider the following circuit. Find the final outputs for the four cases when the Two inputs are 011, 110. Show all the intermediate results, that is draw four copies of this circuit and show your results on each of the four copies separately. Coach Check Duse O Checo N Does Checkin M ET M Has N Com Comment Comment Coach Comment Des b) Design two circuits of your own, in the first circuit use every gate discussed in the lecture at least once. In the second circuit use three of the circuits discussed in the lecture at least twice (2 times). For the two circuits you are free to connect the gates the way you prefer if your connections are correct as per the specifications of the gates (each gate has 2 inputs and one output except the invertor which has 1 input and 1 output. Q2. Convert the following numbers from their current base to the target base specified for each of them. 1. (703261) from base 8 to base 10 2. (703261) from base 10 to base 8 3. (10001111101010) from base 5 to base 10 4. (10001111101010) from base 2 to base 10 5. (11010101) from base 10 to base 2 6. (11010101) from base 2 to base 10 Q3. Given 90 students in a class, write an algorithm to input five marks of each student: assignments, quizzes, mid-exam, final and project, finds the average of the five marks assuming all have the same weight. Then classify the student as A, B, C, D, or F based on whether average is over 90, between 80 and 89, between 70 and 79, between 60 and 69 or below 59, respectively. Draw the flowchart of the algorithm