Q1

ESST 1005 A2 2018.doox Compatibility Mode]- Word (Product Activation Failed) Mailings out References Review View Tell me what you want to do , : .A--. 11Norrmall 1 No Spac Heading 1 Heading 2 T ont Paragraph l. Given the relations: Styles EMPLOYEEEmpID, Name, Address, NISnumber) JOB(JobID, Job Title. SkillCode. Dept) ASSIGNMENT EmpID JobID, StartDate, EndDate) (note that if EndDate isthat person is still employed in that assignment (post) Use the relational algebra operations SELECT, PROJECT and JOIN to write a sequence of instructions to answer the following queries (a) List the names and address of the company's employees. (b) List the name and address of those who have worked or are working in the PERSONEL department (c) Retrieve the JoblD, StartDate and EndDate for each job in the ACCOUNTING department (d) Retrieve the Name, Address, Joblitle and Dept of every current employee (e) Write SQL statements for each of the above. 2. What is meant by each of the following terms? (i) cloud computing () vrtualization (iii) big data (iv) internet of things JJs is a small catering business and has a problem with unstructured data. Details of previous and current catering jobs and details about JJs suppliers are currently stored on paper desk. As JJs catering business 3. in file cabinets or on notebooks kept on the manager's desk or on the receptionist is growing, the owner wants you to set up a database system