DEVRY BIS245 WEEK 3 QUIZ 2015 GRADED 100 % CORRECT

(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:

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.