BIS 245 Week 3 Quiz Answers 

Question 1

 

(CO 2) Which of the following is an example of an entity in a business?

   

Company

   

Business owner 

CEO 

Employees

Question 2

 

(CO 2) Physical design refers to

   

developing a database model that will support company operations. 

purchasing your hardware components.

  

selecting the specific hardware characteristics based on data storage and data access requirements.

  

the process of converting your ERD into tables and defining your rows and columns based your entities and attributes. 

 

Question 3

 

(CO 3) All of the following explain index usage except

   

a primary field uses an index.

   

adding an index to a table might decrease overall database performance slightly.

  

an index can reduce the amount of time it takes for Access to run queries and reports.  

indexes are created using the index property type.

Question 4

 

(CO 2) A domain is a

  

group of data types that describe what kind of information that may be stored in a field.

   

model of the database.

   

set of values.

   

the set of primary and foreign keys in a database

 

Question 5

 

(CO 2) All of the following describe a many-to-many relationship in Access except

   

a junction (associative) table is used.

 

many matching records are found in each direction between tables.

   

may be used to connect to Oracle and other databases.

   

there must be at least two tables.

 

Question 6

 

(CO 2) A foreign key is NOT

   

the primary key of another table.

   

data uploaded from an external source. 

   

a field in a table.

   

a unique identifier in a related table.

 

Question 7

 

(TCO 3) Referential integrity constraints are

 

a set of rules the database uses.

   

data errors after they are entered into a table.

   

a primary key in a table.

   

ways to type data accurately into a table.

 

Question 8

 

(CO 4) Which statement below is NOT true of one-to-many relationships?

  

It is the least-used type of relationship.

  

The table with the primary key must only have one occurrence of each value for the primary key.

  

The foreign key in the related table may have repeating values for the foreign key.

   

An example is that one employee may take multiple orders.

Question 9

 

(CO 4) Which is NOT true of validation rules?

   

They enforce a size limit.

  

They check authenticity of data entered in a field.

    

An error message will appear if a rule is violated.

   

They protect from fraudulent practices. 

 

Question 10

 

(CO 4) Which statement is true when referential integrity is enforced?

   

It is an automatic option in every table design.

   

Access checks the accuracy of spelling in the tables.

  

It ensures data can be entered into a related table, even if it does not exist in the primary table.

 

A record will not be added to the table if an ID that is referenced does not exist.

 

SmartExpert

(118)

Status NEW Posted 02 Mar 2019 05:03 PM My Price 5.00

BIS----------- 24-----------5 W-----------eek----------- 3 -----------Qui-----------z A-----------nsw-----------ers-----------

Attachments

file 1551547856-BIS 245 Week 3 Quiz Answers.docx preview (464 words )

B-----------IS -----------245----------- We-----------ek -----------3 Q-----------uiz----------- An-----------swe-----------rsÂ-----------  -----------Que-----------sti-----------on -----------1 -----------4 -----------/ 4----------- p-----------ts ----------- (C-----------O 2-----------) W-----------hic-----------h o-----------f t-----------he -----------fol-----------low-----------ing----------- is----------- an----------- ex-----------amp-----------le -----------of -----------an -----------ent-----------ity----------- in----------- a -----------bus-----------ine-----------ss?----------- Â----------- Â ----------- C-----------omp-----------any----------- Â-----------  ----------- Â-----------  -----------Bus-----------ine-----------ss -----------own-----------er -----------  ----------- Â----------- Â ----------- C-----------EO -----------  ----------- C-----------orr-----------ect-----------! ----------- Â-----------  -----------Emp-----------loy-----------ees----------- Â-----------  -----------  ----------- Qu-----------est-----------ion----------- 2 ----------- 4Â----------- / -----------4 -----------pts----------- (-----------CO -----------2) -----------Phy-----------sic-----------al -----------des-----------ign----------- re-----------fer-----------s t-----------o ----------- Â-----------  -----------dev-----------elo-----------pin-----------g a----------- da-----------tab-----------ase----------- mo-----------del----------- th-----------at -----------wil-----------l s-----------upp-----------ort----------- co-----------mpa-----------ny -----------ope-----------rat-----------ion-----------s. -----------  ----------- Â----------- Â ----------- p-----------urc-----------has-----------ing----------- yo-----------ur -----------har-----------dwa-----------re -----------com-----------pon-----------ent-----------s. -----------  ----------- C-----------orr-----------ect-----------! -----------  ----------- se-----------lec-----------tin-----------g t-----------he

Not Rated(0)

• Buy Answer