Draw an ER Model using Visio for the following. Make sure the ER model is in 3rd Normal Form.

GlobalMart, a multinational e-commerce giant, has experienced exponential growth in its online retail business. As the company continues to expand its product offerings and reach new markets, there is a need to enhance its data management system. GlobalMart envisions a comprehensive system that not only facilitates efficient transaction processing but also helps the organization with insightful business analytics.

GlobalMart operates a vast online marketplace, offering a diverse array of products ranging from electronics and apparel to home goods and specialty items. The company's success is built on a customer-centric approach, providing a seamless shopping experience to users worldwide. To stay ahead in the competitive e-commerce landscape, GlobalMart aims to leverage data-driven insights for strategic decision-making. The entities and their attributes in the ER model for GlobalMart should be based on the following business objectives. Note: Include at least 2-3 attributes (in addition to the PK and FK) for each of the entities in your normalized ER Model. Further, include at least one attribute (in addition to the two FKs/composite PK) for each bridge/junction table that you include in your ER Model.

Business Objectives:

1. Optimized Product Inventory Management: GlobalMart seeks a robust system to manage its extensive product inventory efficiently. This includes tracking product details such as ProductID, ProductName, Category, Supplier, Price, and Stock Levels.

2. Comprehensive Customer Information: The company desires a centralized repository for customer information, capturing essential details like CustomerID, CustomerName, Email, Address, and Purchase History. Understanding customer behavior and preferences is crucial for personalized marketing and improved customer engagement.

3. Efficient Order Processing: o Streamlining order processing is a key focus. The database model should support the tracking of orders with attributes like OrderID, OrderDate, Product(s) Purchased, Quantity, and Total Price. 4. Business Analytics Capabilities: o GlobalMart recognizes the importance of data analytics in gaining a competitive edge. The conceptual database model should be designed to support queries and analyses related to: Product performance (best-sellers, slow-moving items). Customer segmentation and behavior analysis. Order patterns, seasonal trends, and forecasting.