For each foreign key: i)Relationship type: 1:1, 1:M, M:N __________ ii)Relationship with Table: ______ PK: _____

Which columns are keys?

2. Draw the Relational Diagram that illustrates the relational constructs including the relationship type. Also identify any Associative Entity tables or lack of. This drawing is the logical design

3. Draw the conceptual ER Diagram which illustrates the data as seen by user and has only high-level details, just enough to visualize relationships. Be sure to restore M:N relationships by removing any Associative Entity tables. Conceptual design drawings can handle M:N.

4. Write the business rules. (read relationships forward and backward)

Table name: EMPLOYEE Database name: Ch03 StoreCo EMP CODE BP TITLE EP LNAME EMP-FNAME EMP NTIAL EMP DCe STORE CODE 21 -May-84 09-Feb-69 02-0d-61 01-An-71 23-Now-59 Greenboro Loftie Rumperstfro Jenrie Renselaer Cary Johnsson Elzabeth Roberto Jack Ton 31-162 10-Sep-68 19-Apr-55 06-Mar-56 21-0d-72 08 Sep-74 8 Ma Endsmar Broderick 12 M 14 Ms 5 M 16 M Sherry 24-May-4 03Sep-80 Archisio Berry GrdoJeanine Rotden Baumann Jennifer Andrew 19 M 20 M Table name: STORE | STORE-COOE STORE-NAME 1 Access Junction 2 Database Conner STORE-YTD-SALES REGOLcccel EMP_coce 1003455 76 421987 39 965783 22 94456858 12 Tuple Charge 4 Atribvte Aley 5 Prinay Key Point Table name: REGION REGION CODE REGION DESCRPT 1 East