Database Design FINAL

All of the following should be better with a good DBMS except:

Convenience

The _____ serves as the intermediary between the user and the database.

DBMS

_____ problems can occur when different versions of the same data appear in different places.

Data inconsistency

A(n) ____ database is used by an organization and supports many users across many departments.

Enterprise

A query language is a procedural language.

False

Business rules are only applicable to businesses and government groups. They do not apply to other types of organizations such as religious groups or research laboratories.

False

Within the database environment, a data model does not represent the data structures for the purpose of supporting a specific problem domain.

False

_________ is used to reveal the meaning of data.

Information

A name for an object should be all the following except:

It should aways be plural so it always ends with an 's'.

The type of relationship that describes how a 'student' would relate to a 'class' would be which of the following:

Many to Many

________ relates to the activities that makes the database act more efficiently in terms of storage and access speed.

Performance Tuning

___ data is the result of formatting to facilitate storage, use and generation of information.

Structured

Which of the following is true about business rules

They can serve as a communication tool between the users and designers.

A data model that is ready to implement should have a description of the data structure that will store the end-user data.

True

Data constitute the building blocks of information.

True

The rows in different tables are related based on common values in common attributes in an SQL-based relational database.

True

In a file system, a(n) __________ is a characteristic that would equate to a field or a cell in a database.

attribute

To allow designers to use a graphical tool to examine structures that represent the real world rather than describing them with text is why the ______ was developed.

entity relationship diagram

A ____ is a character or group of characters that has a specific meaning.

field

_____ is the result of revealing the meaning of raw facts.

field

Metadata can be described as the following:

it provides data that describes the database along with its content and structure

Helping you to gain knowledge of the complexities of the real-world environment is one of the main functions of a(n) _____________.

model

Anything that can have data gathered on it and stored is called a(n) _________.

object

A(n) _____________ can go in both directions between entities.

relationship

The relational data management system (RDBMS) has all the following except it

shows the complexity of the system to the user