DeVrY BIS 245 / BIS 245 Week 3 Quiz

Question

Question 1. Question (TCO 2) In a relational database, entities are

events.

persons.

things.

All of the above

Instructor Explanation: Chapter 3: Frost section of book

Points Received: 4 of 4

Comments:

Question 2. Question : (TCO 2) Logical design refers to

developing a database model that will support company operations.

developing a thorough understanding of what needs to be done in developing a database.

translating the conceptual design into the selected model for use in a database system.

understanding the business and its functional areas or business processes.

Instructor Explanation: Week 3 Lecture

Points Received: 4 of 4

Comments:

Question 3. Question : (TCO 3) Database design refers to

developing a database model that will support company operations.

focusing on understanding the business and its functional areas or business processes.

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.

Instructor Explanation: Week 3 Lecture

Points Received: 4 of 4

Comments:

Question 4. Question : (TCO 2) A crow's foot

$ is a Boolean field.

is used to describe attributes.

points to the child table.

points to the parent table.

Instructor Explanation: Chapter 3: Frost section of book

Points Received: 0 of 4

Comments:

Question 5. Question : (TCO 2) A one-to-many relationship is

a relationship that guarantees that a record is unique.

an association between a record and its fields.

used to describe attributes.

when a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.

Instructor Explanation: Chapter 3: Frost section of book

Points Received: 4 of 4

Comments:

Question 6. Question : (TCO 2) An associative table is

used to identify primary keys between tables.

a child of two parent tables that are in a many-to-many relationship.

an integrity element within a table relationship.

a tool that allows you to locate an excel file.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 7. Question : (TCO 3) Data validation refers to

a set of constraints that helps control illegal data entry.

correcting data errors after they are entered into a table.

duplicating a primary key in a table.

typing data accurately into a table.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 8. Question : (TCO 4) What Access data type would you use to store $23.58?

Calculated

Currency

Money

Number

Instructor Explanation: Chapter 1: Grauer section of book

Points Received: 4 of 4

Comments:

Question 9. Question : (TCO 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.

Instructor Explanation: Chapter 2: Grauer section of book

Points Received: 4 of 4

Comments:

Question 10. Question : (TCO 4) Which question is part of a requirements analysis?

What is the organization's structure and core business?

What are the existing problems with the current database?

Will the database interface with other systems?

All of the above.

Instructor Explanation: Week 3 Lecture

Points Received: 4 of 4

Comments:

 

 

Show more >

Answer:

  • *********
    ********
    * ******** **** ** ** * ********** ******** entities are *******
    persons
    *******
    ***
    of
    ***
    ******
    **********
    Explanation: Chapter ** *****
    section
    ** book ****** Received: 4 ** 4 **********
    ********
    * ******** * **** **
    *******
    ******
    ******
    *** developing a ******** ***** **** **** support ******* operations
    **********
    a thorough ************* ** what ***** ** ** done
    in
    developing * database *********** *** ********** ****** into the ******** ***** for *** **
    ...
    Attached: DeVrY BIS 245 Week 3 Quiz.docx

Learn more effectively and get better grades!

Do my homework