BIS 245-Quiz study guide.......(Correct Answers)

DeVry University, Chicago - BIS 245 Question 1 CO 1) Databases create business values by storing business data. providing data for decisions support systems. orrect! All of the above facilitating transaction processing. Question 2 5 / 5 pts (CO 1) In what situation would Access be a better choice than Excel? You require a flat file view of your data. Correct! You have an extensive amount of data. You need to conduct extensive statistical analyses on your data. You have a limited amount of data. Question 3 5 / 5 pts (CO 1) When creating a report in Access, what report tool best outlines the following description? This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given. Blank report tool Tabular layout report Correct! Report wizar Label tool Question 4 5 / 5 pts (CO 1) Which of the following is a question that you should ask before you create an Access report? Correct! All of the above questions should be asked. What is the purpose of the report? How will the report be distributed? Who will use the report? Question 5 5 / 5 pts (CO 1) A detail line is used to All of the above provide additional field information on a record. Correct! repeat data for each record in the record source. print more detailed information on one record only. Question 6 5 / 5 pts (CO 2) Which of the following information on database relationships is true? Image Description: There are two tables shown. Order Details and Orders. Keys and attributes are listed. The Order Details table is connected with a line that has a "Many" symbol on the left and a "1" on the left connection. Order Details has a key next to OrderID and ProductID with attributes of UnitPrice, Quantity, and Discount. The Orders Table has a a key next to OrderID with additional attributes of: CustomerID, EmployeeID, OrderDate, RequiredDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, and ShipCountry. A unique field cannot be used. Correct! For a database relationship to exist, one table must have a primary key, and the second table has a matching foreign key. A database can exist without relationships. No primary key is necessary to build a relationship. Question 7 5 / 5 pts (CO 2) A single crow's foot at the left-most end of a relationship line would indicate no relationship. a many-to-many relationship. Correct! a one-to-many relationship. a one-to-one relationship. Question 8 5 / 5 pts (CO 3) All of the following are reasons to save first name and last name as separate fields except last name could be used in a salutation. Correct! fewer fields are used. you can sort on last name then first name. first name could be used in a salutation. Question 9 5 / 5 pts (CO 3) A functional dependency is a logical primary key. a unique identifier. a composite key. Correct! a logical relationship between attributes of a table. Question 10 0 / 5 pts (CO 3) Which of the following does NOT describe a caption property? The label allows spaces between words. You Answered The caption appears in datasheet view, form, and report. A label can substitute for a field name in datasheet view. Correct Answer The label can be used in place of a field name in an expression. See Chapter 2: (Grauer) Microsoft Access 2016 Comprehensive. Question 11 5 / 5 pts (CO 4) When building a calculated field, formulas can be created using the report builder. table wizard. form wizard. Correct! expression builder. Question 12 0 / 5 pts (CO 5) Which form type displays records in a tabular format similar to a datasheet view but has more editing options, such as adding graphics? You Answered Multiple items form Datasheet form Correct Answer Subform Split form See Chapter 4: (Grauer) Microsoft Access 2016 Comprehensive. Question 13 5 / 5 pts (CO 5) Clicking on the form tool will open a(n) existing form. Correct! new form in layout view. new form in design view. wizard to design a form. Question 14 0 / 5 pts (CO 6) Which of the following describes a poor design consideration for a form? You Answered Right-align labels followed by a colon and left-align bound controls. Arrange controls closely together or in a sequence that is easy to read by the user with consistent formatting. Correct Answer Each form should have a different theme. Make labels descriptive and clear. See Chapter 4: (Grauer) Microsoft Access 2016 Comprehensive. Question 15 5 / 5 pts (CO 6) Data aggregate functions Correct! perform calculations on entire columns of data. return multiple values. cannot be used on a row. are used to perform calculations on individual records in a table or query. Question 16 5 / 5 pts (CO 9) A deletion anomaly is deleting facts about one entity successfully. Correct! deleting facts about one entity and deleting facts about another entity. deleting a table. deleting only one fact from a column. Question 17 5 / 5 pts (CO 2) A required field that is used in entering data is a field that is selected from a list of values. appears with a specific value. Correct! cannot be left blank. can be left blank. Question 18 0 / 5 pts (CO 8) The switchboard manager is an Access utility that is used by all database users. You Answered to manage and optimize the database. Correct Answer to create and manage the menu items for a switchboard. to make certain objects unavailable to some users and available to others. See Week 7 Lesson and Lab. Question 19 0 / 5 pts (CO 9) Of the following security techniques available in Microsoft Access to keep a database application safe, which choice would make the database virtually impossible to break into? You Answered Digitally signing and publishing the database Saving the database as an ACCDE file Correct Answer Encrypting and password-protecting the database Creating a menu system See Chapter 9 (Grauer): Bulletproofing the Database: Protecting Data and Analyzing Database Performance. Question 20 0 / 5 pts (CO 9) When a user creates his or her own self-signed digital signature, Correct Answer only provides users proof that the software can be trusted. only a commercial service or local server for processing will work. You Answered it will prove that the creator does not own the database. it is created through anyone. See Chapter 9: (Grauer) Microsoft Access 2016 Comprehensive. Question 21 0 / 5 pts (CO 10) After creating an ACCDE file, you You Answered can convert it back to its source format. Correct Answer will need to go back to the original file if an underlying object requires a change. will be able to modify forms and reports but not tables. will see a "file already in use" message that continues to display to all other users. See Chapter 2: (Grauer) Microsoft Access 2016 Comprehensive. Question 22 5 / 5 pts (CO 4) Which database property type helps keep data consistent when doing data entry? Validation text Expression Correct! Validation rule Indexed Question 23 30 / 40 pts (CO 1) Describe the client/server architecture. Explain the client role. Explain the server role. Give an example. Your Answer: Client-server architecture (client/server) is a network architecture in which each computer or process on the network is either a client or a server. Servers are powerful computers or processes dedicated to managing disk drives (file servers), printers (print servers), or network traffic (network servers). Clients are PCs or workstations on which users run applications. Clients rely on servers for resources, such as files, devise, and even processing power. Client/server architecture distributes computer workloads between service requesters (clients) and service providers (servers). An example could be found in a bank. Bank tellers would not be expected to have every account on their terminal at the branch because this information would have to be stored on each machine, and the information would become out-of-date very quickly. Thus, bank tellers use a client computer to make a balance request to a server, which stores customer information. Client/server architecture distributes computer workloads between service requesters (clients) and service providers (servers). An example could be found in a bank. Bank tellers would not be expected to have every account on their terminal at the branch because this information would have to be stored on each machine, and the information would become out-of-date very quickly. Thus, bank tellers use a client computer to make a balance request to a server, which stores customer information. Question 24 15 / 40 pts (CO 2) What does it mean to store data in its smallest parts, and why is this important? Your Answer: Data storage is the collective methods and technologies that capture and retain digital information on electromagnetic, optical or silicon-based storage media. Storage is a key component of digital devices, as consumers and businesses have come to rely on it to preserve information ranging from personal photos to business-critical information. Storage is frequently used to describe the devices and data connected to the computer through input/output (I/O) operations, including hard disks, flash devices, tape systems and other media types. Storing data in its smallest parts means that we have to break up the data into its components. For example, if we want to store the name of a customer, we would not want to store the whole name as a single field. Instead we would want to break this up in to fields for both first name and last name. This is important as it provides more flexibility for retrieving and sorting records. Storage in this case doesn't matter, you will still have the same amount of data. Storing data in its smallest parts means that we have to break up the data into its components. For example, if we want to store the name of a customer, we would not want to store the whole name as a single field. Instead we would want to break this up in to fields for both first name and last name. This is important as it provides more flexibility for retrieving and sorting records. Question 25 40 / 40 pts (CO 4) Conceptual design begins with a big-picture view and details gradually added before the implementation process begins. With this in mind, what is the first step in the conceptual design process for ERD construction? In your own words, describe how you would accomplish this first step. Your Answer: The purpose of the conceptual design phase is to build a conceptual model based upon the previously identified requirements, but closer to the final physical model. A commonly-used conceptual model is called an entity-relationshipmodel.The E-R diagram consists of Entities, Attributes and Relationships. The first step is to create a separate relationship table for each entity. This is a logical starting point when mapping an E-R diagram into a relational database model. It is generally useful first to specify the database schema before proceeding to expansion of the relations to account for specific tuples. Step 1: Represent Entities as Tables Entities are person, places, or things that you will collect and store information about. To identify entities, ask yourself two questions. Is there more than one? Is there a variation over time? Entities will be represented as a box with a unique name. See Frost Textbook, Chapter 3. Question 26 40 / 40 pts (CO 4) Describe what the term data redundancy means in database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of a normalized database. Your Answer: Data redundancy is a condition created within a database or data storage technology in which the same piece of data is held in two separate places. This can mean two different fields within a single database, or two different spots in multiple software environments or platforms. Whenever data is repeated, this basically constitutes data redundancy. This can occur by accident, but is also done deliberately for backup and recovery purposes. Some of the pros to data normalization are updates run quickly due to no data being duplicated in multiple locations. And, Inserts run quickly since there is only a single insertion point for a piece of data and no duplication is required. Some cons are since data is not duplicated, table joins are required. This makes quires more complicated, and thus read times are slower. And, since joins are required, indexing does not work as efficiently. Again, this makes read times slower because the joins don’t typically work well with indexing. In database design, a normalized database helps remove redundant data. This saves storage space and, more importantly, various data anomalies, such as an insert problem, delete problem, and so forth. However, normalizing a database can create problems. The data retrieval becomes complex and time-consuming. For this reason, a little bit of data redundancy is often desirable and allowable. It makes the data reporting easier. Generally, OLTP (transaction database) has a normalized design and the reporting database, such as a data warehouse, has a highly denormalized design. Quiz Score: 200 out of 270 Previous