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.
In a relational database, relationships are implemented by having common columns in two or more tables.
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.
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
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.
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 ____.
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?
The process of determining the particular tables and columns that will comprise a database is known as ____.
Any column (or collection of columns) that determines another column is called a(n) ____.
In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____ .
____ 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 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.
The _______ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.
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.
When you write a column in the format CUSTOMER.REP_NUM, you say that you _____ the column name
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.