The retail store has provided you with a list of some of the business rules that they use to conduct business on a daily basis. The company has also provided you with the subjects of interest to them,

11

Database System Development and Implementation Plan

Course Title

Database System for Marc’s Health Food

Name

Date

Table of Content

Database System for Marc’s Health Food Store 3

Introduction 3

General Business Environment 3

Database System Goals and Objectives 4

Addressing the Business Problems 5

Aligning the System with the Mission and Goals 6

Database System Development Phases 7

Conclusion 9

References 10

In recent months, Marc's Health Food Store has expanded tremendously, and therefore, customers are demanding products to be bought online. Currently, the store has a simple website, which lacks interactive and dynamic features for communicating with customers and making purchases. Further, the primary database of the store, which is currently located in the physical store for the purpose of managing inventory and customer orders, is outdated and incurs operational issues. To overcome these problems, Marc plans to install a contemporary database system that can facilitate online sales, enhance inventory control, and deliver educational material to customers. This Database System Development and Implementation Plan explains how these issues will be solved using Microsoft SQL Server Express Edition and how the new system will contribute to the store's business efficiency as well as its overall mission and strategy.

Marc's Health Food Store is an organic retailer located in the local market that deals with organic and raw foods from farmers and merchants within the market. The store is an intermediary between customers and healthier products, and at the same time, it helps individuals learn about environmental sustainability. Marc dreams of the store as a place that will not only offer the goods but also educate customers about what is good for them and how all that is organically produced is beneficial for the environment. However, competition pressure is observed due to the growing number of large-format stores that have effectively applied innovative technologies in their work, which enables customers to quickly and easily make purchases on the internet and receive product information. For Marc's Health Food Store to sustain competition, it is essential to implement an effective database system that drives efficiency, customer, and online sales (Seifollahi, 2023).

The key goals of the proposed database system for Marc’s Health Food Store include the following:

1. Improve Inventory Management: Many times, data regarding products, inventory, and order processing is lacking in an organized system. Product categories will also be easily managed, and store stocks and sales records will qualify for inclusion under the new database.

2. Support Online Purchases: Research has revealed that customers want to buy products online. With the integration of the database with the store website, the system will enable customers to view products, order, and get product details online, enhance customer satisfaction, and attract more people (Dewi & Ayuningsih, 2022).

3. Expand Customer Education: It entails informing the customers about organic products and proper ways of living a sustainable lifestyle. The new database will also help Marc to continue his educational process as it will contain information about products, recipes, and their health qualities both for the internet and the covers of stores.

4. Increase Sales and Customer Base: Managing operations and enhancing the quality of service will ensure the store earns a 5% rise in its sales and the customer base grows by 10%, both of which are key to the continuous growth and success of the business (Tian & Kamran, 2021).

5. Ensure Long-Term Viability: The application of a contemporary and flexible database management system will ensure that the store continues to compete effectively and offers future business development, including venturing into new product lines and offering new services (Smartsourcing, 2019).

The current issues of Marc's Health Food Store include problems with inventory control, lack of online selling capability, and poor customer sensitization. The proposed database system will address these problems in the following ways:

1. Inventory Management: Currently, the store's current system of manual inventory management is inefficient and unreliable. The new database will simplify product tracking, automate the process of stock level updates, significantly diminish the possibility of stockouts, and enable fast adaptation to new inventory supplied by local producers (Hosen et al., 2024).

2. Online Sales Integration: Since customers are more inclined towards online buying, the lack of e-commerce features is a major drawback of the store. An updated website will be linked to a new database through the use of a link so that customers will be able to explore the product categories offered, view detailed product information, and order the products online. This functionality will enhance customer satisfaction and the capacity of the store to provide services similar to the ones offered by larger retailing companies in this list (Dewi & Ayuningsih, 2022).

3. Customer Education: Although Marc's objective was to inform its customers about the benefits to their health when they consume organic products, the available system at the store does not cater to the dissemination of information. The new database will help to store and organize recipes, articles, and health information used in the store; the information can be accessed both in stores and online. This will help encourage sustainable lifestyle perceptions and target sensitive customers on health.

