logo

CuriousTab

CuriousTab

Discussion


Home Database The Relational Model and Normalization Comments

  • Question
  • Which of the following is not a restriction for a table to be a relation?


  • Options
  • A. The cells of the table must contain a single value.
  • B. All of the entries in any column must be of the same kind.
  • C. The columns must be ordered.
  • D. No two rows in a table may be identical.

  • Correct Answer
  • The columns must be ordered. 


  • The Relational Model and Normalization problems


    Search Results


    • 1. For some relations, changing the data can have undesirable consequences called:

    • Options
    • A. referential integrity constraints.
    • B. modification anomalies.
    • C. normal forms.
    • D. transitive dependencies.
    • Discuss
    • 2. Table is synonymous with the term:

    • Options
    • A. record.
    • B. relation.
    • C. column.
    • D. field.
    • Discuss
    • 3. In the relational model, relationships between relations or tables are created by using:

    • Options
    • A. composite keys.
    • B. determinants.
    • C. candidate keys.
    • D. foreign keys.
    • Discuss
    • 4. The primary key is selected from the:

    • Options
    • A. composite keys.
    • B. determinants.
    • C. candidate keys.
    • D. foreign keys.
    • Discuss
    • 5. If attributes A and B determine attribute C, then it is also true that:

    • Options
    • A. A ? C.
    • B. B ? C.
    • C. (A,B) is a composite determinant.
    • D. C is a determinant.
    • Discuss
    • 6. A functional dependency is a relationship between or among:

    • Options
    • A. tables.
    • B. rows.
    • C. relations.
    • D. attributes.
    • Discuss
    • 7. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

    • Options
    • A. transitive dependency.
    • B. insertion anomaly.
    • C. referential integrity constraint.
    • D. normal form.
    • Discuss
    • 8. Which of the following is NOT a basic element of all versions of the E-R model?

    • Options
    • A. Entities
    • B. Attributes
    • C. Relationships
    • D. Primary keys
    • Discuss
    • 9. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

    • Options
    • A. Supertype entity
    • B. Subtype entity
    • C. Archetype entity
    • D. Instance entity
    • Discuss
    • 10. In which of the following is a single-entity instance of one type related to many entity instances of another type?

    • Options
    • A. One-to-One Relationship
    • B. One-to-Many Relationship
    • C. Many-to-Many Relationship
    • D. Composite Relationship
    • Discuss


    Comments

    There are no comments.

Enter a new Comment