Question: Please answer no.4. Thank you! Storeco database FIGURE P3.1 THE CHO3_STORECO DATABASE TABLES 5 Mr. Table name: EMPLOYEE Database name: Cho3_StoreCo EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME

Please answer no.4. Thank you!
Storeco database FIGURE P3.1 THE CHO3_STORECO DATABASE TABLES 5 Mr. Table name: EMPLOYEE Database name: Cho3_StoreCo EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 1 Mr. Williamson John w 21-May-84 2 Ms. Ratula Nancy 09-Feb-89 2 3 Ms. Greenboro Lottie R 02-Oct-81 4 4 Mrs. Rumpersfro Jennie 01-Jun-91 5 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 w 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 Sherry 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 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 1. What are Primary keys and Foreign keys? 2.Is there entity integrity? Is there referential Integrity? How we could change this tables to brake entity and referential integrity? 3.Create an ERD 4. Create tables with all the constraints and populate few records in each of the table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
