CIS 336 DeVry Week 2 Quiz Latest

Downloading is very simple, you can download this Course here:

http://wiseamerican.us/product/cis-336-devry-week-2-quiz-latest/

Or

Contact us at:

SUPPORT@WISEAMERICAN.US

CIS 336 DeVry Week 2 Quiz Latest

CIS336

CIS 336 DeVry Week 2 Quiz Latest

Question 1. Question : (TCO 2) Which statement is FALSE regarding a primary key?

  • Only parent tables must have a primary key.
  • The values must be unique.
  • It can be made up of multiple attributes.
  • The value cannot be NULL.

Question 2. Question : (TCO 2) _____ integrity insures that the value of a foreign key must match a primary key value in the table to which it is related, or be null.

  • Referential
  • Entity
  • Data
  • Logical

Question 3. Question : (TCO 2) A verb associating two nouns in a business rule usually translates to a(n) ____ in the data model.

  • entity
  • attribute
  • relationship
  • constraint

Question 4. Question : (TCO 4) A(n) _____ provides a graphical description of a data model.

  • entity relationship diagram
  • data dictionary
  • business rule
  • pseudocode

Question 5. Question : (TCO 2) A _____ primary key is made up of more than one attribute.

  • composite
  • foreign
  • bridge
  • linking

Question 6. Question : (TCO 4) In the figure below, the OrderLineItems entity is there to implement what type of relationship between Orders and Products?

  • One to one
  • One to many
  • Many to many
  • No relationship

Question 7. Question : (TCO 2) When designing a database, you should _____.

  • make sure entities are in normal form before table structures are created
  • create table structures then normalize the database
  • only normalize the database when performance problems occur
  • consider more important issues, such as performance, before normalizing

Question 8. Question : (TCO 2) A table that is in 1NF and includes no partial dependencies only is said to be in _____.

  • 1NF
  • 2NF
  • 3NF
  • BCNF

Question 9. Question : (TCO 2) A table is not in 1NF if _____.

  • it has a primary key defined
  • all of the key attributes are defined
  • there are repeating groups in the table
  • all attributes are dependent on the primary key

Question 10. Question : (TCO 2) Entity attributes and primary keys are not present in the _____ data model.

  • logical
  • physical
  • conceptual
  • network