database

Give relational algebra expressions to calculate the following: (a) Stores in the East region with sales more than a million dollars. (b) First and last names (only) of managers of all stores in the East region (only). Do not assume that the contents of the relations are as shown. (So you cannot just look at the tables by yourself and know that the Tuple Charge and Primary Key Point stores are the ones in the east. You can rely on the relations having the attributes shown, though.) # EMP_CODE EMP_FNAME EMP_INITIAL EMP_TITLE Mr. EMP_LNAME Williamson John Ms. Ratula Nancy Lottie Jennie Greenboro Rumpersfro Smith Renselaer Ogallo EMP DOB STORE CODE 1984-05-21 00:00:00 3 1989-02-09 00:00:00 2 1981-10-02 00:00:00 4 1991-06-01 00:00:00 5 1979-11-23 00:00:00 3 1985-12-25 00:00:00 1 1982-07-31 00:00:00 3 1988-09-10 00:00:00 1 1975-04-19 00:00:00 2 Robert Os ZID > YOL