Chapter 5 - Homework of Chapter 5 CIS4271/CIS6274 Fall Quarter 2007 MULTIPLE CHOICE Choose the one alternative that best completes the statement or

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Homework of Chapter 5 CIS4271/CIS6274 Fall Quarter 2007 MULTIPLE CHOICE: Choose the one alternative that best completes the statement or answers the question. 1. ( B ) A form of database specification that indicates all the parameters for data storage that are then input to database implementation is: A) logical. B) physical. C) schematic. D) conceptual. 2. ( B ) A primary key that consists of more than one attribute is called a: A) foreign key. B) composite key. C) multivalued key. D) cardinal key. 3. ( A ) In Figure tb5–1, the primary key for “Order Line” is which type of key? Figure tb5–1 A) Composite B) Foreign C) Standard D) Grouped 4. ( C ) Which of the following is NOT a reason to create an instance of a relational schema with sample data? A) Sample data can be used to improve user communications. B) Sample data can be used for prototype generation. C) Sample data can reverse database implementation errors. D) Sample data provide a convenient way to check the accuracy of your design. 5. ( A ) The entity integrity rule states that: A) no primary key attribute can be null. B) referential integrity must be maintained across all entities. C) each entity must have a primary key. D) a primary key must have only one attribute. 6. ( C ) A domain definition consists of the following components EXCEPT:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
A) domain name. B) data type.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This homework help was uploaded on 04/17/2008 for the course CIS 4271 taught by Professor Du during the Fall '07 term at CSU East Bay.

Page1 / 6

Chapter 5 - Homework of Chapter 5 CIS4271/CIS6274 Fall Quarter 2007 MULTIPLE CHOICE Choose the one alternative that best completes the statement or

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online