Exam 1: Introduction to Database Management

Redundancy wastes space because you are storing the same data in more than one place.

An association between entities is known as a(n) ____.

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

There is a greater impact of failure in a nondatabase,file-oriented system.

List the advantages of database processing.

A database file requires a large amount of disk space and internal ____________________.

A DBMS lets you assign users to ____.

A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger.

____ are screen objects used to maintain,view,and print data from a database.

A(n) ____ is a characteristic or property of an entity.

A group of people in charge of a database within an organization is often called the ____________________.

Eliminating ____________________ not only saves space but also makes the process of updating data much simpler.

Programs created with Visual Basic,Java,Perl,PHP,or C++ can access the database directly,rather than having to access it through the DBMS.

Popular ____ include Access,Oracle,DB2,MySQL,and SQL Server.

The ____ of an entity become the columns in the database table.

In a(n) ____________________ relationship between two entities,each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.

In an E-R diagram,____________________ represent entities.

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

In a database,each entity has its own table.

A spreadsheet's data-sharing features allows multiple employees to update data in one spreadsheet at the same time.