What is a Good Database Design?
“Like a house, a good database is built with forethought, and with proper care and attention given to the needs of the data that will inhabit it; it cannot be tossed together in some sort of reverse implosion.” Louis Dawson The database is the cornerstone of most business projects. So, it’s best if it’s user friendly and highly optimized (achieving the best performance possible) and has integrity (redundancies and dependencies have been identified and dealt with). Below are some common attributes that your database should have to be considered “well designed.” • Determine the Data to Be Used – Many believe that 60% of the time creating a database should be spent in design phase. That’s 60% of building time on paper without even opening Access. This is true even if you use one of Access’ pre-built templates. You need to be sure your data needs are going to be met in the template. We will discuss the steps for the design process in the lesson titled “The Design Process.” • A Naming Conve
