Comp267 Exam 1 Study Guide

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

Attribute

The database structure in a DBMS is stored as a __________

Collection of files

A(n) ________ is an example of a certain type that relates to a 'business rule' in the 'real world' such as how many students are allowed in a class.

Constraint

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

Convience

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

TRUE | FALSE A query language is a procedural language.

False, it is non-procedural

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

Field

is used to reveal the meaning of data

Information

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

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

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

Model

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

Performance Tuning

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

Shows the complexity of the system to the user

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

Structured

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

T/F : True

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.

T/F: False

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

T/F: True

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

T/F: True

Which of the following is true about business rules

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

Data constitute the building blocks of information.

True

Metadata can be described as the following

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

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

enterprise

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

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