Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. FIGURE P3.1 THE CHO3_STORECO DATABASE TABLES Table name: EMPLOYEE EMP_CODE

image text in transcribed
image text in transcribed
Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. FIGURE P3.1 THE CHO3_STORECO DATABASE TABLES Table name: EMPLOYEE EMP_CODE EMP_TITLE EMP_UNAME EMP_FNAME 1 Me Williamson John 2 Ms. Ratula Nancy 3 Ms Greenboro Lottie 4 Mrs. Rumperstro Jennie 5 Mr Smith Robert 6 Mr. Renselaer Cary 7 Mr Ogallo Roberto 8 Ms. Johnsson Elizabeth 9 Mr Eindstar Jack 10 Mrs. Jones Rose 11 Mr Broderick Tom 12 Mr Washington Alan 13 Mr Smith Peter 14 MS Smith Sherry 15 Mr Olenko Howard 16 Mr Archilo Barry 17 MS Grimaldo Jeanine 18 Mr Rosenberg Andrew 19 M Rosten Peter 20 M Mcked Robert 21 MB Baumann Jennifer 16-3 Database name: Cho3_StoreCo EMP_INTIAL EMP_DOB STORE_CODE w 21-May-84 3 09-Feb-89 2 R 02-Oct-81 4 S 01-Jun-91 5 L 23-Nov-79 3 25-Dec-85 1 31-Jul-82 3 1 10-Sep-88 1 19-Apr-75 2 R 06-Mar-86 4 21-Oct-92 3 Y 08-Sep-94 2 N 25-Aug-84 3 H 25-May-88 4 24-May-84 5 V 03-Sep-80 5 K 12-Nov.90 4 D 24-Jan-91 F 03-Oct-88 S 06-Mar-90 11-Dec-94 Table name: STORE STORE CODE STORE NAME 1 Access Junction 2 Database Corner 3. Tuple Charge 4 Attribute Alley 5 Primary Key Point STORE YTD SALES REGION_CODE EMP_CODE 1003455 78 2 8 1421987 39 2 12 886783 22 1 7 944568.56 2 3 2930098.45 1 15 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AWS Certified Database Study Guide Specialty DBS-C01 Exam

Authors: Matheus Arrais, Rene Martinez Bravet, Leonardo Ciccone, Angie Nobre Cocharero, Erika Kurauchi, Hugo Rozestraten

1st Edition

1119778956, 978-1119778950

More Books

Students also viewed these Databases questions