Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Could you answer no.3 plz? thank you so much Storeco database FIGURE P3.1 THE CHO3_STORECO DATABASE TABLES 5 Mr. Table name: EMPLOYEE Database name: Cho3_StoreCo
Could you answer no.3 plz? thank you so much
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 tableStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started