What methods did you use when structuring the database in your project?

When structuring the database in the project, I followed these principles:

• Data normalization to eliminate redundancy and ensure integrity.
• Defining key entities and their relationships (one-to-one, one-to-many, many-to-many).
• Using indexes to speed up frequently executed queries.
• Dividing data into tables with clear and logical names.
• Planning data types considering the volume and nature of the information.
• Ensuring data integrity through constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE).

For example, for a project with users and orders, I created two tables Users and Orders, where Orders contains a foreign key to Users to link orders to a specific user.