I learned basic mysql from some books and w3school. I want to know how to increase my knowledge on database design for developing higher level application for future projects.
Thanks Alamgir
See Question&Answers more detail:osI learned basic mysql from some books and w3school. I want to know how to increase my knowledge on database design for developing higher level application for future projects.
Thanks Alamgir
See Question&Answers more detail:osI agree with fancyPants's Comment.
short answer: practice, practice, practice
but Long Answer: (in theory of Data Modeling)
every techniques and frameworks in computer science have some patterns. Database Design for Information Systems or Data Modeling has some patterns too.
I recommend following steps to learn data modeling patterns (I've been teaching them for 6 years):
Introduction to Data Modeling Heuristics and Patterns
Data Modeling Patterns – Entity, Attributes
Data Modeling Patterns – Relationships, Cardinality
Types of Attributes (Composite, Multi-Value, Derived)
Data Modeling Patterns – Trees and Graphs
Data Modeling Patterns – Traps
Data Modeling Patterns – List Pattern
Data Modeling Patterns – Status Pattern
Mapping Object Oriented Design to Relational Data Model
to find references, just google them or:
Best collection of Data Modeling patterns, gathered in remarkable book:
PATTERNS OF DATA MODELING, by MICHAEL BLAHA, CRC Press, (2010)