Data Base

I. Depending on the inside of the write the acties of each of the foreign dhe 11.21 Figure 3.6 Ore posible database for the COMPANY EMPLOYEE Fra Maturu ) Se B 1234567891011000000 Prin T Wong 333445668 19670069 4900 56 5 Alice Zeta BRI 10111001 Categ. F 0001 Jos Wulo 543211641-06-20 201 Duter. TX F 0000S RamK Narayan 1983-06-15 TROR MOODS Joyce A English 183453460 1072-07-30 Re Horton. F2000 145000 5 Av OUTWORT 1000-2000DM00022 E Borg GESSO 100.0 450 KM000 NIL 1 3 . 5 . ET CANONS On DEPARTMENT D Penh Admin Head M 385465565 764301 1980 1990 01.06.10 5 5 A Retrieve the names of all employees who do not have supenisors 1221 Aas 8. Retrieve the SSN, name and department name for the employee whose FIRST_NAME contains and salary is between 40000 and 60000 order by FRST NAME Ascending using the Frames First Name name as Last Name Drame as Department Name 12121 Add atbute Job to the Employee Table 12 Outcome 2 15 Marks 02. Draw the ER diagram for the following Scenarios 231151 Dit deep Sipped. During het. Chartered by de finals Theme tangle retail comer. Betalcowanied by the maker way le deviation via my em hng da v HIL. Trang tin v n in ma avera Thu Trang tuan vui characterised by a chembet.rpetes flight and Ans: I. Depending on the inside of the write the acties of each of the foreign dhe 11.21 Figure 3.6 Ore posible database for the COMPANY EMPLOYEE Fra Maturu ) Se B 1234567891011000000 Prin T Wong 333445668 19670069 4900 56 5 Alice Zeta BRI 10111001 Categ. F 0001 Jos Wulo 543211641-06-20 201 Duter. TX F 0000S RamK Narayan 1983-06-15 TROR MOODS Joyce A English 183453460 1072-07-30 Re Horton. F2000 145000 5 Av OUTWORT 1000-2000DM00022 E Borg GESSO 100.0 450 KM000 NIL 1 3 . 5 . ET CANONS On DEPARTMENT D Penh Admin Head M 385465565 764301 1980 1990 01.06.10 5 5 A Retrieve the names of all employees who do not have supenisors 1221 Aas 8. Retrieve the SSN, name and department name for the employee whose FIRST_NAME contains and salary is between 40000 and 60000 order by FRST NAME Ascending using the Frames First Name name as Last Name Drame as Department Name 12121 Add atbute Job to the Employee Table 12 Outcome 2 15 Marks 02. Draw the ER diagram for the following Scenarios 231151 Dit deep Sipped. During het. Chartered by de finals Theme tangle retail comer. Betalcowanied by the maker way le deviation via my em hng da v HIL. Trang tin v n in ma avera Thu Trang tuan vui characterised by a chembet.rpetes flight and Ans