Assume you are dealing with a purchasing database involving a single table This

Assume you are dealing with a purchasing database

This preview shows page 2 - 4 out of 7 pages.

19.Assume you are dealing with a purchasing database involving a single table. This table contains information on the customer, sale, and items purchased; the sales order number is the primary key. Using this database design, as you remove old sales information, you may lose information on some of your customers. This is an example ofA. a hidden dependencyB. a deletion anomolyC. an update anomolyD. an insertion anomoly20.Which of the following is true about the following BOOK dependency diagram where ISBN is the primary key?21.Which of the following is true about a simple primary key?
Background image
22.An attribute that must have a value for every entity (or relationship) instance is a(n):23. A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a _________ relationshipA. one-to-oneB. one-to-manyC. many-to-manyC. strong24.Which of the following is true about supertype, subtype structure?A. Relationship at the supertype level indicate that all subtypes will participate in the relationshipB. Subtype entities inherit values of all attribute of the supertypeC. An instance of a subtype is also an instance of the supertypeD. all of the above25.In the figure below, what is true about the attributes ItemNo and ComponentNo?26.The attribute on the left-hand side of the arrow in a functional dependency is a A. primary keyB. determinantB. non-keyC. none of the above27.A functional dependency of the form Student# Advisor Advisor_Office is called a:
Background image
Image of page 4

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '16
  • Ray
  • d., Relational model, primary key, MIDTERM EXAM FALL 2018, A. SNUM

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture