Entity Relationship Model and Data Warehousing Design and Implementation
I need someone to produce and design an entity relationship data model for a retail business or a hotel booking reservation business. Whatever you seems to be the best one. The model needs to be quite complex and well thought out.
Also state any typical information queries that would be of interest to staff in the business
I can send you a entity relationship model which is very simple for a head start if you need to?
I then need the relational solution converted into a dimensional data model (i.e. star schema) and populate tables with suitable data, for example, customers, orders, employees, product, etc.
Finally use Oracle SQL Developer to conduct a wide range of analytic operations to satisfy the queries you have stated.
Please let me know if anyone skilled in this sort of area would be able to do this for me.