Database Management, guaranteed thumbs up!

• 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.

• 7.

  Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store employs many employees, one of whom manages the store.)

• 8.

  Create the ERD to show the relationships among EMPLOYEE, STORE, and REGION.

• 9.

  Create the relational diagram to show the relationships among EMPLOYEE, STORE, and REGION.

Table name: EMPLOYEE Database name: Cho3 Storeco EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_NTIAL EMP_DOB STORE_CODE 1 Mr. Williamson John 21-May-84 2 Ms. Ratula Nancy 09-Feb-89 3 Ms. Greenboro Lottie 02-Oct-81 4 Mrs. Rumpersfro Jennie 01-Jun-91 5 Mr. Smith Robert 23-Nov-79 6 Mr. Renselaer Cary 25-Dec-85 7 Mr. Ogallo Roberto 31-Jul-82 8 Ms. Johnsson Elizabeth 10-Sep-88 9 Mr. Eindsmar Jack 19-Apr-75 10 Mrs Jones Rose 06-Mar-86 11 Mr Broderick Tom 21-Oct-92 12 Mr. Washington Alan 08-Sep-94 13 Mr. Smith Peter 25-Aug-84 14 Ms. Smith Sherry 25-May-86 15 Mr. Howard 24-May-84 16 Mr. Archialo Barry 03-Sep-80 17 Ms. Grimaldo Jeanine 12-Nov-90 18 Mr. Andrew 24-Jan-91 19 Mr. Rosten Peter 03-Oct-88 20 Mr. Mckee Robert 06-Mar-90 21 Ms. Baumann Jennifer 11-Dec-94 Olenko Rosenberg EMP_CODE 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 1003455.76 1421987.39 986783.22 944568.56 2930098.45 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West