Exam (elaborations) CIS336 336 quiz 4 final solved (CIS336)

CIS336 336 quiz 4 final solved
Score for this quiz: 24 out of 30
Submitted Jan 14 at 9:23pm
This attempt took 16 minutes.

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




Every table must have one.




The values must be unique.




It can be made up of multiple attributes.

Correct Answer


The value can be NULL.

See the Weeks 1 and 2 readings.


Question 2
pts
(TCO 2) integrity ensures that all primary key values are unique and no part of
a primary key may be null.




Referential

Correct Answer


Entity

, CIS336 336 quiz 4 final solved


Data




Logical

See the Weeks 1 and 2 readings.


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



entity




attribute




relationship




constraint

See the Weeks 1 and 2 readings.


Question 4
pts
(TCO 4) In Crow’s foot notation, a forked end indicates .

, CIS336 336 quiz 4 final solved
one




many




mandatory




optional

See the Weeks 1 and 2 readings.


Question 5
pts
(TCO 2) A primary key is often used in an associative or linking table.




composite




foreign




bridge




linking

See the Weeks 1 and 2 readings.

, CIS336 336 quiz 4 final solved
Question 6
pts
(TCO 4) In a typical online store scenario, which of the following diagrams best
represents the relationship between customers and orders placed by customers?




See the Weeks 1 and 2 readings.


Question 7
pts
(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