Abstract

This study introduces the design and analysis of a web-based Customer Relationship Management (CRM) system. It focuses on comparing different database structures and using normal forms to make storing and accessing data more efficient. The main goal of this study is to explore how databases for CRM systems can be designed to be secure, efficient, and reliable, especially when handling sensitive information. By exploring various database designs and their adherence to normal forms, the research seeks to find the best ways to organize customer data to improve security and system performance. It describes a CRM system that protects sensitive information and allows administrators to easily update member data, showing how database design affects both system operation and user experience. Using MySQL, PHP, and web hosting services, this study lays the groundwork for understanding the role of database architecture in developing CRM systems. It involves a thorough review of database design literature and a practical examination of these designs in a CRM setting. This research is a foundation for future work in CRM systems, emphasizing the importance of database design in effectively managing customer relationships. By starting with database architectures and normal forms, the study adds to the discussion on how to enhance CRM databases for better security and efficiency, providing valuable insights for both developers and researchers.

Advisor

Montelione, Thomas

Department

Computer Science

Disciplines

Business Administration, Management, and Operations

Keywords

PHP, MySQL, Docker, CRM, Normal Forms, Relational Database

Publication Date

2024

Degree Granted

Bachelor of Arts

Document Type

Senior Independent Study Thesis

Download

Share

COinS
 

© Copyright 2024 Erick Delgado