Assignment: Create a logical data model with crow's feet notation for the following scenario. Worth 20 points (Correct Entities 5pts + Correct Attributes 5pts + Correct Cardinality 5pts + Correct Relationships 5pts). +2 bonus if the attribute hourly rate is on the correct entity. You can hand draw or use a software program to complete the model. Upload your completed model to Canvas. ABC, Inc needs a database to track employee projects. Each employee could be paid a different hourly wage depending on the project assigned. The database should track the employee no, name, department no, department name for each employee. Also each projects code, title, budget, and project manager should be tracked. The employee's hourly rate will also need to be tracked. Use the example project management report for additional details. Sample Data Employee Name Project Coche PCOTO Project Manager M Phulps Project Employee Budget 24500 S 1000T NO Department Department Holy No. Name Rate 2004 22:00 A Smith PCOTO S10030 LJones LO23 Pensions 10.50 Phups PCOTO 24500 521010 Plewis 2004 TIT 2100 Philips Martin PC045 17200 "STOD 10 Jones 2004 IT 2175 Project Title Pensions System Pensions System Pensions System Salaries System Salas System "Salaries System Salarios System HR System HR System PC045 H Martin 17400 S10001 A Smith C004 IT 1800 PC045 Kartin 17400 531002 T Gilbert C020 Database 25.50 PC0:45 H Martin 17400 513210 L000 Salary 17.00 w Richards TGilbert PC064 R Lewis 12250 531002 CO20 Database 23 25 PC064 KLEWIS 12200 52 10 10 IT P Lewis L004 17.50 PC064 12250 K Lewis S 10034 HR B James To 50 2009 System Sample Report Project Management Report Project Code: Project Title: PC010 Pensions System Project Manager: 24.500 M Phillips Project Budget: Employee No. Employee Name Department No. Department Name Hourly Rate S10001 S10030 S21010 S00232 A Smith L Jones P Lewis R Smith L004 L023 L004 L003 IT Pensions IT Programming 22.00 18.50 21.00 26.00 Total Staff on Project: 4 Average Hourly Rate: 21.88 Calculated Fields