And administering database management system dbms jack explains kate

Ch 5 Warmup/dsm/video/quiz
All of the following are reasons you need to know about databases:
You must be able to recognize the need to adapt databases to changing business needs.

You need to know how to turn stored data into useful information.

record
A descriptive name given to a field in a database, such as EmployeeID, is a part of the database's __________.

Metadata

Data model
It is important that database designers perform __________ prior to implementing the database in order to eliminate poorly structured tables.

Normalization
Two employees work in the same department. In the organization's database, one employee record states the department name as "Sales", but the other employee's record states the department name as "Sales andMarketing." This illustrates a _________ problem.

Which of the following statements is accurate?

Today, the relational database is not always the best choice for storing data.

Which of the following describes a database application?

A collection of forms, queries, and programs that process database

Which of the following best defines metadata?
Describes the structure of a database

Which of the following is true about a data model?

It is a logical representation of the data in a database that describes the data and relationships that will be stored in the database

In a database, bytes are grouped into __________.

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

Which of the following is the primary purpose of using a database? To keep track of data

Creating a data model

A database management system differs from a traditional file system in that a database management system __________.

Which company utilizes MongoDB because it does not require normalized data but manages collections of documents that have a variety of structures?

Craigslist

Which of the following is an open source document-oriented DBMS that is used by Craigslist and Foursquare because it does not require normalized data but manages collections of documents that have a variety of structures?

MongoDB

Which step is NOT required in transforming a data model into a relational database design? Normalize each table to have multiple themes

A database management system differs from a traditional file system in that a database management system __________.

Database management system (DBMS)
As Jack explains to Kate, a database is described as a collection of integrated records because _____.

Tables with the same field are linked

Entity?

Prior to implementing a database in a DBMS, the developers perform _________ in order to improve the structure of the database tables.

Foreign key
Which of the following statements is correct?

The three essential elements of the definition of a database are ________.

The following are all processing operations of a DBMS except _________.

DBMS creates, process, and administer database.

Data is inconsistent/table data is duplicated
In the context of a database, _________ is data that describes the content of the database.

Metadata
if Falcon Security chooses to use a SQL DBMS such as Access, it will be able to __________.

With today's focus on Internet applications, it is far less necessary that database systems impose ________ restrictions on transaction processing.

Acid
When you state a business rule that pertains to your organization, such as "At my university, a student may declare only one single major," you are actually defining the __________ of the relationship between students and majors.