Like this study set? Create a free account to save it.

Sign up for an account

Already have a Quizlet account? .

Create an account


Each column in a table of a relational database should have a distinct name.


In a relation, all values in a column are values of the same attribute.


A relation is essentially a three-dimensional table.


Columns are sometimes called tuples.


Because there is a one-to-many relationship between sales reps and customers n the Premiere Products database, One sales rep can be associated with zero, one, or more customers.


A tabular database is a collection of tables.


In a relational database, relationships are implemented by having common columns in two or more tables.


In a relational database, two columns can be identical


The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class, you also know the pay rate.


The definition for a primary key really defines a candidate key as well


A programmer interviews users, examines existing and proposed documents, and examines organizational policies to determine exactly the type of data needs the database must support


Normalization is done before creating the database design


An unnormalized relation is a relation that contains repeating groups.


A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.


A determinant is any column (or collection of columns) that determines another table.

All of the above (attribute, field, column)

A(n) ____ is a characteristic or property of an entity.


At Premiere Products, there is a ____ relationship between sales reps and customers.

row, record, tuple

In a relational database each ____ should be unique.


There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table, all the columns in the table are listed within a set of ____.


Which of the following symbols is used to qualify column names?

Order_num and Part_num

Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?

database design

The process of determining the particular tables and columns that will comprise a database is known as ____.


A(n) ____ is the association between entities.


Any column (or collection of columns) that determines another column is called a(n) ____.


In an entity-relationship (E-R) diagram, ____ are used to represent an entity.


In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____ .


____ is the duplication of data.

first normal form

A relation is in ____ if it does not contain any repeating groups.

third normal form

In this text, Boyce-Codd normal form is the same as ____.


A ____ column is a column that is not part of the primary key.


A field is another term for a(n) ____.


A record is another term for a(n) ____.


____ is the formal term for combining two or more columns to form a primary key.

inconsistent data

____ is one of the categories of update anomalies.

update anomalies

____ can occur when there is a column in a table that is dependent on only a portion of the primary key.


A(n) ______ is a person, place, object, event, or idea for which you want to store and process data.


A(n) ________ is the association between entities.


A table's design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n) _____ group) in an individual location in the table.


A relational database is a collection of ________.


The _______ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.


A(n) _____ column is a column that is not part of the primary key.


________ is another name given to third normal form in this text.


In one style of entity-relationship (E-R) diagrams, diamonds are used to describe _____.


The four categories of update anomalies are additions, deletions, inconsistent data, and ______.


If the primary key of a table contains only a single column, the table is automatically in _____ normal form.


A(n) ____ is another name for a record or a row.


When you write a column in the format CUSTOMER.REP_NUM, you say that you _____ the column name

functionally dependent

In a relational database, column B is ______ on another column A, it at any point in time a value for A determines a single value for B.


In a relation, the order of the rows and columns is ____________________


A relationship is an association between _______.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions and try again


Reload the page to try again!


Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

Voice Recording