Question: This is a tabular representation (company_table) of a simple database: Department DepartmentID Employeeld Surname Marketing AC 448967 Fitzhugh Logistics CC 231334 Johnson Logistics CC 232134
This is a tabular representation ("company_table") of a simple database: Department DepartmentID Employeeld Surname Marketing AC 448967 Fitzhugh Logistics CC 231334 Johnson Logistics CC 232134 Jenner Sales DC 114987 Terry IT PC 232134 Teller IT PC 14987 Patel ContractedHours Salary Level 18 6.22 35 3.16 35 3.15 12 5.20 4.16 4.22 14 35 (a) What do you expect the following SQL command to produce and why? Select Surname FROM company_table WHERE EmployeelD4.01; [2 marks) (b) (c) c) Write an SQL query to output Employee IDs of those employees who don't work in the IT department and have less than 30 hours of contracted hours? [2 marks] Write an SQL query to output the Surnames of all employees that do not work in a Department with Code "AC" or "DC"? [2 marks) Two systems contain metadata elements that may allow for them to interoperate. The first uses month as an identifier, within which there is a set of twelve three- lettered values from jan through to dec, whilst the second uses the German label monate and a selection of values from 0 to 11. Explain how these systems may be interoperable by reference to the four terms conceptual domain, value domain, data element concept, and data element. [4 marks) (d)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
