MYSQL DATABASE INTERVIEW QUESTIONS

What is an ERD in the context of MySQL?

What are entities and attributes in an ERD?

How do you represent relationships in an ERD?

What is the difference between a one-to-many and a many-to-many relationship in an ERD?

How do you use primary and foreign keys to represent relationships in an ERD?

What is a composite key and how is it represented in an ERD?

How do you normalize a database schema based on an ERD?

What is denormalization and when might it be used in the context of an ERD?

Explain how to represent inheritance in an ERD for a MySQL database.

During a database certification exam, you are asked to create an ERD for a library management system that includes books, authors, and borrowers. How would you represent these entities and their relationships?