Create a logical data model with crows feet notation for the following scenario.
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 No. Employee Department Department Hourly Name Rate Name A Smith L004 IT 22.00 LJones 1023 Pensions 18.50 P Lewis L004 11 21.00 B Jones LO04 IT 21.75 Project Project Project Project Employee Title Code Manager | Budget No. PCO 10 Pensions M 24500 510001 System Phillips PCO 10 Pensions M 24500 S10030 System Phillips PCO 10 Pensions M 24500 S21010 System Phillips PC045 Salarios H Martin 17400 S10010 System PC045 Salaries Martin 17400 S10001 System PC045 Salaries H Martin 17400 53 1002 System PC045 Salaries H Martin 17400 $132 10 System PC064 HR K Lewis 12250 S3 1002 System PC064 HR K Lewis 12250 S210 10 System PC064 HR K Lewis 12250 S10034 System A Smith 2004 18.00 T Gilbert L028 Database 25.50 LOOB Salary 17.00 W W Richards TGilbert L028 Database 23.25 P Lewis L004 IT 17.50 B James LO09 HR 16.50 Sample Report Project Management Report Project Code: Project Title: PC010 Pensions System Project Manager: 24.500 M Phillips Project Budget: Employee No. Employee Department Name No. EEEEEEEEEEEEEEEEEEEE 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 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 No. Employee Department Department Hourly Name Rate Name A Smith L004 IT 22.00 LJones 1023 Pensions 18.50 P Lewis L004 11 21.00 B Jones LO04 IT 21.75 Project Project Project Project Employee Title Code Manager | Budget No. PCO 10 Pensions M 24500 510001 System Phillips PCO 10 Pensions M 24500 S10030 System Phillips PCO 10 Pensions M 24500 S21010 System Phillips PC045 Salarios H Martin 17400 S10010 System PC045 Salaries Martin 17400 S10001 System PC045 Salaries H Martin 17400 53 1002 System PC045 Salaries H Martin 17400 $132 10 System PC064 HR K Lewis 12250 S3 1002 System PC064 HR K Lewis 12250 S210 10 System PC064 HR K Lewis 12250 S10034 System A Smith 2004 18.00 T Gilbert L028 Database 25.50 LOOB Salary 17.00 W W Richards TGilbert L028 Database 23.25 P Lewis L004 IT 17.50 B James LO09 HR 16.50 Sample Report Project Management Report Project Code: Project Title: PC010 Pensions System Project Manager: 24.500 M Phillips Project Budget: Employee No. Employee Department Name No. EEEEEEEEEEEEEEEEEEEE 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
