Question

Consider a table employee with attributes employeeid (primary key), employeename, joblevel,
dateofjoining, location, salary and contactnum.
The columns employeename, joblevel and dateofjoining are non unique. The table has three
indexes as follows:
IDX1 - employeename, contactnum
IDX2 - location​

Answer 1

Answer:

1. Where location = 'Seattle' and joblevel = 3

2. Where employeeid = 7001 and dateofjoining = '25-Mar-19'

Answer 2

Answer:

The answer to the given question :

where loc = 'seattle' and jblev = 3

where empid = 7001 and doj = '25 Mar 19'

Explanation:

The answer to the given question :

where loc = 'seattle' and jblev = 3

where empid = 7001 and doj = '25 Mar 19'

notations :

loc = location

jblev= joblevel

empid = employeeid

doj = dateofjoining

#SPJ3