The explicit mission of Marc's Health Food Store is to help its customers find quality and healthier food products while supporting concepts of ecology. The proposed database system aligns with the store's mission by supporting key operational goals:

1. Expanding Product Offerings: This new database will allow Marc to work with more product categories and extend the product range of the store in cooperation with other local producers. This supports the store's philosophy of providing the community with a huge array of organic products.

2. Educating Customers: The system will enable clients to access products, recipes, and Health information while at the store and through www dot store dot com. This accords with Marc's objective of raising awareness about organic food and practices in the market so as to encourage healthier living (Seifollahi, 2023).

3. Improving Convenience and Sales: The database system will incorporate features that will make shopping at Marc's Health Food Store convenient by offering online purchasing options and decreasing in-store processes. This can help achieve the target of expanding the customer base by 10% and Sales by 5%, which are some of the success factors for any business, as recommended by Tian & Kamran (2021).

The successful implementation of the database system will follow these key development phases:

1. Requirement Gathering: The first one is the identification of detailed requirements from the stakeholders, which include Marc and his staff as well as the customers. This guarantees that the system that is being developed will be able to address the needs of the business as well as what the customer wants.

2. System Analysis: In this phase, system requirements are defined, as well as the hardware, software, and networking components required by the system. The analytical work will also involve defining how the system will complement the store's functioning and its website.

3. System Design: The implementation phase will entail defining exactly how the database will look, how data will be processed, and where the online purchasing option will be situated on the website. This phase consists of UI construction and the formulation of the DBMS (Coronel & Morris, 2019).

4. Implementation: The work plan at the implementation phase is that the database system will have to be established by following the design. This involves database creation, transfer of existing data as well as linking the system with the store's web site for online sales purposes.

5. Testing and Quality Assurance: Verification tests will be carried out to confirm that the database fully addresses functional specifications while satisfying a zero-tolerance error rate. This phase also encompasses putting the system under stress to determine the capacity of the system in handling real-time data processing, online transactions, and multi-user interactions (Hosen et al., 2024).

6. Maintenance and Future Enhancements: After set up, the system continues to need ongoing maintenance to guarantee that it operating optimally and effectively to ever-changing business needs. The system will also be expandable, which means that when the need arises later, the system can be added, for example, by adding new food categories or enhancing this website.

The introduction of a new database system to solve the business operation issues of Marc's Health Food Store creates the future for the business. The proposed system will help manage the inventory and sales online and educate the customers. Therefore, the store's vision and mission are about changing the community's lifestyles for the better. Through enhancing convenience, diversification of products, and offering information, the system will contribute to the store's target of expanding the customer population by 10% or more and sales increase of at least 5% or more. Through careful planning, analysis, and implementation, this database system will enable Marc’s Health Food Store to remain competitive in an evolving market while staying true to its core values.

Coronel, C., & Morris, S. (2019). Database systems: Design, implementation, & management (13th ed.). Cengage Learning.

Hosen, M. S., Islam, R., Naeem, Z., Folorunso, E. O., Chu, T. S., Al Mamun, M. A., & Orunbon, N. O. (2024). Data-Driven Decision Making: Advanced Database Systems for Business Intelligence. Nanotechnology Perceptions, 687-704. (

Seifollahi, N. (2023). The Impact of Customer knowledge management on market performance: The mediating role of innovation capabilities. Public Management Researches, 15(58), 233-259.

Microsoft. (2023). Industry-leading performance and security with SQL Server 2019. Retrieved from www.microsoft.com/en-us/sql-server/sql-server-2019.

Tian, Y., & Kamran, Q. (2021). A review of antecedents and effects of loyalty on food retailers toward sustainability. Sustainability, 13(23), 13419.

Silva, F., Farias, R., & Oliveira, R. (2019). A dynamic web-based e-commerce system for small businesses. Journal of Systems and Software, 148, 120-135.

Dewi, D. W., & Ayuningsih, E. (2022). WEB-Based Design of E-Commerce for Small and Medium Enterprises in Bengabing Village. INFOKUM, 10(02), 838-848.