The goal of relational database design is to generate a set of database schemas that store information without unnecessary redundancy.
The purpose of relational database design involves formulating schema sets that prevent the duplication of data while storing necessary information.