What are the major capabilities of database management systems (DBMS), and why is a relational DBMS so powerful?

a) Define a database and a database management system.

b) Name and briefly describe the capabilities of a DBMS.

c) Define a relational DBMS and explain how it organizes data.

d) List and describe the three operations of a relational DBMS.

e) Explain why non-relational databases are useful.

f) Define and describe normalization and referential integrity and explain how they contribute to a well-designed relational database.

g) Define and describe an entity-relationship diagram and explain its role in database design.