Database Systems: Design, Implementation, & Management: Database System Quizzes Flashcards
____is the result of revealing the meaning of raw facts.
End_user data is____.
raw facts of interest to the end user
______provide a description of the data characteristics and the set of relationships that link the data found within the database.
______exists when different versions of the same data appear in different places.
The response of the DBMS to a query is the _____.
Query result set.
Data Warehouse contains historical data obtained from the______.
_____data exist in the format in which they were collected.
_______data exist in a format that does not lend itself to processing that yields information.
______is defined as the condition in which all the data in the database are consistent with the real-world events and conditions.
The term_____ refers to an organization of components that define and regulate the collection,storage, management and use of data within a database environment.
Business rules are derived from____.
A detailed description of an organization's operations
A noun in a business rule translates to a(n)___ in the data model.
A verb associating two nouns in a business rule translates to a(n)___in the data model.
A(n)___ represents a particular type of object in the real world.
The___model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
A(n)___ is anything about which data are to be collected and stored.
A(n)___is the equivalent of a field in a file system.
A(n)__ is bidirectional.
____are important because they help to ensure data integrity.
Students and classes have a ____relationship.
The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct knows as a(n)___.
In a relational table, each column has a specific range of values knows as the ____domain
In the relational model,___are important because they are used to ensure that each row in a table is uniquely identifiable.
Attribute A determines attribute B(that is, B is functionally _____ on A) if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
A(n)____key can be described as a superkey without unnecessary attributes.
If the foreign key contains either matching values or nulls, the table that makes use of that foreign key is said to exhibit ___integrity.
To avoid nulls, some designers use special codes, known as____, to indicated the absence of some value.
The relational operators have the property of ____; that is, the use of relational algebra operators on existing relations(tables)produce new relations.
PRODUCT yields all possible pairs of rows from two tables--also known as the ____product.
The___ is the real power behind the relational database, allowing the use of independent tables linked by common attributes
A(n)___links tables on the basis of an equality condition that compares specified columns of each table.
The___joins are especially useful when you are trying to determine what value(s) in related tables cause(s) referential problems.
A(n)____provides a detailed description of all tables found with the user/designer-created database
The___relationship is the relational database norm.
If one department chair--a professor--can chair only one department and one department can hae only one department chair, the the entities PROFESSOR and DEPARTMENT exhibit a(n)___relationship.
The ___relationships can be implemented by creating a new entity in 1:M relationships with the original entities.
The proper use of ___keys is crucial to controlling data redundacy
A(n)___is an orderly arrangement used to logically access rows in a table.
The index Key can have multiple attributes, this is call a(n)____index
Codd's rule of ____states that every value in a table is guaranteed to be accessible through a combination of table name, primary key value, and column name.
The Chen model is especially useful to illustrate the database from a(n)___perspective.
Successful database design is, first and foremost, based on ___requirements.
A derived attribute____.
need not be physically stored within the database.
Cardinality expresses___ number of entity occurrences associated with one occurrence of the related entity
A____attribute can be further subdivided to yield additional attributes.
If an entity can exist apart from one or more related entities, it is said to be ___-independent
A___relationship exists when two entities are associated.
The set of possible values for an attribute is a ___.
What type of attribute cannot be created in a DBMS?
A relationship name should be a(n)___.
From a Structural point of view, 2NF is better than this
It produces a lower normal form
it cause data redundancies of data on every row entry
Any attribute whose value determines other values within a row
A process to help reduce the likelihood of data anomalies
it derives its name from the face that a group of multiple entries of the same type can exist for any single key attribute occurrence.
Any attribute that is at least part of a key
a diagram that depicts all dependencies found within a given table structure.
a dependency bases on only a part of a composite primary key.
Refers to the level of detail represented by the values stored in a table's row.
Relational models view the data as part of a table or collection of tables in which all key values must be idenified
Repeating groups must be eliminated by making sure that each row defines a single entity
Converting a database format to 1NF to 2NF is a complex process.
A table is in 2NF if it is in 1NF and it includes no partial dependecies
It is possible for a table in 2NF to exhibit transitive dependency, where one or more attributes may be functionally dependent on non-key attributes.
Denormalization is a process for assigning attributes to entities
Dependencies that are based on only a part of a composite primary key are called transitive dependencies
Repeating groups must be eliminated by making sure that each column defines a single entity.
All relational tables satisfy the 1NF requirements.
Atomic attributes are attributes that can be further divided.