BIS 245 Database Essent for Busn w/Lab FINAL EXAM (GRADED A) Question and Answer elaborations | 100% Guaranteed Pass.

Document Content and Description Below

1. Question : (TCO 1) Which object would you use to enter, delete, or modify data? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Ac... cess 2010 Comprehensive 2. Question : (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Access 2010 Comprehensive 3. Question : (TCO 1) To design a report you should do all of the following EXCEPT Student Answer: draw a paper design of the report. identify all sources of data, fields and groups. input the data. Instructor Explanation: select a reporting tool. Chapter 1: Microsoft Access 2010 Comprehensive 4. Question : (TCO 1) Which of the following is NOT a Report Section? Student Answer: Detail Group Footer Page Footer Instructor Explanation: Summary Chapter 4: Microsoft Access 2010 Comprehensive 5. Question : (TCO 1) A Detail line is used to Student Answer: print more detailed information on one record only. provide additional field information on a record. repeat data for each record in the record source. Instructor Explanation: All of the above Chapter 4: Microsoft Access 2010 Comprehensive 6. Question : (TCO 2) For the following image, which of the following is TRUE? Student Answer: The OrderID field will be unique within both the Orders and Order Details tables. Within the Orders table, the OrderID field will contain more than one of the same value. Within the Order Details table, the OrderID field will contain more than one of the same value. Within the Orders Details table, the ProductID field will contain unique values only. Instructor Explanation: Chapter 2: Frost Textbook 7. Question : (TCO 2) A symbol used in ER diagrams for an entity is a Student Answer: box. diamond. line. Instructor Explanation: triangle. Chapter 2: Frost Textbook 8. Question : (TCO 3) A property that provides a "user friendly" name to a column in Datasheet View is a Student Answer: caption. default value. input mask. Instructor Explanation: rule. Chapter 2: Microsoft Access 2010 Comprehensive 9. Question : (TCO 3) Summarized data in an easy-to-read view is known as a Student Answer: design. PivotTable. report. Instructor Explanation: table. Chapter 2: Microsoft Access 2010 Comprehensive 10. Question : (TCO 3) Which of the following is NOT true of a property? Student Answer: A property is an object's characteristic or attribute. Tables, forms, queries, and reports have a set of properties. A property sheet is used to make changes. Design properties are displayed in Datasheet View. Instructor Explanation: Chapter 2: Microsoft Access 2010 Comprehensive 11. Question : (TCO 4) Which of the following does NOT describe the fo one relationship? Student Answer: key. The tables must have exactly the same fields. The Employees and NewEmployees tables use the More tables can be joined to either table. It may be used for security reasons to protect data a Instructor Explanation: Chapter 2: Microsoft Access 2010 Comprehensive 1. Question : (TCO 5) Which form type displays records in a tabular for Datasheet view but has more editing options such as add Student Answer: Datasheet Form Multiple Items Form Split Form Instructor Explanation: Subform Chapter 6: Microsoft Access 2010 Comprehensive 2. Question : (TCO 5) A calculated control Student Answer: contains a formula that displays the result. is a bound box. is a text box containing a description. is an unbound box that the user will fill in with a numeric value. Instructor Explanation: Chapter 6: Microsoft Access 2010 Comprehensive 3. Question : (TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties? Student Answer: Function Identifier Operator Instructor Explanation: Value Chapter 3: Microsoft Access 2010 Comprehensive 4. Question : (TCO 6) Data aggregates Student Answer: are used to perform calculations on individual records in a table or query. cannot be used in a report. perform calculations on entire columns of data. Instructor Explanation: return multiple values. Chapter 3: Microsoft Access 2010 Comprehensive 5. Question : (TCO 7) When making vertical data comparisons, you should use the following chart. Student Answer: Bar Column Pie Instructor Explanation: Scatter Plot Chapter 5: Microsoft Access 2010 Comprehensive 6. Question : (TCO 7) Discrete data Student Answer: are easily scaled. are used to measure time or money. cannot be subdivided into meaningful information. may be subdivided into smaller and smaller units. Instructor Explanation: Chapter 5: Microsoft Access 2010 Comprehensive 7. Question : (TCO 8) A switchboard is a Student Answer: form that looks like a menu or a series of menus that ties objects in a database. design tool to analyze and optimize a database. report that looks like a menu or a series of menus that ties objects in a database. Instructor Explanation: screen that is used to hide objects from users. Chapter 9: Microsoft Access 2010 Comprehensive 8. Question : (TCO 9) To secure an Access database, all of the following should be done EXCEPT Student Answer: digitally sign a database and open it in a trusted location. require a password to open a database. run the Table Analyzing Wizard and Performance Analyzer. Instructor Explanation: save a database with the .accde file extension. Chapter 9: Microsoft Access 2010 Comprehensive 9. Question : (TCO 9) All of the following describe a certification authority EXCEPT Student Answer: a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database. a certification authority is a commercial company that is highly regulated in most countries. a fee is charged for the service of issuing and validating identities using a digital signature. certification authority companies establish their own rules and regulations that users must follow. Instructor Explanation: Chapter 9: Microsoft Access 2010 Comprehensive 10. Question : (TCO 10) Which of the following file format types removes all VBA code from the database and prohibits users from making changes to forms and reports? Student Answer: ACCDB ACCDC ACCDE Instructor Explanation: ACCDT Chapter 9: Microsoft Access 2010 Comprehensive 11. Question : (TCO 4) The term "cascading" refers to Student Answer: data changes travel from one table to another. data is put in sequential order. queries can retrieve data at a faster rate. records are arranged in order. Instructor Explanation: Chapter 2: Microsoft Access 2010 Comprehensive 1. Question : (TCO 1) Describe three-tier architecture. Explain the fun performed by each tier. Student Answer: Three­tier architecture refers to the configuration involving a client, server, and a data server. The client, which can also be thought of application, sends requests to and receives responses from the app The application server, which can be thought of as the middle­man receives responses from and sends responses to the client and als requests to and receives data back from the data server. The data be thought of as a somewhat more passive storage facility, receive from and sends data back to the application server. All three compo ideally work together to create a seamless process for the end user Instructor Explanation: A computing architecture consists of the following: 1. Client computers capture user input, send requests for inf present the results of the request. 2. Application servers enable business logic. 3. Data servers store data which provide data to the applicat 2. Question : (TCO 2) Explain business logic and describe how it relates to a relational database. Student Answer: Business logic refers to the set of rules and guidelines that govern a company's policies and procedures. For example, business logic would dictate under what circumstances a company would not accept a customer order, what processes should be followed to fill customer orders, and those types of things. A relational database can be an integral part of a company's business logic system, because it keeps information very organized and helps the company see clearly how various components relate to one another. For example, a company can keep its lists of customers, products, and orders in a relational database, and this makes it very easy to not only enter new order information but also keep track of inventory levels, sales figures, and similar things in order to better follow its ideal business logic. Instructor Explanation: The set of rules that govern an organization's processes is known as business logic. For example, an organization might require that an employee identification number be assigned to every employee before a payroll check could be issued. Without this number, the relational database would reject the transaction. 3. Question : (TCO 4) From first normal form, second normal form, or third normal form, select one of these forms and explain (1) how that normal form is often violated by inexperienced database designers and (2) how to correct such a violation of that normal form. Student Answer: First normal form refers to a table where each field contains only a single value. This can be violated by inexperienced database designers by creating records where one or more fields contain multiple values. For example, a table containing information about customer personal information may contain a field for their phone number. If the same Instructor Explanation: customer has more than one phone number and both are entered, this would create a violation of the first normal form. This type of violation can be corrected by removing the field in question from the table and creating a new table with a different primary key where all values can be included in separate records. In our example, we would create a second table with the phone number as the primary key so that we could enter multiple numbers for the same customer. An alternate solution in this case might be to create multiple fields in the original table to allow for such situations, such as one field for a home phone number and a separate field for a cell phone number. Student answers will vary. However, a good student answer might be similar to the following sample answer. The student might describe that the first normal form is violated when an OrderTable has repeating columns such as Product 1, Product 2, Product 3, and so forth. To fix this problem, students should indicate a new Products table could be created and joined to a junction/association table in a many-to-many relationship between OrderTable and ProductTable. 4. Question : (TCO 4) Explain 1NF, 2NF, and 3NF as related to database design. Student Answer: 1NF stands for first normal form, which refers to a table in which all fields contain only single values. For example, a field cannot contain two different phone numbers, addresses, etc. 2NF stands for second normal form, which refers to a table in which every non­key field is determined by the entire primary key, not just part of it. Problems with this form can occur when more than one field is used as a primary key but the parts of the primary key determine different fields in the table. 3NF stands for third normal form, which refers to a table in which no non­key field determines another non­key field. If this were not the case, then the determining field should probably be the key field in a separate table. Taken together, these three normal forms represent standards that should be adhered to for good database design. They help maintain data integrity and prevent issues that would cause confusion or other potential problems. Instructor Explanation: 1NF: The entity contains single values only and each record can be identified by a primary key. 2NF: Foreign keys are used to build relationships that remove repeating subsets of data. 3NF: All attributes that are not dependent upon the primary key are removed. [Show More]

Last updated: 1 year ago

Preview 1 out of 26 pages