1. is concerned with the training level of its employees. Legal and corporate directives require that each employee receive training in a number of areas (safety regulations, affirmative action, quality

1. is concerned with the training level of its employees. Legal and corporate directives require that each employee receive training in a number of areas (safety regulations, affirmative action, quality management, etc.) on a periodic basis. Employees have to repeat some courses each year. Managerial employees require different training than hourly employees. Nancy Leader, the VP for Human Relations has requested a data warehouse to support this. One of the reports she would like looks like the one below: xx Y/N xxxxx mmyy nnn She indicated that she would like to be able to run the report by department; summarize it by month, quarter, or year; or restrict it to any training program. She would also like to be able to identify any employee that had not received necessary training and contact the employee and their supervisor by phone or e-mail. Design a dimensional Data Mart for this system. Include attributes that you think are necessary. a) is the grain of this data mart ? b) Provide a Data Schema (E-R diagram) including all attributes ��q

Do you need us to help you on this or any other assignment?


Make an Order Now