What are the main principles used in designing the database in your project?

The main principles of database design that I used:

• Data normalization — to avoid redundancy and ensure data integrity.
• Defining keys — primary and foreign keys to link tables.
• Query optimization — creating indexes on frequently used fields.
• Considering scalability — designing with the possibility of expanding the database.
• Data security — access rights management.

For example, when designing a database for an online store, I created separate tables for users, orders, and products, linking them through foreign keys to ensure integrity and ease of queries.