Exam 4: Database Processing

1:N,N:M,and 1:1 are common examples of minimum cardinalities.

________ is the process of converting a poorly structured table into two or more well-structured tables.

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

When using the relational model to represent two tables,one must ________.

What is a database application?

A student management system allows students to have multiple majors,and advisers are assigned to handle multiple students and courses.This is an example of a(n)________ relationship.

In data models,physical objects are represented as entities,whereas logical constructs and transactions are represented as attributes.

A primary key used in a database is a ________.

Define primary key,foreign key,and metadata.

In a database,________ are grouped into columns.

Relational databases represent relationships using ________.

A group of similar rows or records in a table is called a field.

Albert creates a relational database to store employee performance statistics.He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee.This column is referred to as a(n)________.

In an entity-relationship (E-R)diagram,an entity is represented by a triangle,and the relationships between entities are represented by dotted lines.

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Most organizations develop their own DBMS software in order to obtain control over data.

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

In the case of single-user databases,the application,the DBMS,and the database all reside on the user's computer.

A database is a self-describing collection of integrated records.

A database is required instead of a spreadsheet when ________.