DBMS Flashcards (10 cards)

All cards

1Question

What is a database?

Answer

An organized collection of related data.

2Question

What does DBMS software do with a database?

Answer

It defines, creates, stores, retrieves, updates, and controls access to it.

3Question

Which data models are included in the data-model classification?

Answer

Hierarchical, network, relational, entity–relationship, object-oriented, object-relational, and semi-structured models.

4Question

How does the hierarchical model organize data?

Answer

As a tree with parent-child relationships.

5Question

What is a transaction in database management?

Answer

A logical unit of work containing one or more database operations.

6Question

What stages make up database design, from requirements through validation?

Answer

Requirements gathering, conceptual ER design, relational conversion, normalization, SQL implementation, and testing.

7Question

What is an entity in ER modeling?

Answer

A distinguishable real-world object.

8Question

In the relational model, what does a tuple represent?

Answer

A row.

9Question

How does transaction management protect database validity?

Answer

It coordinates concurrent operations and failures.

10Question

What does a relational schema describe?

Answer

A relation’s name and attributes.

Test yourself with the quiz

Answer 11 questions on DBMS.

1. Which statements accurately describe databases and DBMS functions?

2. A company changes its file organization while retaining its logical schema and applications. Which statements about data abstraction and independence are accurate?

Take the quiz →

Read the study guide

Go over the full study guide for DBMS.

Read the study guide →

Related classes

Make your own flashcards

Upload your class notes and Revizly writes your flashcards in about a minute.

Flashcard maker