BIS 245 Week 5 Quiz

BIS 245 Week 5 Quiz | Devry University

Week 5: Quiz

Question 1

Which table type do plural attributes become?  

·         Independent    

·         Dependent  

·         Master 

·         Partitioned

 

 Question 2

What is the purpose of an entity synonym?  

·         To give the entity a description  

·         To use a proper naming convention for the entity   

·         To reflect common name usage of the entity 

·         To define the entity in the glossary

 

 Question 3

The primary key of a table created from a many-many relationship is the _____ of the foreign keys that refer to related tables.  

·         dependent    

·         composite  

·         master  

·         independent

 

 Question 4

When considering an attribute maximum, which term represents when each attribute instance describes at most one entity instance?  

·         Plural    

·         Unique  

·         Singular 

·         One

 

 Question 5

A database contains several relationships. Which is a valid relationship name?  

·         Toys-Contains-Dolls 

·         Manager-Department-Manages  

·         IsSuppliedby-Vendors-Manufacturers  

·         Manufactures-Provides-Widgets

 

 Question 6

During database design, an ER _____ and _____ are usually developed in parallel.  

·         repository, dictionary  

·         analysis, relationship   

·         diagram, glossary 

·         entity, relationship

 

 Question 7

A database designer interviews a sales team that will be using a new database. During the interview, the designer documents entities as _____ and relationships as _____.  

·         nouns, nouns  

·         verbs, nouns 

·         nouns, verbs 

·         verbs, verbs

 

 Question 8

Denormalization is a process of intentionally introducing redundancy and is achievable by _____ tables.  

·         relating    

·         merging  

·         partitioning  

·         diagraming

 

 Question 9

Which term describes the meaning of an attribute value?  

·         Type  

·         Entity 

·         QualifierType

·         Qualifier

Question 10

What is converted into 0, 1, and M specifications during database design?  

·         Unique attributes  

·         Entity instances  

·         Required attributes   

·         Business rules