logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Data Models into Database Designs See What Others Are Saying!
  • Question

  • When transforming an entity-relationship model into a relational database design, each entity is represented as a table.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • More questions

    • 1. A supertype/subtype hierarchy has which of the following features?

    • Options
    • A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
    • B. Attributes are assigned at the highest logical level.
    • C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
    • D. Attributes are assigned at the lowest logical level.
      • Discuss
    • 2. CASE tools do not include which of the following features?

    • Options
    • A. Help to draw data models
    • B. Help to generate code
    • C. Help to manage people
    • D. Create an information repository
      • Discuss
    • 3. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. When an entity instance must be a member of only one subtype, it is which of the following?

    • Options
    • A. Disjoint with total specialization
    • B. Disjoint with partial specialization
    • C. Overlap with total specialization
    • D. Overlap with partial specialization
      • Discuss
    • 5. A database application can perform which of the following activities?

    • Options
    • A. Add records
    • B. Read records
    • C. Update records
    • D. All of the above.
      • Discuss
    • 6. Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Typically, there should be at least two different copies of the database schema used in the redesign process.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. A primary key is which of the following?

    • Options
    • A. Any attribute
    • B. An attribute that uniquely identifies each row
    • C. An attribute that uniquely identifies each column
    • D. A derived attribute
      • Discuss
    • 9. A functional dependency is a relationship between or among attributes.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Selecting a data type involves which of the following?

    • Options
    • A. Maximize storage space
    • B. Represent most values
    • C. Improve data integrity
    • D. All of the above.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.