Msn web hosting
Clarity versus Length: an Art A consistent style of abbreviations should be used. In general, only the most meaningful words of a sentence should be put into a name, dropping prepositions, and other small words. As an example, let’s take the postal code. We could express this element with different column names: the_postal_code pstl_code pstlcd postal_code I recommend the last one for its simplicity. Suffixing Carefully chosen suffixes can add clarity to column names. As an example, for the date of first payment element, I would suggest first_payment_date. In fact, the last word of a column name is often used to describe the type of content like customer_no, color_code, interest_amount. The Plural Form Another point of controversy for table names: should we use the plural form cars table? It can be argued that the answer is yes because this table contains many cars in other words, it is a set. Nonetheless, I tend not to use the plural form for the simple reason that it adds nothing in terms of information. I know that a table is a set, so using the plural form would be redundant. It can be said also that each row describes one car. If we consider the subject on the angle of queries, we can draw different conclusions depending on the query. A query referring to the car table select car.color_code from car where car.id = 34 is more elegant if the plural form is not used, because the main idea here is that we retrieve one car whose id equals 34. Some other queries might make more sense with a plural, like select count(*) from cars. As a conclusion for this section, the debate is not over, but the most important point is to choose a form ……………………………………….and be consistent throughout the whole system.
Note: In case you are looking for affordable webhost to host and run your web application check Vision cheap hosting services