IS 202: Database Management System (DBMS) | Midterm

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/4

encourage image

There's no tags or description

Looks like no tags are added yet.

5 Terms

1
New cards

Set of software that facilitates the storage and access of data on a computer.

Database Management System

2
New cards

What are the features of a DBMS?

  • Data structure maintenance: add, delete, change data objects.

  • Data maintenance: add, delete, change data.

  • Data backup and recovery.

  • Concurrency control.

  • Data access (query) optimization.

  • Security.


3
New cards

What are the benefits of DBMS?

  • Scalability: Handles large amounts of data effectively without performance degradation.

  • Data Integrity: Supports robust data validation rules and constraints to ensure accuracy and consistency.

  • Complex Queries: Enables complex data manipulations and queries that involve multiple tables and criteria.

  • Format Flexibility: Allows data entered once to be easily viewed in many different formats.


4
New cards

What are the drawbacks of using a DBMS?

  • Learning Curve: Generally more difficult to learn and use compared to basic spreadsheets.

  • Pre-Planning Requirement: Requires careful pre-planning and design in advance before implementation.


5
New cards

Why do we store data in a database?

  • Protect data integrity

  • Make data more accessible

  • Make applications more adaptable