Database: chapter 3

a. Using the tables in diagram P3.1 (page 110), answer questions 1, 3, 4, 5, and 6.

Use the database shown in Figure P3.1

 

 

110 Part 2 Design Concepts Problems FIGURE P3.1 THE CH03_STORECO DATABASE TABLES Table name: EMPLOYEE EMP TITLE EMP LNAME EMP FNAME Database name: Ch03_StoreCo EMP INITIAL EMP DOB STORE CODE EMP CODE 1 Mr. 2 Ms. Williamson Ratula John W 21-May-64 3 Nancy 09-Feb-69 2 3 Ms. Greenboro Lottie 4 Mrs. Rumperstro Jennie 5 Mr. Smith 6 Mr. Renselaer Robert Cary 7 Mr. Ogallo Roberto 8 Ms. Johnsson Elizabeth 9 Mr. Eindsmar Jack 10 Mrs. Jones Rose RSLAS WR 02-Oct-61 4 01-Jun-71 5 23-Nov-59 3 25-Dec-65 1 31-Jul-62 3 10-Sep-68 1 19-Apr-55 2 06-Mar-66 4 11 Mr. Broderick Tom 21-Oct-72 3 12 Mr. Washington Alan Y 08-Sep-74 2 13 Mr. Smith Peter N 25-Aug-64 3 14 Ms. Smith Sherry H 25-May-66 4 15 Mr. Olenko Howard U 24-May-64 5 16 Mr. Archialo Barry V 03-Sep-60 5 17 Ms. Grimaldo Jeanine K 12-Nov-70 18 Mr. Rosenberg Andrew D 24-Jan-71 4 19 Mr. Rosten Peter F 03-Oct-68 4 20 Mr. 21 Ms. Mckee Baumann Robert S 06-Mar-70 1 Jennifer A 11-Dec-74 3 Table name: STORE STORE CODE STORE_NAME 1 Access Junction STORE YTD SALES REGION CODE EMP CODE 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 Use the database shown in Figure P3.1 to answer Problems 1-9. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 3. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. 4. Describe the type(s) of relationship(s) between STORE and REGION. 5. Create the ERD to show the relationship between STORE and REGION. 6. Create the relational diagram to show the relationship between STORE and REGION.