Schema design is the practice of translating abstract data models into concrete database structures, defining how data is stored, how it is accessed, and how it is related to other data within the database.
Designing schemas includes the design of tables, fields (or columns), relationships, and indexes to optimize the integrity, performance, scalability, and recoverability of a database.
Effective schema design makes data findable, accessible, and usable across myriad use cases and applications, enabling operational efficiency while meeting and ultimately anticipating the data needs of the enterprise.