Schema Design with a given problem statement
Having a upper hand on datawarehouseing concept would be perfect other wise DBMS core is must!!
Concepts of small-scale and large-scale helps us to migrate from existing architecture to other db architechture.
Steps for Database model desgin:-
- Understanding Business goals.
- Considers all the noun in problem statement as your entity, features as attributes with some basic hand on practice
- Small Scale db
- Converting into scalable db model by segregating sql db and nosql db design