Exam 5: Database Processing

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.

Which of the following is true of N:M relationships?

________ forms are used to read, insert, modify, and delete data.

Metadata refer to entities that users of a database want to process.

The purpose of a database is to keep track of things that involve a single theme.

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)________.

What is the purpose of a database?

How does normalization resolve the data integrity problem?

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

In a data model, a(n)________ is something that a user wants to track.

A key is a column or group of columns that identifies a unique row in a table.

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

A drawback of DBMS programs is that they do not provide comprehensive and robust features for querying database data.

A line in an E-R diagram is used to represent the attributes of the entities.

Special data that describes the structure of a database is called metadata.

A line on an E-R diagram that indicates a 1:N relationship between two entities is referred to as ________.

The easiest time to change the database structure is immediately before the data modeling stage.

The tables that appear in a database are known as ________.

In order to find the data one is looking for in a DBMS, one has to type in the keyword into a query form.

What are the steps involved in transforming a data model into a relational database design?