CMIS 351 Final Exam Study Notes: Key Concepts & Terminology Latest 2026Update with complete solution.

COMPUTER MANAGEMENT INFORMATION SYSTEM Date: MARCH 26, 2026 ASSIGNMENT – 1 Student ID # SHEET 1 OF 4 Analytical Report To: Executive Team - Solomon Enterprises From: Information Consultant - Digital K&S Corporation Date: April 26, 2024 Subject: Analytical Report on Database Implementation for Solomon Enterprises Executive Summary: Solomon Enterprises is a customer-focused construction company that is growing. After viewing the current Excel Workbook used for tracking customers and sale orders, it is evident that managing an increasing amount of data is becoming a challenge. This report aims to address your data storage and tracking issues and proposes a solution that will enhance your data integrity and retrieval efficiency. This report presents recommendations for designing an efficient and effective database system for the growing needs of the company. The recommendation focuses on effective business decisions leveraging data insights. Problem Statements: 1. Data Redundancy: Multiple entries of the same data can lead to confusion and inaccuracies. 2. Data Inconsistency: With no set format for data entry, inconsistencies can arise, leading to confusion and potential mistakes. 3. Difficulty in Retrieving and Analyzing Data: Without a structured database, retrieving specific information quickly can be difficult, and analyzing data trends can be time-consuming. Recommendations: As a system analyst, I recommend Solomon Enterprise to move its sales records from the Excel sheet into the Access database. Access allows for quick import of Excel files, creating a relationship database. Through the process of normalization and creating a logical representation of data structures, we can effectively put relationships allowing the use of queries and respective reports that will enhance decision-making.