What DBMS have you worked with? Describe your experience in database design.

In my practice, I have worked with various DBMSs, including PostgreSQL, MySQL, Microsoft SQL Server, and MongoDB. My experience in database design includes creating ER diagrams, normalizing data up to 3NF to eliminate redundancy and ensure data integrity.

For example, when designing a database for an order management system, I identified entities such as Customers, Orders, Products, and linked them through foreign keys. I paid special attention to indexing fields to optimize queries and ensure transactional integrity using ACID properties.