Dataware housing , some Oracle knowledge , database

Business scenario and Work narrative overview - Business rules - Detail EER/Class diagram of the proposed System - Data validation - Normalisation and discussion of discrepancies - Schema design and Database implementation using Oracle Data warehouse requirements and business challenges - Data warehouse model, process, approach and risk issues - Implementation model of data warehouse - Evaluation and integration issues Check list:- Data Modelling for Data warehousing: Appropriate data modelling and model conversion techniques, appropriate schema representation techniques, fact and dimensions are correct, flexibility and denormalisation techniques used. Integration and data warehousing issues Appropriate data cleaning, extraction and implementation aspects of the data warehouse. Drill-down and roll-up options for data warehouse. Functionality of the data warehouse and support for users. Appropriate links are included. Table links are correct. Appropriate searching criteria are discussed and implemented. All parts of the queries are implemented. Query results are correct Evaluation: Feedback from the users, system test strategy, test method, limitations, scopes, cost vs. benefit analysis. It should report any limitations that you come across during this testing. It should be supported by recommendations and further enhancement Report and other necessary components A well written report must be provided with clear description of the system developed. It should clearly identify functions and features of the propose data warehouse, query functions and library functions that are used to implement the system. Recommendations to overcome future challenges, proposed data warehouse architecture, self evaluation, and narrative overview of the project. A set of bibliography must be presented in the bibliography section of the report. It might include web sources, journals, articles, books etc. Ensure that your work is appropriately referenced. Problems faced by flip kart at least 4 ... and how can we resolve them using data warehouse. ... to justify your answer draw tables (at least 15) and the tables should be 3NF normalised. . Use star schema and some other popular forms too to justify .... My proposal was on flip kart sso it need to be done only on Flipkart