SECTION – FABILOUS FASHIONMemo to: Sam Jones, Chief Information OfficerFrom: Joe CitizenCC: be known as FABILOUS FASHION because it has many retail outlets in NWS, VIC, QLD with variety of stock with large inventory in each state. To control, maintain and manage large inventory activities, a data warehousing system should be implemented there. The data warehouse system can handle all the operational activities of the large enterprise along with the accuracy, consistency and quality of the data. Requirements analysis and gathering, data model design, data warehouse development and then implementation are all the steps to implement data warehouse system in an organization. In this memo, we will cover the development of data warehouse, the benefits of data warehouse, and the expectations of different users. Data Warehouse DevelopmentSr. # Process1 System development from operating system.2 Installation of warehouse database.AdvantagesSr. # Advantages1. Helps improve business growth2 Saves time and effort resulting in cost reduction.3 Helps maintain consistency, accuracy and quality of data4 Helps keep information up-to-dateExpectations• ADMINISTRATION AND DATA ENTRY- Internal control over security and privacy . Data security so that it cannot be available to everyone.• WAREHOUSE MANAGER- Compile daily, weekly and monthly reports. History of goods shipped. Daily receipts. Things ordered. Reports for the future. Planning for future needs.• STORE MANAGER- Analyze daily sales. Net profit with financial analysis.CONCLUSION: Data warehouse is used in different...... halves of the document. Find a way to optimize your code so that the complete SQL statement has only one logical operator (AND, OR, NOT). select * from i_model where car_group_name in ('A3','B3') and maint_int in (12000,15000)10 View registration and miles driven since last service and status of all cars that have driven more than 1500 miles since the last service. Label miles driven since last service in the "Miles Driven" column and sort the query in descending order of miles driven since last service. select i_car.registration,i_model.maint_int,decode(i_car.status, 'A','Available','H','For Rental','S','Serviced','X', 'Requires Service/Repair ', 'Unknown') state from i_car, i_model where i_car.model_name = i_model.model_name and i_car.car_group_name = i_model.car_group_name and Miles_last_service is not null and i_model.maint_int > 1500 sort by 2 desc