Chapter PI3: Fundamentals of Relational Databases Operations
Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
The main goal of normalization is to...
Eliminate data redundancy.
What is done to a database in the normalization process?
Tables with redundant data are linked.
Which database operation is required to combine two or more tables in a database?
A join operation in databases is most similar to...
Combining groups of numbers into a new group.
Which two terms are synonymous when speaking about a database?
How is a unary relationship different from a binary relationship?
A unary relationship exists when an association involves one entity instead of two entities
Why is it important to normalize a database?
To operate the database efficiently
Why does normalization minimize data redundancy?
It links tables with common entities
How is a "many-to-many" relationship described in terms of connectivity?
In SQL, the SELECT statement is used to...
Choose the desired attribute to work with.
How does QBE work?
Users fill out a grid to find the information they want.
Which language does NOT require extensive programming?
What is the purpose of a determinant?
To influence the value of another attribute.
The third normal form of a database indicates that...
All redundant data has been removed from its data tables.
What is meant by functional dependency?
A way of expressing the value of an attribute that is associated with a value of another.
Which statement in SQL should be used to search data for a given criteria?
What type of information does a data dictionary store? There maybe more than one.
C) Validity rules/ values
Attributes, Keys, and Validity rules/ values
___ is defined as the maximum number of times an instance of one entity can be associated with the instance of another entity.
An ER diagram is used to...
Plan and design the structure of a database.
A database must have one or more primary keys but may or may not have secondary keys. True or False?
Home > Flashcards > Print Preview