Question: a) Which relational algebra expression corresponds to the query Find the names and cities of residence of all employees who work for First Bank Corporation?
a) Which relational algebra expression corresponds to the query Find the names and cities of residence of all employees who work for "First Bank Corporation"? nerme city (employee (compe=First Bank Corporation (works) nem, street, city (companyame="First Blank Corporation" wlery > 10000) (works X employee)) b) Teretneme (compenwume = "First Bank Corporation" (works)) d) It is not possible to express this query in relational algebra. c) 14) Nulis may be used in a database table when an actual value is either unknown or does not exist (True) 15) Projection is a relational operator that extracts specified from a relation a) columns b) rows c) cells d) views 16) Which query creates a projection of the depName and locID columns from the Departments table? a) SELECT depName, locID FROM Departments; b) SELECT DISTINCT depName, locID FROM Departments; c) SELECT depName, locID FROM Dept; d) SELECT dep Name AS "locID" FROM Departments; 17) The Salary column of the EMPLOYEES table has a data type of NUMBER(8,2). Which Salary value will not be permitted in this column? a) 12345678 b) 123456.78 c) 123456 d)12.34
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
