Assalam o alaikum warahmatulahi wabarakatuhu Final Term ppr CS-312 8:00 AM The MCQs were very easy If you have prepared the handouts well, you'll find them manageable 😌 Short questions : 1. D/W inner Join & left outer join 2. How a relation can be converted into third normal form ? Identify different rules applied on the relation for this purpose. 3. Why calculated values are stored in database table in denormalization? 4. Consider following table Table : Student StID 1 , 2 , 3 , 4 , 5 StName Ali , Shahed , Naila , Ahmed , Qaiser CI Name MSC , BCS , MCS , MBA , BBA Gender M , M , F , F , M DELETE FROM Student where StID = 5 ; INSERT into student values ( ' 6 ' , ' Imran ' , ' MCS ' , 'M' ); You are required to provide resultant table after execution of following SQL queries.