The flashcards below were created by user
SeanCarraway
on FreezingBlue 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
User interface
-
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
Repository
-
A rule that can NOT be violated by database users is called a
Constraint
-
With the database approach, data descriptions are stored in a central location known as a
Repository
-
A _______ is often developed by identifying a form or report that a user needs on a regular basis.
User view
-
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
Logically
-
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
Information
-
Which of the following is an integrated decision support database with content derived from various operational databases?
Data warehouse
-
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.
Unary
-
The number of entity types that participate in a relationship is called the
Degree
-
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
Associative entity
-
An attribute that uniquely identifies an entity, and consist of a composite attribute is called a
Composite identifier
-
The total quiz points for a student for an entire semester is a _____ attribute
Derived
-
An attribute that can be calculated from related attribute values is called a _____ attribute
Derived
-
And attribute that can be broken down into smaller parts is called a ______ attribute
Composite
-
An attribute of an entity that must have a value for each entity instance is called a
Required attribute
-
A property or characteristic of an entity type that is of interest to the organization is called a
Attribute
-
A person's name, birthday, and social security number are examples of
Attributes
-
An attribute that must have a value for every entity or relationship instance is called a
Required attribute
-
A ______ is the relationship between a weak entity type and its owner
Identifying relationship
-
An entity type who's existence depends on another entity type is called a _____ entity
Weak
-
Customers, cars, and parts are examples of
Entites
-
The logical representation of an organizations data is called a
Entity-relationship model
-
A _____ specifies the number of instances of one entity that can be associated with each instance of another entity
Cardinality constraint
-
A simultaneous relationship among the instances of three entity types is called a _____ relationship
Ternary
-
A relationship where the minimum and maximum cardinality are both one is a _____ relationship
Mandatory one
-
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
Many-to-many
-
A primary key who's value is unique across all relations is called a
Enterprise Key
-
A functional dependency between 2 or more non key attributes is called a
Transitive dependency
-
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
Partial functional
-
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?
Second
-
A constraint between 2 attributes is called a
Functional dependency
-
A relation that contains minimal redundancy and allows easy use is considered to be
Well structured
-
An attribute that uniquely identifies each row in a relation is called a
Primary key
-
A 2 dimensional table of data is called a
Relation
-
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
Foreign key
-
A primary key that consist of than more than 1 attribute is called a
Composite key
|
|