BIS245 245 Database Essent for Busn wLab FINAL EXAM. 100% CORRECT

Document Content and Description Below

(CO 1) MS Visio is used during database design for the following reasons. It calculates formulas. It depicts entities and relationships between entities. It sets reports. I... t can query information. (CO 1) In a table, the view is where you add, edit, and delete records. SQL layout datasheet design (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 Label tool Report wizard (CO 1) All of the following filters work except filter by form with a comparison operator. filter by selection with an equal condition. Correct Answer filter by selection with an edit operator. filter by selection with a comparison operator. See Chapter 2: (Grauer) Microsoft Access 2016 Comprehensive. (CO 1) A detail line is used to All of the above print more detailed information on one record only. provide additional field information on a record. Correct Answer repeat data for each record in the record source. See Chapter 4: (Grauer) Microsoft Access 2016 Comprehensive. (CO 2) A field that uniquely identifies each record in a table is a relationship. link. foreign key. (CO 2) SQL is a fourth-generation language that is procedural and record oriented. flat-file oriented and nonprocedural. table oriented and nonprocedural. oriented toward static data. (CO 3) Which of the following should be considered when designing a database? Store data in its smallest parts How calculated fields are used The relationships between records (CO 3) All of the following applies to data redundancy except output could be incorrect if the first and second locations of the same data are not updated. it requires updating in two locations. data is always linked in two tables. the same data exists in two tables. An example of a setting is yes (no duplicates). Indexing a table speeds the retrieval time. Setting the index requires each record to be scanned sequentially and saves time searching data. Primary keys must be indexed. (CO 4) When building a calculated field, formulas can be created using the report builder. table wizard. form wizard. expression builder. (CO 5) To edit a form, use datasheet view. Correct Answer design view. layout view. wizard view. See Chapter 4: (Grauer) Microsoft Access 2016 Comprehensive. (CO 5) The following are form creation tools except form layout. form wizard. form design. blank form. (CO 6) Which of the following statements is NOT correct about a query? Instructions on which data to display are saved within a query. Correct Answer Changing data values in a query will not change data values in a table. Instructions on the format to display data are saved within a query. Data is not saved within a query. See Chapter 3: (Grauer) Microsoft Access 2016 Comprehensive. (CO 6) Using the rules for order of operations, what is the result of the following expression: (4 * 3) +1 + 4 - 2 * 3 + 5? 50 16 18 11 (CO 9) All of the following are drawbacks to normalization, except input/output resources. CPU usage. Correct Answer less tables and larger columns. memory usage. See Chapter 3: Kroenke & Auer Text. (CO 2) A required field that is used in entering data is a field that appears with a specific value. is selected from a list of values. cannot be left blank. (CO 8) All of the following describe how a Navigation Form is used except Correct Answer is another term for a specific report. click the create tab and then navigation in the forms group to create a navigation form. helps users open forms and reports. has the look and feel of a web form. See Week 7 Lab and Lesson. (CO 9) A good password should have symbols. part of your account name. a combination of five letters. a word or name that is easy to remember by the user, such as the name of their children. (CO 9) All of the following describe a digital signature certification authority except a certification authority is a commercial company that is highly regulated in most countries. certification authority companies establish their own rules and regulations that users must follow. a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database. a fee is charged for the service of issuing and validating identities using a digital signature. (CO 10) ACCDE files give users permission to create and change forms and reports within a database. deny users permission to create forms and reports but will allow them to modify forms and reports. Correct Answer deny users permission to change data but not modify a database. See Chapter 2: (Grauer) Microsoft Access 2016 Comprehensive. (CO 4) Which database property type helps keep data consistent when doing data entry? Validation rule Expression Indexed Validation text (CO 1) Designing a database often involves obtaining different perspectives from various sources to gather information. Discuss the importance of end-user interviews in the data requirements gathering process. Your Answer: A data model is a description of how data should be used to meet the requirements given by the end user . Data modeling helps to understand the information requirements. Data modeling differs according to the type of the business, because the business processes or each sector is different, and it needs to be identified in the modeling stage. Initial step is the analyzing the situation, gather data. Data modeling process starts with requirement gatherings. When developing the proper data model it is important to communicate with the stakeholders about the requirements. Data modeling is the act of exploring data oriented structures. This can be used for variety of purposes. One of the important functions of data modeling is that, it helps to understand the information requirements. Especially this makes both developers and end users lives easier. As mentioned above, data modeling helps the end users to define their requirements, and the developers are able to develop a system to meet those specified requirements. Interviews can be an important part of the data requirements gathering process. Database designers, business analysts, or systems analysts will often work with users to help them articulate the nature of the data they want to capture, as well as the forms and reports the users need from the database. These interviews may also suggest entities and columns that belong in the database design. See the Week 1 Supplemental Reading: Database Design Fundamentals and Data Requirements Gathering. (CO 2) Explain the terms entity, relationship, and attributes. Describe how they are used in a database. Your Answer: An entity is an object in the real world with an independent existence that can be differentiated from other objects. An entity might be An object with physical existence (e.g., a lecturer, a student, a car) An object with conceptual existence (e.g., a course, a job, a position) Attributes: Each entity is described by a set of attributes (e.g., Employee = (Name, Address, Birthdate (Age), Salary). Each attribute has a name, and is associated with an entity and a domain of legal values. However, the information about attribute domain is not presented on the ERD. Relationships are the glue that holds the tables together. They are used to connect related information between tables. Relationship strength is based on how the primary key of a related entity is defined. A weak, or non-identifying, relationship exists if the primary key of the related entity does not contain a primary key component of the parent entity. Company database examples include: Customer(CustID, CustName) Order(OrderID, CustID, Date) A strong, or identifying, relationship exists when the primary key of the related entity contains the primary key component of the parent entity An entity is a person, place, or thing that is being modeled for a database system. An example would be customers, employees, and work locations. A relationship is an association between records from two or more tables. These relationships can be categorized as one-to-one, one-to-many, or many-to-many. An attribute is an adjective that describes an entity or relationship, such as height, weight, age, phone number, or hire date. (CO 4) What are the advantages and disadvantages of the denormalization process? Your Answer: Pros and cons of denormalized database design. Denormalized databases fair well under heavy read-load and when the application is read intensive. This is because of the following reasons: The data is present in the same table so there is no need for any joins, hence the selects are very fast. A single table with all the required data allows much more efficient index usage. If the columns are indexed properly, then results can be filtered and sorted by utilizing the same index. While in the case of a normalized table, since the data would be spread out in different tables, this would not be possible. Although for reasons mentioned above selects can be very fast on denormalized tables, but because the data is duplicated, the updates and inserts become complex and costly. Having said that neither one of the approach can be entirely neglected, because a real world application is going to have both read-loads and write-loads. Hence the correct way would be to utilize both the normalized and denormalized approaches depending on situations. Students answers may vary, but in general the answer should cover the following. Advantages: performance is improved as queries can access data within tables without using high resource cost joins. Less complexity as larger groups of fields are grouped within a table and there are fewer tables, and relational joins overall to manage. Disadvantages: More maintenance overhead, as there are more redundant records to maintain within a table. Update, insert, and delete queries take a performance hit due to high data volume from redundancy. Redundancy increases storage size causing waste. Lack of referential integrity leads to dirty data. (CO 4) Explain 1NF, 2NF, and 3NF as related to database design. Your Answer: First Normal Form :1NF:Definition: A table in which all fields contain a single value.The entity contains single values only and each record can be identified by a Primary Key. Second Normal Form:2NF:Definition: A table in which each non-key field is determined by the whole primary key and not part of the primary key by itself. Foreign Keys are used to build relationships that remove repeating subset of data. Third Normal Form: 3NF:Definition: A table in which none of the non-key fields determine another non-key field. All attributes that are not dependent upon the primary key are removed. 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. Quiz Score: 75 out of 270 Previous Submission Details: [Show More]

Last updated: 1 year ago

Preview 1 out of 15 pages