Table of Contents [ ii ] Perceptions 21 (Windows 2003 server web)
Table of Contents [ ii ] Perceptions 21 Asking the Right Questions 21 Existing Information Systems 21 Chronological Events 22 Sources and Destinations 22 Urgency 22 Avoid Focusing on Reports and Screens 22 Data Collected for our Case Study 22 From the General Manager 23 From the Salesperson 23 From the Store Assistant 24 Other Notes 25 Summary 25 Chapter 3: Data Naming 27 Data Cleaning 27 Subdividing Data Elements 28 Data Elements Containing Formatting Characters 29 Data that are Results 29 Data as a Column’s or Table’s Name 30 Planning for Changes 32 Pitfalls of the Free Fields Technique 33 Naming Recommendations 34 Designer’s Creativity 34 Abbreviations 34 Clarity versus Length: an Art 35 Suffixing 35 The Plural Form 35 Naming Consistency 36 MySQL’s Possibilities versus Portability 36 Table Name into a Column Name 36 Summary 37 Chapter 4: Data Grouping 39 Initial List of Tables 39 Rules for Table Layout 40 Primary Keys and Table Names 40 Data Redundancy and Dependency 41 Composite Keys 42 Improving the Structure 44 Scalability over Time 44 Empty Columns 45 Avoiding ENUM and SET 46
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check Vision mysql hosting services