5:50 PM Wed Feb 23 100% K O + : 0 Figure 1.1: Entity Relationship Diagram (ERD) for Assigning Projects to Employees DEPARTMENT EMPLOYEE PK DEPT CODE to- employs - of PK EMP NUM DIVISION It operates FK1 DIV_CODE PK DIV CODE DEPT_NAME OR manages FK1 DEPT_CODE EMP_LNAME EMP_FNAME FK1 EMP_NUM runs EMP_INITIAL DIV_NAME EMP_EXTENSION EMP_E-MAIL records 1: ....... PO - - -- ASSIGNMENT PROJECT PK PROJ CODE is wotenin He PK ASSIGN NUM FK2 PROJ_CODE PROJ_NAME FK1 EMP_NUM ASSIGN_DATE -4-- ...... ASSIGN_HOURS 2- - - - - 3- - - - > NIN V5149 PM Wed Feb 23 ?100/o- Problem Statement: Figure 1.1 (below) is a Crow's Foot notation of the entity relationship diagram (ERD) for a database system that you have just developed for the Arlington Based Firm (ABF), for the purpose of assigning projects to its employees. Questions: Answer the following questions with respect to Figure 1.1 : 1) Articulate/Specify the Relationships between the different tables 2) Write out the Relational Schema for each table 3) Identify the Primary Key and the Foreign Key(s) for each table 4) Identify the Mandatory and Optional attributes in each table 5) Write the Business Rules used to create the Crow's Foot ERD (Figure 1.1), including all the appropriate connectivities and cardinalities as indicated on the diagram