database

EMP LNAME EMP CODE EMP INITIAL EMP DOB STORE CODE 23 EMP TITLE EMP FNAME Mr. Williamson John 1984-05-21 00:00:00 3 Ratula Ms. Nancy 1989-02-09 00:00:00 2 Ms. Greenboro Lottie R 3 1981-10-02 00:00:00 4 Rumpersfro Jennie 4 Mrs. 1991-06-01 00:00:00 5 4. Mr. Smith Robert 1979-11-23 00:00:00 3 Mr. Renselaer Cary A. 1985-12-25 00:00:00 1 Roberto Mr. Ogallo 1982-07-31 00:00:00 3 Elizabeth Ms. Johnsson 8. 8. 1988-09-10 00:00:00 1 Mr. Eindsmar Jack 1975-04-19 00:00:00 2 Jones Mrs. Rose 1986-03-06 00:00:00 4 10 10 Mr. Broderick Tom 11 11 1992-10-21 00:00:00 3 Mr. Washington Alan 12 12 1994-09-08 00:00:00 2 13 Mr. Smith Peter 13 1984-08-25 00:00:00 3 Ms. Smith Sherry 1986-05-25 00:00:00 4 14 14 Olenko Mr. Howard 15 15 1984-05-24 00:00:00 5 Mr. Archialo Barry 16 16 1980-09-03 00:00:00 5 Ms. Grimaldo Jeanine 17 17 1990-11-12 00:00:00 4 Rosenberg Mr. Andrew 18 18 1991-01-24 00:00:00 4 Mr. Rosten Peter 19 19 1988-10-03 00:00:00 4 Mr. Mckee Robert 20 20 1990-03-06 00:00:00 1 Jennifer Ms. Baumann A 21 21 1994-12-11 00:00:00 3 STORE_CODE EMP CODE %23 STORE_NAME STORE_YTD_SALES REGION_CODE Access Junction 1003456 8 Database Corner 1421987 2 12 Tuple Charge 3 3 986783 Attribute Alley 4 4 944569 3 Primary Key Point 2930098 1 15 #3 REGION_CODE REGION_DESCRIPT East West 2. 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.)