You can think of a table as a persistent

This preview shows page 9 - 12 out of 168 pages.

You can think of a table as a persistent representation of a logical relation.TrueFalseTrue
The one-to-many (1:M) relationship is easily implemented in the relational model by putting theforeign key of the "1" side in the table of the "many" side as a primary key.
The ______ constraint can be placed on a column to ensure that every row in the table has a value forthat column.UNIQUEEMPTYVALUENOT NULLNOT NULLThe relationship is the "relational model ideal."
_____ are especially useful when you are trying to determine what values in related tables causereferential integrity problems.
When you define a table's primary key, the DBMS automatically creates a(n) ____ index on theprimary key column(s) you declared.
uniquecompositekeyprimaryuniqueUpgrade to remove advertsOnly $1/month_____ logic, used extensively in mathematics, provides a framework in which as assertion (statementof fact) can be verified as either true or false.RelationalIndexDatabasePredicatePredicate
The practical significance of taking the logical view of a database is that it serves as a reminder of thesimple file concept of data storage.
A ___ key can be described as a minimal superkey, a superkey without any unnecessary attributes.
Each table _____ represents an attribute.
Each table in a relational database must have a primary key.TrueFalseTrue
In a database context, the word ____ indicates the use of the same attribute name to label differentattributes.
A ___ is any key that uniquely identifies each row.
The DIVIDE operation uses one single column table (e.g., column "a") as the divisor and one twocolumn table (e.g., columns "a" and "b") as the dividend
Date attributes contain calendar dates stored in a special format known as the ____ date format.calenderEpochlogicalJulianJulian
If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of thatcomposite key, the attribute (B) is fully functionally dependent on (A).
In a natural join, the column on which the join was made occurs twice in the new table.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 168 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
ádasdasd
Tags
Relational model

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture