I need help to convert the ER database model to a dimensional model. The dimensional model is limited to two business processes.Document Preview:NW Order Process Dim ModelMonth Quarter Year Northwind Dimensional Model DateDim DateKey OrderDateDim OrderDateKey OrderMonth OrderYear RequiredDateDim RequiredDateKey ShippedDateDim ShippedDateKey OrderDim OrderKey OrderID ShipperDim OrderLineItemFact OrderFact ShipmentFact ProductDim EmployeeDim CustomerDim DayOfWeek OrderDayOfWeek RequiredDayOfWeek ShippedDayOfWeek OrderQuarter Date OrderDate RequiredDate ShippedDate OrderHolidayInd HolidayInd BIDW Midterm NW Order Process Dim ModelMonth Quarter Year Northwind Dimensional Model DateDim DateKey OrderDateDim OrderDateKey OrderMonth OrderYear RequiredDateDim RequiredDateKey ShippedDateDim ShippedDateKey OrderDim OrderKey OrderID ShipperDim OrderLineItemFact OrderFact ShipmentFact ProductDim EmployeeDim CustomerDim DayOfWeek OrderDayOfWeek RequiredDayOfWeek ShippedDayOfWeek OrderQuarter Date OrderDate RequiredDate ShippedDate OrderHolidayInd HolidayInd BIDW Midterm Attachments: BIDW-Mid-Term.doc Northwind-Bus.doc Northwind-Dim.xls Northwind-ER-.doc