Marc's Health Food Store operates in the competitive and rapidly evolving retail sector, specifically within the health food niche. The business environment for health food retailers is characterized by increasing consumer awareness of health and wellness, growing demand for organic and natural products, and the need for omnichannel presence to meet customer expectations.

In recent years, the retail industry has been undergoing significant digital transformation. As noted by Pantano et al. (2021), retailers faced numerous challenges and opportunities during the COVID-19 pandemic, which accelerated the adoption of digital technologies. This shift has made it crucial for businesses like Marc's Health Food Store to adapt and integrate online and offline channels to remain competitive.

The health food market is experiencing growth due to increasing health consciousness among consumers. This trend presents opportunities for Marc's Health Food Store to expand its product offerings and customer base. However, it also means facing competition from both traditional brick-and-mortar stores and online retailers specializing in health foods.

In this environment, providing comprehensive product information, health education, and a seamless shopping experience across multiple channels has become essential. As Grewal et al. (2020) point out, strategizing retailing in the new technology era involves leveraging data and technology to enhance customer experiences and operational efficiency.

The primary goal of the proposed database system for Marc's Health Food Store is to create an integrated platform that supports both in-store and online sales, enhances product information management, enforces business rules, facilitates customer education, and improves inventory management and sales tracking.

Specific objectives include:

1. Implement an online ordering system that seamlessly integrates with the existing in-store system.

2. Enhance product information management and accessibility to support customer decision-making.

3. Enforce business rules and policies consistently across all sales channels.

4. Support customer education initiatives through efficient information dissemination.

5. Improve inventory management and sales tracking to optimize stock levels and understand sales patterns.

6. Increase the customer base by 10% through improved accessibility and information.

7. Support the expansion of product category offerings.

8. Make product, health, and recipe information readily available to customers.

9. Contribute to a 5% increase in overall sales.

These goals and objectives align with current retail trends, particularly the creation of omnichannel experiences, which Mosquera et al. (2022) have shown to increase customer engagement and sales.

The proposed database system addresses several key business problems faced by Marc's Health Food Store:

1. Limited Online Presence: By implementing an integrated online ordering system, the store can expand its reach beyond the physical location. This addresses the problem of limited market penetration and aligns with the trend of creating omnichannel experiences (Verhoef et al., 2021).

2. Inefficient Product Information Management: The new system will enhance the store's ability to manage and present product information effectively. This solves the problem of customers lacking access to comprehensive product details, which is crucial in the health food sector where customers often require detailed nutritional information.

3. Inconsistent Business Rule Enforcement: By incorporating business rules into the database system, Marc's Health Food Store can ensure consistent application of policies, discounts, and promotions across all sales channels. This addresses the problem of potential discrepancies between online and in-store transactions.

4. Limited Customer Education Capabilities: The database system will support the storage and management of educational content such as recipes, health articles, and workshop information. This addresses the challenge of effectively disseminating health and product information to customers, which is vital in the health food industry.

5. Suboptimal Inventory Management: Improved inventory tracking and sales analysis capabilities will help the store optimize its stock levels and understand sales patterns better. This addresses the problem of potential overstocking or stockouts, which can significantly impact profitability.

6. Lack of Integrated Analytics: The new system will provide robust reporting and analytics capabilities, allowing the store to gain insights into customer behavior, sales trends, and inventory turnover. This addresses the problem of limited data-driven decision-making.

By addressing these business problems, the proposed database system positions Marc's Health Food Store to compete more effectively in the evolving retail landscape. As Akter et al. (2020) emphasize, building dynamic service analytics capabilities is crucial for success in the digital marketplace.

While Marc's Health Food Store's mission statement is not explicitly provided, we can infer from the context that the organization aims to:

1. Provide high-quality health food products

2. Educate customers about healthy living

3. Offer excellent customer service across multiple channels

The proposed database system aligns with this inferred mission and the stated strategic goals in several ways:

1. Increase Customer Base by 10%

· Implementation: Online ordering system and enhanced product information accessibility

· Impact: Attracts new customers and improves shopping experience for existing ones

· Support: Xu et al. (2022) note the significant impact of e-commerce on customer acquisition and retention in brick-and-mortar retailers

2. Expand Product Category Offerings

· Implementation: Robust product catalog management capabilities

· Impact: Efficiently handles an expanded range of products

· Alignment: Grewal et al. (2020) identify this as a trend in strategizing retailing for the new technology era

3. Make Product, Health, and Recipe Information Available

· Implementation: Content management component for storing and managing diverse content

· Impact: Supports the educational aspect of the store's mission

· Alignment: Addresses increasing consumer demand for comprehensive product information in the health food sector

4. Increase Sales by 5%

· Implementation: Improved accessibility, better product information, and seamless omnichannel experience

· Impact: Contributes to sales growth goal

· Support: Mosquera et al. (2022) highlight the positive impact of technology on customer loyalty in omnichannel retail

5. Enhance Customer Experience

· Implementation: Integrated system providing a unified view of products, orders, and customer information

· Impact: Improves overall customer experience across all channels

· Alignment: Verhoef et al. (2021) emphasize the importance of omnichannel retailing in meeting customer expectations

6. Operational Efficiency

· Implementation: Improved inventory management and sales tracking capabilities

· Impact: Contributes to overall operational efficiency

· Significance: Crucial for long-term success and profitability

7. Data-Driven Decision Making

· Implementation: Reporting and analytics capabilities

· Impact: Enables more informed business decisions

· Alignment: Akter et al. (2020) discuss the trend of leveraging data for competitive advantage in retail

The proposed database system for Marc's Health Food Store aligns with the organization's inferred mission and stated goals, positioning it for success in the competitive health food retail landscape. The project fulfills the organization's objectives in the following ways:

1. Supporting Health-Conscious Consumers: Provides comprehensive product information and educational content, aligning with growing health consciousness trends.

2. Omnichannel Presence: Integrates online and in-store systems, creating a seamless shopping experience across multiple channels (Verhoef et al., 2021).

3. Business Growth: Supports expanded product offerings, attracts new customers, and increases sales, contributing to growth objectives (Xu et al., 2022).

4. Customer Education: Offers content management features to educate customers about health and nutrition.

5. Operational Excellence: Improves inventory management, enforces business rules, and provides analytics capabilities (Li et al., 2020).

6. Futureproofing: Ensures scalability for future growth and technological advancements (Paul & Rosenbaum, 2020).

Entity Relationship Model

Subjects of Interest (Proposed Entities)

· Each product is assigned to a maximum of 1 health category.

· A person who has placed at least 1 order is a customer.

· Each order must be associated with exactly one customer.

· Employees can handle multiple orders, but each order is handled by only one employee.

· Suppliers can provide multiple products, and each product can be supplied by multiple suppliers.

· All food products must have associated nutritional information.