DEVRY BIS 245 WEEK 3 QUIZ/ DEVRY BIS 245 WEEK 3 QUIZ - 96652

Solution Posted by
anjis_devis

anjis_devis

Rating : (20)B
Solution Detail
Price: $9.00
  • From: Business, Business
  • Posted on: Thu 09 Jun, 2016
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description
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:
Solution Description

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