数据库设计的注意事项（国外英文资料）.docVIP

数据库设计的注意事项（国外英文资料） Database design considerations Honestly, a lot of people arent very focused on the design of the database, and today Ive seen a good piece of paper that you can write down, if you need someone to look at it. Emphasis: the database design seems simple, but absolutely not belittling!!! A successful management system, is composed of: [software] + 50% 50% of the business, while 50% of successful software have [25%] + 25% of the database, the stand or fall of database design is a key. The design of the database is the most important part of the application, if you compare the data of the enterprise to the blood that is necessary for life. There is a lot of information about the database design, and there is a special talk in the university degree course. But, as we have repeatedly noted, good teachers do more than experience. So I conclude the detour taken over the years and experience, and on the Internet to find some of the database design professionals to teach well versed some database design skills and experience. A selection of 60 of these best tips is written into this article, which is easily indexed in five parts: Part 1 - before designing the database This section lists 12 basic techniques, including naming conventions and specifying business requirements. Part 2 - design the database table A total of 24 guide skills, including the design of the fields in the table and the common problems that should be avoided. Part 3 - select the key How do I select the key? Here are 10 techniques that specifically address the correct usage of the primary key that the system generates, and how and how to index fields for optimal performance. Part 4 - ensures data integrity Discuss how to keep the database clear and robust, and minimize the harmful data. Part 5 - tips Not including the other techniques in the above four sections, which are all different, and they want your database development to be easier. Part 1 - before designing the database Look at the