1. The Sooner Manufacturing Company 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:Department: xxName Manager? Training-Received Date-Trained  Hours-Trainedxx Y/N xxxxx mmyy nnnShe 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) What is the grain of this data mart ?b) Provide a Data Schema (E-R diagram) including all attributes��q

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.