Before going into advanced SOL, I want to give some information on data modelling :
Data model is input to the process model. Process model is high level model in an enterprise. Why sound data design is required. Usually, it should meet current business requirements, and future business requirements.
Data model – Data modeling provides a framework in which a sound logical data design can be discovered and then documented. Data model is logical in nature and powerful in its simplicity, it is not vague.
Who are involved in data modelling:
Business systems analysts
Data management engineers
Process of data model:
- First we need to generate logical model
- Generate Physical model based on logical model. Development of Physical data model is independent of any RDBMS or database
- Physical model is further engineered to generate an implementation database based upon a particular software platform.