Database midterm.txt

Card Set Information

Database midterm.txt
2012-10-03 21:22:05

database midterm flashcards
Show Answers:

  1. Three conditions that suggest the designer should model a relationship as an associative entity type are
    • 1) all of the relationships for the participating entity types are "many" relationships
    • 2) the resulting associative ended the type as independent meaning to end users, and it preferably can be identified with a single attribute identifier
    • 3) the associative identity has 1 or more attributes in addition to the identifier.
  2. Languages menus and other facilities by which users interact with the database are collectively called an
    User interface
  3. Which of the following is software used to create, maintain, and provide controlled access to databases?
    Database management system
  4. A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a
  5. A rule that can NOT be violated by database users is called a
  6. With the database approach, data descriptions are stored in a central location known as a
  7. A _______ is often developed by identifying a form or report that a user needs on a regular basis.
    User view
  8. A picture of the high-level entities for an organization and the relationships among the entities is called a
    Enterprise data model
  9. A database is an organized collection of ______ related data
  10. Which of the following types of data can be stored in the database?
    Voice, letters, and numbers
  11. The database environment data processed in a way that increases a user's knowledge is
  12. Which of the following is an integrated decision support database with content derived from various operational databases?
    Data warehouse
  13. CASE is a class of tools that
    Automates the design of databases and application programs
  14. The common types of entities are:
    Strong, weak, and associative entities
  15. A relationship between the instances of a single entity type is called a ______ relationship.
  16. The number of entity types that participate in a relationship is called the
  17. What conditions should exist if an associative entity is to be created?
    1) All the relationships for the participating entities are many-to-many.

    2) The new associative entity has independent meaning.

    3) The new associative entity participates in independent relationships.
  18. An entity that associates the instances of 1 or more in the entity types and contains attributes specific to the relationships is called a
    Associative entity
  19. An attribute that uniquely identifies an entity, and consist of a composite attribute is called a
    Composite identifier
  20. The total quiz points for a student for an entire semester is a _____ attribute
  21. An attribute that can be calculated from related attribute values is called a _____ attribute
  22. And attribute that can be broken down into smaller parts is called a ______ attribute
  23. An attribute of an entity that must have a value for each entity instance is called a
    Required attribute
  24. A property or characteristic of an entity type that is of interest to the organization is called a
  25. A person's name, birthday, and social security number are examples of
  26. An attribute that must have a value for every entity or relationship instance is called a
    Required attribute
  27. A ______ is the relationship between a weak entity type and its owner
    Identifying relationship
  28. An entity type who's existence depends on another entity type is called a _____ entity
  29. Customers, cars, and parts are examples of
  30. The logical representation of an organizations data is called a
    Entity-relationship model
  31. A _____ specifies the number of instances of one entity that can be associated with each instance of another entity
    Cardinality constraint
  32. A simultaneous relationship among the instances of three entity types is called a _____ relationship
  33. A relationship where the minimum and maximum cardinality are both one is a _____ relationship
    Mandatory one
  34. A student can attend 5 classes, each with a different professor. Each professor has 30 students. The relationship of the students to Professors is a _____ relationship
  35. A primary key who's value is unique across all relations is called a
    Enterprise Key
  36. A functional dependency between 2 or more non key attributes is called a
    Transitive dependency
  37. A functional dependency in which 1 or more non key attributes are functionally dependent on part, but not all, of the primary key is called a ____ dependency
    Partial functional
  38. A relation that contains no multi valued attributes, and has no non key attributes solely dependent on the primary key, but contains transitive dependencies is it in which normal form?
  39. A constraint between 2 attributes is called a
    Functional dependency
  40. A relation that contains minimal redundancy and allows easy use is considered to be
    Well structured
  41. An attribute that uniquely identifies each row in a relation is called a
    Primary key
  42. A 2 dimensional table of data is called a
  43. The entity integrity rule states that
    No primary key attributes can be null
  44. An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a
    Foreign key
  45. A primary key that consist of than more than 1 attribute is called a
    Composite key