1.

In the evaluation of proposals for the removal, addition, or revision of products in a company, the treatment of overhead is problematic. Discuss the possible issues that could arise and the approach that may be taken to mitigate this issue in both the near term and future.

2.

Your client currently utilizes a flat file / simple database program for its business transactions , etc. They are considering converting to the Database Approach to Data Management. The two main DBMS Models are SQL Relational Model and the NOSQL (Non-Relational) Database Model.

Considerations to be used to determine the best course of action are size of organization, structure of data, use of Data Warehouses, use of Data Mining, the existence of Big Data, and the role of Data Cleansing.

Part I - What factors would make you lean towards SQL Relational DBMS and what factors would make you lean towards NOSQL (Non-Relational) DBMS. You must utilize the considerations stated above in your response.

Part II - What role does Data Cleansing play in the administration of any DBMS Model that you would select?

Your response must utilize technical language that was discussed in the course, be direct, and to the point.