1. Identify each relationship type (1:1, 1:M or M:N) and write all the relationships in English sentences

2. Identify the cardinalities associated with this entire schema using English sentences (no charts here). NOTE: You will not be able to decipher an upper limit because no specific business rules were provided to you, so you will simply need to use (1,1) or (1,N) as cardinalities throughout.

3. Draw an Entity Relationship Diagram (ERD) using proper Chen notation that corresponds to the relational schema above. Include all connectivities, cardinalities and attributes as shown in the dataset given. There are NO optional relationships in this ERD so there should not be any zeroes as minimum cardinalities or any circles on relationship lines in your diagram.

4. Draw an ERD using proper Crows Foot notation, including all connectivities, cardinalities and attributes. Again, there are to be NO optional relationships in this ERD.

EMPLOYEE TABLE - Sample Data STORE TABLE - Sample Data REGION TABLE - Sample Data JOB TABLE - Sample Data NOTE: If a field is empty, then it is considered to be NULL