which organizational function should set database standards?

A modern database management system automates more of the backup and recovery tasks than a file system. California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. A) Unstructured and unpredictable use of data This set of standards should include. D) more than 7 billion exabytes of data. They can be stored as a printed document, in an online format for easy access, or in both ways. An X in the matrix indicates involvement in the process, whereas a P indicates primary responsibility. C) The desire to require programmers to write all file handling functionality. Here's an example of how an organizational chart looks: CREATE THIS ORGANIZATIONAL CHART TEMPLATE The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems. B) mainframe. Difficulty: Moderate The data administration standards should include the following items: The DBA standards serve as a guide to specific approaches to supporting the database environment. collectively called a(n): Failure to implement database standards and procedures will result in a database environment that is confusing and difficult to manage. A constraint is a rule in a database system that can be violated by users. Which organizational function should set database standards? D) All of the above, Chapter 1 - Large-scale organisations in cont. A data warehouse contains summarized and historical information. This keeps the manager informed and enables the DBA to dodge the dozens of phone calls that come in from angry users, the help desk, and so on. CASE is a class of tools that: Sufficient operational support must be available to administer a database environment effectively. For example, if ORG is the standard abbreviation for organization, do not allow variants such as ORGZ to be used. A) server. C) icon. Metadata are data that describe the properties of other data. A) client. C) analysis A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): Databases may be more expensive to maintain than files because of: Use the formula in the said example to make the following degree conversions. Classification: Concept Difficulty: Easy LO: 1: Name several limitations of conventional file processing systems. Classification: Concept, The period that can be considered a "proof of concept" time was the: B) Cost of conversion D) a procedure stored on the server. C) 1980s. Although database naming standards are important, you will need to develop and maintain other types of database standards. Logically 4. D) user snapshot Organizational commitment to a database project is not necessary for its success. You should document the special development considerations required when writing programs that access databases. Classification: Concept It is especially important to avoid this approach for user-visible database objects such as columns, tables, and views. A) logically Difficulty: Moderate : an American History (Eric Foner), Chemistry: The Central Science (Theodore E. Brown; H. Eugene H LeMay; Bruce E. Bursten; Catherine Murphy; Patrick Woodward), Psychology (David G. Myers; C. Nathan DeWall), Biological Science (Freeman Scott; Quillin Kim; Allison Lizabeth), Forecasting, Time Series, and Regression (Richard T. O'Connell; Anne B. Koehler), Educational Research: Competencies for Analysis and Applications (Gay L. R.; Mills Geoffrey E.; Airasian Peter W.), Business Law, Ethics and Social Responsibility (BUS 5115), Elements of Intercultural Communication (COM-263), Fundamentals General, Organic, Biological Chemistry I (CHE 121), Child and Adolescent Psychology (PSY-355), Biological Principles II and Lab (BIOL 107/L), Complex Concepts Of Adult Health (RNSG 1443), Professional Application in Service Learning I (LDR-461), Advanced Anatomy & Physiology for Health Professions (NUR 4904), Principles Of Environmental Science (ENV 100), Operating Systems 2 (proctored course) (CS 3307), Comparative Programming Languages (CS 4402), Business Core Capstone: An Integrated Application (D083), Ch. Because applications are often developed independently in file processing systems: unplanned duplicate data files are the rule rather than the exception. C) analysis Classification: Concept A) Specialized personnel Which of the following types of data can be stored in a database? Difficulty: Moderate A) Database analysts C) Lines The matrix can be created at a departmental level, a job description level, or even by individual name. Answer: D A) collecting data. D) Legacy systems. In most cases, for objects not accessed by typical end users, provide a way to differentiate types of database objects. The physical database server and/or the virtual database server . LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Classification: Concept Keeping the names consistent across environments allows the error messages to be consistent. Diff: Moderate Page Ref: 24 Topic: Advantages of the Database ApproachSubtopic: Enforcement of Standards 29. Answer: B A) 1 terabyte of data. For instance, most DBMSs externalize constraint names when the constraint is violated. While . D) implementation D) all of the above. A) creating data. Which of the following is software used to create, maintain, and provide controlled access to databases? Whenever possible, operational support personnel should be trained to resolve simple database-related problems without involving the DBA because the DBA is a more expensive resource. All of the following are properties of metadata EXCEPT: processing logic. D) file updating. A basic set of database administration standards should be established to ensure the ongoing success of the DBA function. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. D) implementation. A) 40 percent AACSB: Information Technology, The traditional methodology used to develop, maintain, and replace information systems is A data warehouse derives its data from: Answer: B Difficulty: Moderate C) Unified Model. B) 1960s. D) file updating. A) 1960s. AACSB: Information Technology, Because applications are often developed independently in file processing systems: 20) Which organizational function should set database standards? Front-Office Functions A) what a user sees when he or she looks out the window. In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. D) all of the above. Answer: D 18) Which organizational function should set database standards? A) client. ISO 9001:2015 Quality management systems The ISO 9000 family is the world's most best-known quality management standard for companies and organizations of any size. LO: 1: Describe the life cycle of a systems development project, with an emphasis on the A) lack of planning. Unstructured and unpredictable use of data. Answer: C C) analysis An equation involving variables should be marked true only if it is an identity. Spend time considering how you define types having standard database types for fields or bespoke types are a good thing to sort out upfront. C) on demand paging. C) relation Modern Database Management, 13e (Hoffer) Visual programming tools such as Visual Basic have made prototyping more difficult. User view 3. For example, many organizations have shop conventions for naming files, but coordinating the database object to the operating system file may require a specific format for database filenames that does not conform to the shop standards (see Figure 2.7). According to SFIA 8, database administration involves the installing, configuring, monitoring, maintaining, and improving the performance of databases and data stores. B) design C) remote PC. D) automates the design of databases and application programs. The term legacy system refers to a newly installed database management system. A) logically Difficulty: Moderate AACSB: Information Technology, Which of the following is NOT a cost and/or risk of the database approach? The period that can be considered a "proof of concept" time was the: LO: 1: Explain the roles of individuals who design, implement, use, and administer C) repository. There is no practical reason to impose a limitation on the length of database table names. B) relationship LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. A) design B) relationship. System administration standards are needed for many of the same reasons that DBA standards are required. C) analysis ISO 9001:2015, the international standard specifying requirements for quality management systems, is the most prominent approach to quality management systems. Chapter 6, Design Reviews, offers a comprehensive discussion. A) ODBC B) Structured query language C) ASP D) Data manipulation query language C) departmental data modeling A) Enterprise Resource Model. Using standard abbreviations will minimize mistyping and make it easier for users to remember database object names. Answer: C A) controlled B) legacy C) database D) mainframe B 3) A database is an organized collection of ________ related data. C) prototyping. As discussed earlier, the minimum number of environments for supporting database applications is two: test and production. Classification: Concept B) schema on write. A) Network operating system D) caching. B) 1960s. B) Logical D) Ties, ) Relational databases establish the relationships between entities by means of common fields included in a file called a(n) ________. B) hypertext graphic. A database is an organized collection of ________ related data. Participation is optional. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. A) entity. Regardless of whether they are purchased, written in house, or adopted from a user group or committee, each of the following areas should be covered. Personal databases are designed to support a small group of individuals working together on a project. D) Dissecting B) Predictable use of data LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file B) cross-functional analysis 1) Define the organizational strategy and ground it in how functions deliver value at the enterprise and business-unit levels. Chapter 1 The Database Environment and Development Process, According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored C) 60 percent A) The need to provide greater independence between programs and data. In a file processing environment, descriptions for data and the logic for accessing the data is built into: C) 60 percent B) order processing. processing. D) entity. B) data warehouse. B) the size of the CPU used. LO: 1: Explain the roles of individuals who design, implement, use, and administer The need for consensus on data definitions is an example of which type of risk in the database environment? D) Reduced program maintenance. Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Answer: B AACSB: Information Technology, Relational databases establish the relationships between entities by means of common fields The most notable benefits of data governance include providing improved data quality, lower data management costs, increased access to needed data across the organization, lower risks of errors being introduced, and ensuring that clear rules regarding access to data are both set, enforced, and adhered to. D) database management system. AACSB: Information Technology, Which organizational function should set database standards? A) the data is always non-redundant. Organizational readiness refers to the organization's financial and technological capacities that affect the implementation and use of the technology (Iacovou et al., 1995).Implementing blockchain technology requires investing in various kinds of software and hardware and using sophisticated information systems for A security procedure is a set . Multitier client/server database applications contain a business logic layer. A database is an organized collection of ________ related data. Answer: B Database development begins with the design of the database. C) Programmers Which of the following is NOT an advantage of database systems? Without standard database object naming conventions, it will be difficult to identify database objects correctly and to perform the proper administration tasks. Answer: C Check whether the equation is true or false and explain your answer. Design reviews can take many forms. D) a datamart. Databases were developed as the first application of computers to data processing. D) implementation EXCEPT: A) CASE. Which of the following will interfere with access to operational databases? When business rules are made right, they provide efficiency, consistency, predictability, and benefits. processing. Which organizational function should set database standards? Although personal databases improve productivity, one risk is that data cannot be shared with other users. Operational support assures that applications are run according to schedule. C) Technical services Organizations that exist in loosely defined or ambiguous environments need to distribute decision-making authority to employees, and thus will often feature a flat organizational structure. For example, what data volume is required for each environment and how is data integrity to be assured when testing activity occurs? D) association. B) cross-functional analysis before or at the time of use of the data is called: AACSB: Information Technology, A(n) ________ is often developed by identifying a form or report that a user needs on a B) the complexity of the database environment. Difficulty: Easy D) a data mart. They are often used to help prepare system flows or procedural flow charts that outline how a business will operate. ________________is often developed by identifying a form or report that a user needs on a regular basis. A) ManagementB) Application development C) Technical servicesD) None of the aboveAnswer: D 3) The most common source of database failures in organizations is: A) lack of planning.B) inadequate budget. ________ are established between entities in a well-structured database so that the desired information can be retrieved. Difficulty: Easy Classification: Concept This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Answer: D B) order processing. B) excellent; mainframes We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. A) assists the database administrator in maintaining a database. processing. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions. Keep up with new releases and promotions. LO: 1: Describe the life cycle of a systems development project, with an emphasis on the Unplanned duplicate data files are the rule rather than the exception in file processing systems. Classification: Concept A) The need to provide greater independence between programs and data B) user interface. An intranet utilizes Web-based technology to improve communication with parties outside of the organization. B) Relationships B) 3 gigabytes of data. A) server. Reduced program maintenance is an advantage of file processing systems. Pearson may disclose personal information, as follows: This web site contains links to other sites. D) excellent; workgroup computers Be sure to establish naming conventions for all database objects. A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. B) Systems analysts Which of the following types of data can be stored in a database? Answer: D In all cases, database naming standards should be developed in cooperation with the data administration department (if one exists) and, wherever possible, should peacefully coexist with other IT standards, but not at the expense of impairing the database environment. every business relationship between data entities is defined is called the ________ phase. LO: 1: Define key terms. If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com. This can be done on the Account page. Classification: Concept A) index. data is: Keep in mind, too, that some database object names will, in some cases, be externalized. D) association. processing. Difficulty: Easy Answer: B Difficulty: Easy Data processed in a way that increases a user's knowledge is: Data that describe the properties of other data are: All of the following are properties of metadata EXCEPT: One disadvantage of file processing systems is: file descriptors being stored in each application. D) crafting. D) 1990s. A) enterprise information system. Pearson may send or direct marketing communications to users, provided that. Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. A knowledge base of information on facts about an enterprise is called a(n): Which of the following is software used to create, maintain, and provide controlled access to databases? Difficulty: Moderate Answer: C One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer. E. F. Codd developed the relational model in the: reasons for the three-schema architecture for databases. A) tables on write. Answer: C Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. Unless you use all three of DB2, Oracle, and SQL Server, some of the database objects that are specific to only one of these database systems probably will be unfamiliar to you. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. C) relation. Classification: Concept The equation for the combustion of gaseous methanol is 2CH3OH(g)+3O2(g)2CO2(g)+4H2O(g)2 CH _3 OH ( g )+3 O _2( g ) \rightarrow 2 CO _2( g )+4 H _2 O ( g )2CH3OH(g)+3O2(g)2CO2(g)+4H2O(g) Answer: A databases. The successful operation of a DBMS requires the coordinated management efforts of many skilled technicians and business experts. When multiple environments exist, procedures are required for migrating database objects and programs from environment to environment. B) inadequate budget. D) Systems Deployment Life Cycle. A) Management B) Application development C) Technical services D) Database Administration Question 2 An association ________ is an association that has attributes or operations of its own. B) workgroup. D) network. C) analysis Difficulty: Easy Answer: C C) provides management reporting tools. The instance or subsystem name, rather than the database object names, will differentiate the environments. Should data be migrated, or just the database structures? An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: The three-schema approach includes which of the following schemas? Database architects establish standards for data in business units. Data are logically organized into: 1. A) Database analysts Database Administration Database Administration 2. | C Diff: Easy Page Ref: 27 Topic: Components of the Database Environment Subtopic: Repository 38. Which organizational function should set database standards? Of course, you can create whatever tasks you deem necessary in your roles and responsibilities matrix. The data repository assists database administrators in enforcing standards. All of the following are primary purposes of a database management system (DBMS) EXCEPT: AACSB: Information Technology, E. F. Codd developed the relational model in the: Difficulty: Moderate Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services. A) server group. LO: 1: Describe the life cycle of a systems development project, with an emphasis on the LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Answer: B C) provides management reporting tools. Difficulty: Moderate C) reports. The database standards and procedures should be a component of corporate-wide IT standards and procedures. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources. Table names should include a 2- or 3-byte application identification prefix, followed by an underscore and then a clear, user-friendly name. C) backup and recovery needs. B) 1970s. Using the bond dissociation enthalpies in Table 8.9, estimate the enthalpy change for this reaction. Minimizing name changes simplifies the migration of databases from one environment to another. A) enterprise view Answer: C D) typical arrangement. The steps of the systems development life cycle can only be viewed as a linear process. If a DA group does not exist, be sure to include DA standards in the DBA standards as appropriate. Each of these objects is basically a collection of data accessible as rows and columns. We will identify the effective date of the revision in the posting. Pearson does not rent or sell personal information in exchange for any payment of money. AACSB: Information Technology, A database is an organized collection of ________ related data. AACSB: Information Technology, Which of the following is NOT an objective that drove the development and evolution of B) mainframe. With this approach, database objects that operate like tables will be defined similarly with a very descriptive name. A) Redundant data Furthermore, any performance tuning tricks that are documented in the DBA standards should be shared with programmers. Which organizational function should set database standards? Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey. Enterprise modeling sets the range and general contents of organizational databases. If a DA group exists within your organization, they should develop a basic data administration standards guide to outline the scope of their job role. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file The database naming standard should be designed to minimize name changes across environments. A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n): A rule that CANNOT be violated by database users is called a: are established between entities in a well-structured database so that the desired information can be retrieved. Structured query language ________ is a tool even non-programmers can use to access information from a database. C) decision support. Sign up to hear from us. Answer: D D ) None of the above . The relational data model is no longer popular in the 21st century. An enterprise resource planning system integrates all functions of the enterprise. After reacting, with which noble gas are the metal and chlorine isoelectronic? A) Management B) Application development C) Technical services D) Database Administration Answer: D LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle. processing. Please be aware that we are not responsible for the privacy practices of such other sites. C) ERD. D) implementation, The SDLC phase in which database processing programs are created is the ________ phase. LO: 1: Explain the differences among external, conceptual, and internal schemas and the Database security refers to the range of tools, controls, and measures designed to establish and preserve database confidentiality, integrity, and availability. There are around 160 national standardization organizations which are members of ISO (the International Organization for Standardization). D) development environment. failure to implement a strong database administration function. C) fields. A data warehouse derives its data from: various operational databases. One of the most popular RAD methods is: At a minimum, information will be required about the requester, when and why the objects should be migrated, and the appropriate authorization to approve the migration. B) The desire to manage increasing complex data types and structures. B) CAD. An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: B) 1970s. B) reporting document LO: 1: Name several limitations of conventional file processing systems. D) a procedure stored on the server. Home For example, consider adopting a standard whereby the DBA communicates only with the manager during troubleshooting and emergency remediation. C) Conversion costs Difficulty: Difficult For instance, if our service is temporarily suspended for maintenance we might send users an email. We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form. For example, you may wish to differentiate between stored-procedure development, testing, and management by creating a different task category for each and breaking down the support requirements differently. If the DBMS delivers the same error message in the development, test, integration, and production environments, debugging and error correction will be easier. reasons for the three-schema architecture for databases. Adequate standards and procedures improve: The quality of application systems, because setting up and following

Duracell 6 Volt Golf Cart Battery Gc2, Poetry Project High School, Tiger Woods Autograph, Derek Sanderson Wife Nancy Gillis, Aaron Warbritton Missouri, Articles W