The one to many 1m relationship is easily implemented

This preview shows page 3 - 5 out of 9 pages.

19. The one-to-many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the “1”side in the table of the “many” side as a primary key.a. Trueb. FalseANSWER:False
20. As rare as 1:1 relationships should be, certain conditions absolutely require their use.
Multiple Choice21. _____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can beverified as either true or false.a
22. Each table _____ represents an attribute.a
23. Date attributes contain calendar dates stored in a special format known as the _____ date format.a. Epochb. calendarc. Juliand. logicalANSWER:c
24. In the relational model, _____ are important because they are used to ensure that each row in a table is uniquelyidentifiable.b
25. A _____ is any key that uniquely identifies each row.a
26. A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.b
Chapter 03: The Relational Database Model27. A _____ is the primary key of one table that has been placed into another table to create a common attribute.a. superkeyb. composite primary keyc. candidate keyd. foreign keyANSWER:d
28. A _____ key is defined as a key that is used strictly for data retrieval purposes.d
29. Referential _____ dictates that the foreign key must contain values that match the primary key in the related table, ormust contain null.a
30. The CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, andall 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 has a value for that column.a. UNIQUEb. NOT NULLc. VALUEd. EMPTYANSWER:b
32. To be considered minimally relational, the DBMS must support the key relational operators _____, PROJECT, andJOIN.d
33. _____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.d

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

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags
Relational model

Newly Uploaded Documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture