Devry CIS 336 Week 2 Quiz Latest

Description

Devry CIS 336 Week 2 Quiz Latest 

Devry CIS336 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

DeVry Courses helps in providing the best essay writing service. If you need 100% original papers for Devry CIS 336 Week 2 Quiz Latest , then contact us through call or live chat.

Devry CIS 336 Week 2 Quiz Latest