undefined

Lab 3 CSIT 154 1. What is the primary key and the foreign key(s) (if there is any) of the tables that are shown on the picture Table Primary key Foreign Key(s) 2. Is there any entity integrity in the provided tables? Fill out the following table. EXPLANATION TABLE ENTITY INTEGRITY 3. Is there any referential integrity in the provided tables? Fill out the following table. TABLE REFERENTIAL EXPLANATION INTEGRITY 4. Describe the relationship(s) between store and employee. 5. Create the ERD to show the relationship between STORE and EMPLOYEE. Submit the image with PNG or JPEG format (.drawio = 0) 6. Create the table that would result from MREGION_DECRIPT (REGION) 7. Create the table that would result from OREGION_CODE=1 (STORE) 8. Create the table that would result from 9. Write the relational algebra that would result all the stores in the East. 10. Write the relational algebra to yield the last name of the employees that work "Tuple charge" store. Lab 3 CSIT 154 EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 1 Mr. Williamson John w 21-May-84 3 2 MS Ratula Nancy 09-Feb-89 2 3 Ms. Greenboro Lottie R 02-Oct-81 4 4 Mrs. Rumperstro Jennie S 01-Jun-91 5 5 Mr. Smith Robert L 23-Nov-79 3 6 Mr. Renselaer Cary A 25-Dec-85 1 7 Mr Ogallo Roberto S 31-Jul-82 3 8 Ms. Johnsson Elizabeth 1 10-Sep-88 1 9 Mr. Eindsmar Jack 19-Apr-75 2 10 Mrs Jones Rose R 06-Mar-86 4 11 Mr. Broderick Tom 21-Oct-92 3 12 Mr Washington Alan Y 08-Sep-94 2. 13 Mr Smith Peter N 25-Aug-84 3 14 MS Smith H 25-May-86 4 15 Mr Olenko Howard U 24-May-84 5 16 Mr Archialo Barry V 03-Sep-80 5 17 Ms. Grimaldo Jeanine K 12-Nov-90 4 18 Mr Rosenberg Andrew D 24-Jan-91 4 19 Mr. Rosten Peter F 03-Oct-88 4 20 Mr. Mckee Robert S 06-Mar-90 1 21 Ms Baumann Jennifer A 11-Dec-94 3 Sherry Table name: STORE STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE 1 Access Junction 1003455.76 2 8 2 Database Corner 1421987.39 2 12 3 Tuple Charge 986783.22 1 7 4 Attribute Alley 944568.56 2 3 5 Primary key Point 2930098.45 1 15 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West