The overall structure of the database tables that store information: user profile data, content metadata, or pure structured information. In the simplest case, a database schema has a single database table of user information. Each record (row) within this table might represent a unique customer, with each field (column) representing relevant customer information (address, city, phone number, etc.). More complex schema would involve multiple database tables related to one another through a common unique identifier. Such relational database tables are necessary for more complex data schemas for performance and easier administration.
Transformation of the data model into a set of data structures that can be implemented using the chosen database technology, to translate users’ data requirement and to provide builders with sufficient details to build a consistent system.