MIS Chapter 5

primary key

A field (or group of fields) that uniquely identifies a given entity in a table

___ refers to data collections that are characterized by huge volume, rapid velocity, and great variety.

BigData

Phone number, email address, first and last name, are all examples of ___________ because they describe the characteristics of an entity. A. foreign keys B. identifiers 0% C. tables D. attributes

D attributes

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.

N:M

the term used to describe non-relational databased that support very hight transaction rates processing relatively simple data structures.

NoSQL

standard language for inserting, updating, and deleting data in a database

SQL

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

USERS

Every table in a normalized database has a(n) ________.

a single theme

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________.

attributes

A data integrity problem will occur only if ________.

data are duplicated in a database.

A(N) ____ is a program used to create, process and administer a database

database management system

A(n) ____ DBMS is designed to process large organizational and workgroup databases.

enterprise

a database developer is likely to use a(n) ____ to serve as the blueprint for building a database. This took describes the entities, attributes, and relationships among entities.

entity-relationship data model

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables

foreign key

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) ______

primary key

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

query form/query is what she wants to create to obtain the information she wants