Referential dictates that the foreign key must

  • No School
  • AA 1
  • DoctorOxideTurtle301
  • 48
  • 97% (29) 28 out of 29 people found this document helpful

This preview shows page 24 - 27 out of 48 pages.

29. Referential _____ dictates that the foreign key must contain values that match the primarykey in the related table, or must contain null.a. integrityb. uniquenessc. modeld. attributeANSWER:a
30. The CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary keycolumn has no null entries, and all entries are unique. This is an example of _____ integrity.a
31. The _____ constraint can be placed on a column to ensure that every row in the table hasa value for that column.b
32. To be considered minimally relational, the DBMS must support the key relationaloperators _____, PROJECT, and JOIN.d
33. _____, also known as RESTRICT, yields values for all rows found in a table that satisfy agiven condition.a. INTERSECTb. UNIONc. DIFFERENCEd. SELECTANSWER:d
34. _____ returns only the attributes requested, in the order in which they are requested.
a
35. When two or more tables share the same number of columns, and when theircorresponding columns share the same or compatible domains, they are said to be _____.b
36. A(n) _____ join links tables by selecting only the rows with common values in theircommon attribute(s).d
37. _____ are especially useful when you are trying to determine what values in related tablescause referential integrity problems.a. Inner joinsb. Outer joinsc. Equijoinsd. Theta joinsANSWER:b
38. A(n) _____ only returns matched records from the tables that are being joined.b
39. A _____ contains at least all of the attribute names and characteristics for each table in thesystem.a
40. The _____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.d
41. In a database context, the word _____ indicates the use of the same attribute name to labeldifferent attributes.a. redundancyb. homonymc. duplicated. synonymANSWER:b
42. In a database context, a(n) _____ indicates the use of different names to describe the sameattribute.c

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 48 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags
Entity relationship model, Relational model, c

Newly Uploaded Documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture