ORACLE DATABASE INTERVIEW QUESTIONS

What is an Entity-Relationship Diagram (ERD)?

What are the main components of an ERD?

How does an ERD help in database design?

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

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

Explain the difference between one-to-one, one-to-many, and many-to-many relationships in an ERD.

How do you normalize a database design using an ERD?

What is an associative entity, and when is it used in an ERD?

How can you represent inheritance or generalization in an ERD?

Explain how you would use an ERD to design a database schema for a library management system?