Answer Happy

Question 17 Table name: EMPLOYEE EMP CODE EMP TITLE EMP UNAME EMP FNAME EMP INITIAL EMP DOB STORE CODE 1 Mr. John W 2 Ms. 3 Ms. 4 Mrs 5 Mr. 6 Mr 7 Mr. 8 Ms 9 Mr. 10 Mrs. 11 Mr 12 Mr. 13 Mr. 14 Mo 15 Mr. 16 Mr. 17 Ms 18 Mr. 19 Mr 20 M 21 Ms. Williamson Ratula Greenboro Rumperstro Smith Renselaer Ogalo Johnsson Endsmar Jones Jack Rose Tom Broderick Washington Alan Peter Sherry Howard Smith Smith Olenko Archalo Grimaldo Rosenberg Rosten Mckee Baumann Nancy Lottie 2 Database Comer 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point Table name: REGION REGION CODE REGION DESCRIPT 1 East 2 West Jennie Robert Cary Roberto Elizabeth Barry Jeanine Andrew Peter Robert Jennifer h R S 1003455.76 1421907 39 986783 22 9445600 56 2930098 45 L A S W R Y N H U V K D S Table name: STORE STORE CODE STORE NAME STORE YTD SALES REGION CODE EMP CODE 1 Access Junction 1 2 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 25-Aug-64 25-May-86 24-May-84 03-Sep-60 12-Nov-20 24-Jan-71 03-Oct-60 06-Mar-70 11-Dec-74 Database name: Ch03 StoreCo 12 7 3 15 2 3 5 5 2 pts 2
STORE CODE STORE NAME STORE YTD SALES REGION_CODE EMP CODE 1 Access Junction 1003455.76 2 Database Corner 1421987 39 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point Table name: REGION REGION CODE REGION_DESCRIPT 1 East 2 West 986783.22 944568.56 2930098 45 2 2 1 8 12 7 3 15 Cengagje tuming 2015 Select the best business rule that describes the relationship between REGION and STORE O An employee may manage many stores, and each store is managed by many employees An employee may manage one store, and each store is located in one region One of the employees manages each store, and each store is managed by only one employee. A region has one or many stores, and each store is located in one region.