which organizational function should set database standards?

The data administration standards should include the following items: The DBA standards serve as a guide to specific approaches to supporting the database environment. A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): Relational databases establish the relationships between entities by means of common fields included in a file called a(n): is a tool even non-programmers can use to access information from a database. > Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. Adequate standards and procedures improve: The quality of application systems, because setting up and following Of course, you can create whatever tasks you deem necessary in your roles and responsibilities matrix. B) schema on write. All information in a database should be related as well; separate databases should be created to manage unrelated information. A database is an organized collection of related information. C) storing data. Database development begins with ________, which establishes the range and general contents of organizational databases. Difficulty: Easy failure to implement a strong database administration function. contents of organizational databases. Create a list of standard abbreviations and forbid the use of nonstandard abbreviations. C) prototyping. Answer: C B) database descriptors. processing. Difficulty: Moderate Keep in mind, too, that some database object names will, in some cases, be externalized. The period that can be considered a "proof of concept" time was the: Several vendors offer "canned" standards and procedures that can be purchased for specific DBMS products. LO: 1: Identify several costs and risks of the database approach. 15) Which organizational function should set database standards?A) ManagementB) Application development C) Technical services D) Database Administration Answer: DLO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file. Continued use of the site after the effective date of a posted revision evidences acceptance. Classification: Concept B) Users With the database approach, data descriptions are stored in a central location known as a(n): a logical description of some portion of the database. This can be done on the Account page. B) object. D) Ties D) caching. before or at the time of use of the data is called: Pearson may disclose personal information, as follows: This web site contains links to other sites. Articles C) user view CASE is a class of tools that: D) development environment. Minimizing name changes simplifies the migration of databases from one environment to another. An enterprise resource planning system integrates all functions of the enterprise. C) ERD. A) Management B) Application development C) Technical services D) Database Administration D) Database Administration 19) ________ is a tool even non-programmers can use to access information from a database. C) Improved responsiveness One disadvantage of file processing systems is: limited data sharing. Older systems that often contain data of poor quality are called ________ systems. databases. Comprehensive migration procedures should be developed to address these types of questions. A basic list of database objects supported by most DBMSs includes databases, tables, columns, views, indexes, constraints, programs, user-defined data types, user-defined functions, triggers, and stored procedures. AACSB: Information Technology, Because applications are often developed independently in file processing systems: 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. Which organizational function should set database standards? : 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. The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems. A) planning Answer: D With the database approach, data descriptions are stored in a central location known as a(n): File processing systems have been replaced by database systems in most critical business applications today. Classification: Concept Characteristics of the structure of the database are generally changed during the implementation phase of the database development process. of an information system. Answer: C Data are the principal resources of an organization. B) reporting document It is especially important to avoid this approach for user-visible database objects such as columns, tables, and views. Classification: Concept D) Systems Deployment Life Cycle. The period that can be considered a "proof of concept" time was the: A relatively small team of people who collaborate on the same project is called a(n): A workgroup database is stored on a central device called a(n): Which of the following is an integrated decision support database with content derived from various operational databases? In general, do not impose unnecessary restrictions on the names of objects accessed by end users. E. F. Codd developed the relational model in the: Some organizations impose arbitrary length limitations on database tables, such as an 8-byte limit even though the DBMS can support up to 128-byte table names. Difficulty: Easy Difficulty: Moderate D) file updating. C) analysis A) Management Basic standards that can be modified to your requirements can be bought from a publisher or software vendor. You should document the special development considerations required when writing programs that access databases. B) excellent; mainframes An organization that has a strong command-and-control system usually requires a vertical, tall organizational administrative structure. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file A) Internal Which of the following types of data can be stored in a database? Answer: B C) poor; mainframes C) on demand paging. A modern database management system automates more of the backup and recovery tasks than a file system. B) design B) user interface. Redundancy increases the risk of inconsistent data. Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. D) implementation D) All of the above, Which of the following will interfere with access to operational databases? Use the formula in the said example to make the following degree conversions. 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. We may revise this Privacy Notice through an updated posting. D) there is a large volume of file I/O. A) Programmers Keep up with new releases and promotions. B) Cost of conversion D) implementation D) implementation. Chapter 1 The Database Environment and Development Process, According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored C) 1970s. Front-Office Functions Classification: Concept, Languages, menus, and other facilities by which users interact with the database are Languages, menus, and other facilities by which users interact with the database are collectively called a(n): Database development begins with ________, which establishes the range and general contents of organizational databases. A) planning Spend time considering how you define types having standard database types for fields or bespoke types are a good thing to sort out upfront. Some organizations, however, create multiple environments to support, for example, different phases of the development life cycle, including. Which organizational function should set database standards?A) ManagementB) Application developmentC) Technical services D) None of the above. C) Improved responsiveness A) index. An equation involving variables should be marked true only if it is an identity. One of the most popular RAD methods is: The database standards and procedures should be a component of corporate-wide IT standards and procedures. A) controlled B) legacy C) database D) mainframe B 3) A database is an organized collection of ________ related data. A user view is: Organizations that employ separate data administration functions often have mainframe-based databases that have been developed using established systems development methodology, including development of logical and physical models. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file purpose of database analysis, design, and implementation activities. regular basis. With this approach, database objects that operate like tables will be defined similarly with a very descriptive name. For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. A) ODBC B) 1970s. Pearson does not rent or sell personal information in exchange for any payment of money. Difficulty: Easy D) Organizational conflict Chapter 6, Design Reviews, offers a comprehensive discussion. B) updating data. One of the first standards to be implemented should be a set of guidelines for the naming of database objects. processing. Data are logically organized into: 1. Classification: Concept B) data warehouse. It highlights how teams and departments are organized, the reporting relationships across the organization, and every individual's role and responsibilities. With the traditional file processing approach, each application shares data files, thus enabling much data sharing. A database is an organized collection of ________ related data. Marketing preferences may be changed at any time. A knowledge base of information on facts about an enterprise is called a(n): purpose of database analysis, design, and implementation activities. AACSB: Information Technology, Relational databases establish the relationships between entities by means of common fields AACSB: Information Technology, The SDLC phase in which the detailed conceptual data model is created is the ________ Databases Bit(Character) - a bit is the smallest unit of C) remote PC. How should existing data in the target environment be treatedshould it be kept, or overlaid with new data? Operational support is defined as the part of the IT organization that oversees the database environment and assures that applications are run according to schedule. D) Dissecting Data that describe the properties of other data are: A database is an organized collection of ________ related data. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. C) remote PC. 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. A) Enterprise Resource Model. called the: AACSB: Information Technology, A user view is: Difficulty: Easy C) The desire to require programmers to write all file handling functionality. B) inadequate budget. A) creating data. Difficulty: Difficult In a file processing environment, descriptions for data and the logic for accessing the data is built into: Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information. Design reviews can take many forms. D) crafting. B) object. 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 . B) design On rare occasions it is necessary to send out a strictly service related announcement. Historia de la literatura (linea del tiempo), Leadership class , week 3 executive summary, I am doing my essay on the Ted Talk titaled How One Photo Captured a Humanitie Crisis https, School-Plan - School Plan of San Juan Integrated School, SEC-502-RS-Dispositions Self-Assessment Survey T3 (1), Techniques DE Separation ET Analyse EN Biochimi 1. In a file processing environment, descriptions for data and the logic for accessing the . When multiple environments exist, procedures are required for migrating database objects and programs from environment to environment. B) Relationships An organizational chart is a visual chart that represents the structure of a company. D) Data manipulation query language. Figure 2.7 Database objects map to filenames. Procedures are defined, step-by-step instructions that direct the processes required for handling specific events, such as a disaster recovery plan. Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications. B) 3 gigabytes of data. processing. > processing. D) a procedure stored on the server. more than: Failure to implement database standards and procedures will result in a database environment that is confusing and difficult to manage. B) Organizational conflict The database application development standards should function as an adjunct to any standard application development procedures within your organization. This privacy statement applies solely to information collected by this web site. D) database management system. User view 3. AACSB: Information Technology, Database management involves all of the following EXCEPT: Answer: D Furthermore, any performance tuning tricks that are documented in the DBA standards should be shared with programmers. Files 5. A) password. C) departmental data modeling C) icon. C) at least 100 petabytes of data. Redundant data Which of the following is NOT an advantage of database systems? B) the size of the CPU used. This set of standards should include. Using the bond dissociation enthalpies in Table 8.9, estimate the enthalpy change for this reaction. A) Corporate data structure Difficulty: Difficult Relational databases establish the relationships between entities by means of common fields included in a file called a(n): All of the following are primary purposes of a database management system (DBMS) EXCEPT: providing an integrated development environment. Databases may be more expensive to maintain than files because of: B) Systems analysts Furthermore, the same naming conventions should be used for all tablelike objects, including views, synonyms, and aliases, if supported by the DBMS. IMS 14 - Database administration - Standards and procedures for database systems Standards and procedures for database systems You must develop standards and procedures for your database system. To ensure the success of the migration, the DBA should document the methods used for the migration and record the verification process. C) Lines D) excellent; workgroup computers Difficulty: Moderate Classification: Concept There are many types of constraintstriggers, unique constraints, referential constraints, check constraintseach of which can be named. A) 1960s. The most common way to support a group of individuals who work together on a project or group of similar projects is with a two-tier client/server database. B) order processing. C) repository. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file C) Systems analysts Several vendors offer "canned" standards and procedures that can be purchased for specific DBMS products. 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. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Answer: C The standards serve as a guide to the DBA services offered and to specific approaches to supporting the database environment. A) 1950s. C) decision support. The DBA should develop database standards and procedures as a component of corporate-wide IT standards and procedures. phase. D) more than 7 billion exabytes of data. Once again, standards for system administration or systems programming are required only if your organization separates the SA function from the DBA function. The successful operation of a DBMS requires the coordinated management efforts of many skilled technicians and business experts. A basic set of database administration standards should be established to ensure the ongoing success of the DBA function. Check whether the equation is true or false and explain your answer. You may need additional tasks, or fewer than in this sample. B) User view We will identify the effective date of the revision in the posting. Repositories are always used in file processing systems. D) providing an integrated development environment. A sample matrix is shown in Table 2.4. D) association. A matrix of database management and administration functions should be developed that documents each support task and who within the organization provides the support. Difficulty: Moderate A) enterprise view We use this information to address the inquiry and respond to the question. D) 80 percent If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com. Difficulty: Easy D) repository. A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. 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) B) a table or set of tables. D) automates the design of databases and application programs. 1) One application of data warehouses is: ) Older systems that often contain data of poor quality are called ________ systems. An organization's corporate functions do not exist in a vacuum; they exist to provide support to the business. Requirements Gathering The first step is requirements gathering. C) Technical services Standards are common practices that ensure the consistency and effectiveness of the database environment, such as database naming conventions. ________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business. Difficulty: Moderate AACSB: Information Technology, The traditional methodology used to develop, maintain, and replace information systems is Difficulty: Moderate Modual 1 Discussion 1 How does this article give you a better understanding of the changing perception of Irish immigrants in America? Difficulty: Easy We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes. D) The need to provide ever more powerful platforms for decision support applications. ) Classification: Concept A) entity D) records. A) what a user sees when he or she looks out the window. Which organizational function should set database standards? D) entity. Answer: A All database applications should be subjected to a design review at various stages of their development. A person, place, object, event or concept about which the organization wishes to maintain data is called a(n): entity. Organizational commitment to a database project is not necessary for its success. C) Lines LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file A) planning Answer: C LO: 1: Define key terms. The DBA group often applies and administers DBMS security. Table names should be as descriptive as possible, within reason. However, this list is incomplete because each DBMS uses other database objects specific to its operation. D) 1990s. The data repository assists database administrators in enforcing standards. Answer: A D) providing an integrated development environment. The migration and turnover procedures should document the information required before any database object or program can be migrated from one environment to the next. Studies have shown that companies with high levels of standardization reduce the cost of supporting end users by as much as 35 percent or more as compared to companies with low levels of standardization. ________ is a tool even non-programmers can use to access information from a database. D) 80 percent. 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. D) entity. 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. For example, consider adopting a standard whereby the DBA communicates only with the manager during troubleshooting and emergency remediation. Such marketing is consistent with applicable law and Pearson's legal obligations. Using standard abbreviations will minimize mistyping and make it easier for users to remember database object names. The most common source of database failures in organizations is: failure to implement a strong database administration function. A) 1960s. 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. AACSB: Information Technology, Which of the following is NOT a cost and/or risk of the database approach? A) server. Redundant data Which of the following is NOT an advantage of database systems? Relational databases are supposed to be user friendly. A) ODBC B) Structured query language C) ASP D) Data manipulation query language B ) Metadata are data that describe the properties of other data. A workgroup database is stored on a central device called a(n): D) view. ) Answer: C Database Administration Database Administration 2. B) maintenance Naming Guidelines: One of the first . Which organizational function should set database standards? reasons for the three-schema architecture for databases. Many of the disadvantages of file processing systems can also be limitations of databases. Although database naming standards are important, you will need to develop and maintain other types of database standards. Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site. C) 60 percent Specific guidelines are needed to accomplish migration in a manner conducive to the usage of each environment. B) provides guidelines for the physical design of a database. An additional set of DBA standards that cover database performance monitoring and tuning may be useful to document procedures for overcoming performance problems. A) client. They should be stored together in a central location as a printed document, in an online format, or as both. B) 1970s. 12 Test Bank - Gould's Ch. A) Specialized personnel needs D) development environment. B) Cost of conversion Which of the following is NOT a cost and/or risk of the database approach? D) repository. A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): If the DBMS delivers the same error message in the development, test, integration, and production environments, debugging and error correction will be easier.

Shipwreck Coconut Rum Cream Recipes, Miraculous Ladybug Dark Theories, 15 Liter Patron Bottle For Sale, Rector And Visitors Of The University Of Virginia Hospital, Is Monk Coming Back 2021, Articles W