Scenario
SNHU Clothing is a small clothing retailer that is expanding rapidly across the East Coast. It sells clothing and accessories for men, women, and children. The company has one physical location, but its online sales have grown significantly over the last few years. The company has a total of 10 employees. The management team is as follows:
Currently, SNHU Clothing uses a Microsoft Access database to store customer sales, product information, and vendor and supplier data. However, another small clothing retailer is going out of business. As a result, SNHU Clothing has decided to buy its clothing to sell at its physical location. SNHU Clothing is also buying the retailer’s customer database.
Both databases are in Microsoft Access format, but the fields are completely different. Your job as the business analyst is to review both databases and find out how the systems relate and provide a report and executive summary recommending a migration process and system design for a new enterprise information system.
Business processes:
