Scenario
Scenario is based on AdventureWorks Cycles (AWC), a common database and fictional company used by Microsoft over the years to demonstrate the possibilities of the relational database Microsoft SQL Server.
AWC is a large, multinational manufacturing company. The company manufactures and sells metal and composite bicycles to North American, European, and Asian commercial markets.
The company needs a web application so that individual customers can navigate through the catalog, read product characteristics, view product photos, and buy a bicycle through the shopping cart.
AWC has a company ERP that it uses for all daily operations and orders via legacy channels. It requires all information published on the web store to come from the ERP. This is a classic client-server application heavily based on a relational SQL Server database. Over time, the application was migrated over the cloud, moving the database to Azure SQL Database PaaS service. To recreate the ERP experience, it is possible...
