What are the major capabilities of database management systems (DBMS), and why is a relational DBMS so powerful? • Define a database and a database management system. • Name and briefly describe the...

What are the major capabilities of database

management systems (DBMS), and why is a

relational DBMS so powerful?

• Define a database and a database management system.

• Name and briefly describe the capabilities of

a DBMS.

• Define a relational DBMS and explain how it

organizes data.

• Explain the importance of data manipulation languages.

• Explain why non-relational databases are

useful.

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

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