The best place to start is identifying the entities that your component deals with. An
easy way to do this is to create an ERD (Entity Relationship Diagram). If you are not
familiar with ERDs there are plenty of online resources available.
The next step is to build a database schema. When you do this, you must take into
consideration all of the aspects covered in Chapter 3. Remember to make use of the
common fields and to use the naming conventions.
To ensure you gain the best performance from your database, normalize your tables
to at least 2NF (2nd normal form). If you are not familiar with database normalization,
there is a good tutorial available on the official MyS???L developer zone website:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html.
Once you have done this, you should have a good basis on which to start building
your component. The best place to start is with the controllers. How you choose to
design your controllers normally depends on the complexity of your component and
the number of entities you are dealing with.
Pages:
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124