What is a database?
An organized collection of related data.
What does DBMS software do with a database?
It defines, creates, stores, retrieves, updates, and controls access to it.
Which data models are included in the data-model classification?
Hierarchical, network, relational, entity–relationship, object-oriented, object-relational, and semi-structured models.
How does the hierarchical model organize data?
As a tree with parent-child relationships.
What is a transaction in database management?
A logical unit of work containing one or more database operations.
What stages make up database design, from requirements through validation?
Requirements gathering, conceptual ER design, relational conversion, normalization, SQL implementation, and testing.
What is an entity in ER modeling?
A distinguishable real-world object.
In the relational model, what does a tuple represent?
A row.
How does transaction management protect database validity?
It coordinates concurrent operations and failures.
What does a relational schema describe?
A relation’s name and attributes.
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?
Go over the full study guide for DBMS.
Read the study guide →Upload your class notes and Revizly writes your flashcards in about a minute.
Flashcard maker