1 KING KHALID UNIVERSITY College of science and art, tanomah Department of computer science Examination: Practical Subject code: 332 ISM-5 Full marks (10) Name /..University number /. Date: 8/7/1444 advanced Data base management systems Time: one hour Answer all questions Employee2 EM_N0 EM_NAME AGE ADDRESS EM_SALARY EM_DEPT EM_GANDER 11 MOHAMMED 40 DAMMAM 9000 Operation Male 22 TARIG 35 BISHA 10500 Support Male 33 NASER 40 ABHA 9000 Operation Male 44 NOVA 22 JEDDAH 7500 Analytics Female 55 ESRAA 20 MECCA 2500 Sales Female 66 KHALID 29 TAIF 3200 Analytics Male 77 BATA 20 JEIZAN 2500 Sales Female 88 ALI 33 ABHA 12500 Operation Male 99 NAWAF 32 ALBAHA 7500 Support Male 21 AFNAN 40 JEDDAH 9000 Analytics Female 23 SHADEN 20 TAIF 2500 Sales Female 1. The create table above? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- 2. Enter the data on table? 2 3. Improve salaries that are add 100? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- 4. Show the names of the employees whose names begin with the second letter A and their salaries? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- 5. Show all data for Mohammed, KHALID NOVA and SHADEN? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- 6. Show all data so that the salary is not equal ( 6000 between 4000)? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- 7. View all employee data from Ali to Mohammad ordered? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- 8. Show all employee data in the Analytics department and they are male? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- ------------------------------------------------------------------------------ 9. Show all employee data, address, city of Jeddah, or age greater than or equal to 35? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- 10.Show all employee data that does not belong to the operation department? --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- Good luck

2. Enter the data on table? 3. Improve salaries that are add 100 ? 4. Show the names of the employees whose names begin with the second letter A and their salaries? 5. Show all data for Mohammed, KHALID NOVA and SHADEN? 6. Show all data so that the salary is not equal ( 6000 between 4000 )? 7. View all employee data from Ali to Mohammad ordered? 8. Show all employee data in the Analytics department and they are male? 9. Show all employee data, address, city of Jeddah, or age greater than or equal to 35 ? 10. Show all employee data that does not belong to the operation department? Good luck 2