Card Set Information
database midterm flashcards
Three conditions that suggest the designer should model a relationship as an associative entity type are
1) all of the relationships for the participating entity types are "many" relationships
2) the resulting associative ended the type as independent meaning to end users, and it preferably can be identified with a single attribute identifier
3) the associative identity has 1 or more attributes in addition to the identifier.
Languages menus and other facilities by which users interact with the database are collectively called an
Which of the following is software used to create, maintain, and provide controlled access to databases?
Database management system
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a
A rule that can NOT be violated by database users is called a
With the database approach, data descriptions are stored in a central location known as a
A _______ is often developed by identifying a form or report that a user needs on a regular basis.
A picture of the high-level entities for an organization and the relationships among the entities is called a
Enterprise data model
A database is an organized collection of ______ related data
Which of the following types of data can be stored in the database?
Voice, letters, and numbers
The database environment data processed in a way that increases a user's knowledge is
Which of the following is an integrated decision support database with content derived from various operational databases?
CASE is a class of tools that
Automates the design of databases and application programs
The common types of entities are:
Strong, weak, and associative entities
A relationship between the instances of a single entity type is called a ______ relationship.
The number of entity types that participate in a relationship is called the
What conditions should exist if an associative entity is to be created?
1) All the relationships for the participating entities are many-to-many.
2) The new associative entity has independent meaning.
3) The new associative entity participates in independent relationships.
An entity that associates the instances of 1 or more in the entity types and contains attributes specific to the relationships is called a
An attribute that uniquely identifies an entity, and consist of a composite attribute is called a
The total quiz points for a student for an entire semester is a _____ attribute
An attribute that can be calculated from related attribute values is called a _____ attribute
And attribute that can be broken down into smaller parts is called a ______ attribute
An attribute of an entity that must have a value for each entity instance is called a
A property or characteristic of an entity type that is of interest to the organization is called a
A person's name, birthday, and social security number are examples of
An attribute that must have a value for every entity or relationship instance is called a
A ______ is the relationship between a weak entity type and its owner
An entity type who's existence depends on another entity type is called a _____ entity
Customers, cars, and parts are examples of
The logical representation of an organizations data is called a
A _____ specifies the number of instances of one entity that can be associated with each instance of another entity
A simultaneous relationship among the instances of three entity types is called a _____ relationship
A relationship where the minimum and maximum cardinality are both one is a _____ relationship
A student can attend 5 classes, each with a different professor. Each professor has 30 students. The relationship of the students to Professors is a _____ relationship
A primary key who's value is unique across all relations is called a
A functional dependency between 2 or more non key attributes is called a
A functional dependency in which 1 or more non key attributes are functionally dependent on part, but not all, of the primary key is called a ____ dependency
A relation that contains no multi valued attributes, and has no non key attributes solely dependent on the primary key, but contains transitive dependencies is it in which normal form?
A constraint between 2 attributes is called a
A relation that contains minimal redundancy and allows easy use is considered to be
An attribute that uniquely identifies each row in a relation is called a
A 2 dimensional table of data is called a
The entity integrity rule states that
No primary key attributes can be null
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a
A primary key that consist of than more than 1 attribute is called a