Exam 1: Introduction to Database Management

_________________________ describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange.

A good DBMS provides data _________________________, which is a property that lets you change the structure of a database without requiring you to change the programs that access the database.

Which database property lets you change the structure of the database without requiring you to change the programs that access the database?

Redundancy wastes space because you are storing multiple copies of the same data.

Which factor can mitigate the problems of increased complexity that come with using a DBMS?

Redundancy makes changing data more cumbersome and time-consuming.

List the advantages of database processing.

Discuss how the database approach and the nondatabase approach differ in terms of ensuring the security of the database.

Each table in a database represents two or more entities.

Explain why it is better to try to control redundancy rather than eliminate it.

A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.

What tool can you use to visually represent and analyze a database?

____________________ integrity is a relational database concept stating that table relationships must be consistent and follow integrity constraints.

In database terms, what is the analogy to an ordinary paper file you might keep in a file cabinet or an accounting ledger?

Which advantage of using a DBMS frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data?

In an E-R diagram rectangles represent _________________________.

Which of the following is called a field or column in many database systems?

Which aspect of an entity becomes the columns in the database table?

During which process does a database expert determine the structure of the required database?

What should an administrator use to more easily assign database access permissions to multiple users?