*Paper Review!* City: Lahore Campus: Lhr59 Time:6:30 Exam: CS403P Name: German Language Instructor Almost 16 Mcqs was from VU Gateway video and 2 Long questions was from that video too. *Long Questions* 1. Make symbol of Process, Data Store, Data Flow, Collector, External Entity 2. a.Create index on Teacher on attribute TeacherID b. Create index on Teacher on attribute TeacherID, Teacher name. 3. Tables X and Y was given I had to perform Part(a) X∩Y Part(b) Prove X∩Y = Y∩X 4. Employee (empID, empname, empdept, empsalary, empqual) Values (E101, Ali, CS, 24000, Master), (E102, Aisha, Mgt, 45000, Mphil), (E103, Aiza, Mgt, 45000, Master), (E103, Aiza, CS, 65000, Phd), *SQL Query:* Select empname, empdept, Min(empsalary) From Employee AS 'Minimum Salary' Group by empd