A local store, Reese Comp, which specialises in selling computing products and services, has been operating in everal Melbourne suburbs for the last fifteen years. Two years ago, due to the global pandemic and ockdowns that ensued, it decided to move its business online. Reese Comp had changed its name to RComp. As things began to settle into the new year, RComp decided to re-open two physical stores in Richmond and Camberwell whilst continuing with its online presence. ou and your team were asked to analyse the backend logistics; and then, design a new data model to facilitate the frontend logistics of RComp's new hybrid business model. The database should store data about their stores, products, employees, order and shipping information. Your team should also evaluate and propose any idditional data to track (not mentioned in the scenario) to ensure the smooth operations of RComp business. Whilst RComp continues with its online presence, it must also maintain some information about its physical tores. Due to the hybrid business model, RComp is well positioned to double its current full-time employees of ive and they are all paid a biweekly wage. The wage is based on the employee class: managerial, technical, ervices marketing or sales. Two employees work in the backend to provide technical support whilst the emaining staff members, including the manager, who work in the frontend to support the logistics of customer ervice and care, process and/or ship customer orders, and maintain a product inventory. The employee data that should be kept comprise, but are not limited to: employee ID, first name and last name, email, contact number, job title, and hire date. RComp maintains a modest collection of over 17,000 computing products in its warehouse and stores. Initially, our team may need to research online to determine the relevant information needed to track a computing product, e.g. the product brand, model, classification, colour, form factor, speed, capacity, supplier, the cost and list prices, description, product ratings (from customers), customer reviews, and the number of items available, just to name a few. A customer who shops with RComp can complete a registration online. The customer information stored should include the name, mailing address, e-mail, contact number, date of registration (default is the current date), date of closing the account (default is NULL). Online customers must register their username, password, security question. The customer ID is automatically generated. The customers are given the option to store or hot store payment information. Whenever a customer requests a purchase order, a sales order is added to the database with a pending status. When RComp processes and ships the order, the order status is changed to shipped. If a customer cancels an order, the order status is changed to cancelled. If a product is purchased directly from the store, a status of paid-in-store is logged