In this section we will look at the database design process in terms of specificity. Just as any design starts at a high level and proceeds to an ever-increasing level of detail so does database design. For example, when building a home, you start with how many bedrooms the home will have, how many bathrooms, whether the home will be on one level or multiple levels, etc. The next step is to get an architect to design the home from a more structured perspective. This level gets more detailed with respect to actual room sizes, how the home will be wired, where the plumbing fixtures will be placed, etc. The last step is to hire a contractor to build the home. That’s looking at the design from a high level of abstraction to an increasingly detailed level of abstraction.
The database design is very much like that. It starts with users identifying the business rules, database designers and analysts creating the database design, and then the database design is physically created using a DBMS.