+1835 731 5494 Email: instantessays65@gmail.com

DeVrY BIS 245 / BIS 245 Week 3 Quiz

$12.99

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:

Reviews

There are no reviews yet.

Be the first to review “DeVrY BIS 245 / BIS 245 Week 3 Quiz”

Your email address will not be published. Required fields are marked *