which organizational function should set database standards?

D) managing data. Generally, users may not opt-out of these communications, though they can deactivate their account information. 1) One application of data warehouses is: A) shipping of information. Databases Bit(Character) - a bit is the smallest unit of D) The need to provide ever more powerful platforms for decision support applications. B) database descriptors. They should be stored together in a central location as a printed document, in an online format, or as both. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Although the DBA standards will be most useful for the DBA staff, the application development staff will need them to learn how best to work with the DBA staff. However, at some shops the corporate data security unit handles DBMS security. Several vendors offer "canned" standards and procedures that can be purchased for specific DBMS products. B) Application development Answer: C D) Attribute. Classification: Concept Difficulty: Easy D) implementation The DBA should develop database standards and procedures as a component of corporate-wide IT standards and procedures. contents of organizational databases. processing. D) file updating. A) 1950s. Data are the principal resources of an organization. B) constraint. Which of the following is NOT an advantage of database systems? B) reporting document B) Cost of conversion The Methodology of the Social Sciences (Max Weber), Civilization and its Discontents (Sigmund Freud), Principles of Environmental Science (William P. Cunningham; Mary Ann Cunningham), Campbell Biology (Jane B. Reece; Lisa A. Urry; Michael L. Cain; Steven A. Wasserman; Peter V. Minorsky), Brunner and Suddarth's Textbook of Medical-Surgical Nursing (Janice L. Hinkle; Kerry H. Cheever), Business Law: Text and Cases (Kenneth W. Clarkson; Roger LeRoy Miller; Frank B. Explain how to identify the opposite and adjacent legs of a given acute angle. D) data model. phase. database technology? D) all of the above. D) user snapshot D) caching. Although you should keep the database object names as English-like as possible, you will inevitably encounter situations that require abbreviations. D) Legacy systems. B) structured walkthrough. > While design of databases would be part of solution architecture, the implementation and maintenance of development and production database environments would be the work of the DBA. Which organizational function should set database standards? Which organizational function should set database standards? Using the bond dissociation enthalpies in Table 8.9, estimate the enthalpy change for this reaction. The database naming standard should be designed to minimize name changes across environments. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle. This site currently does not respond to Do Not Track signals. It is possible to make all the database object names the same by assigning each environment to a different instance or subsystem. To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency. B) mainframe. LO: 1: Explain the differences among external, conceptual, and internal schemas and the A) Entities processing. For example, you might want to document how and when the DBA group must communicate with the systems programming group when a new DBMS release is being installed. 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. Participation is voluntary. Unstructured and unpredictable use of data. A) Management B) Application development C) Technical services D) None of the above Answer: D Diff: 2 Page Ref: 12 Topic: Advantages of the Database Approach; Subtopic: Enforcement of Standards. Prototyping is a type of rapid application development. An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: An organizational chart is a visual chart that represents the structure of a company. Logically 4. A user view is how the user sees the data when it is produced. C) 1970s. B) 1960s. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes. 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. C) Cross-functional A) planning Which of the following is NOT an objective that drove the development and evolution of database technology? C) inadequate hardware. The steps of the systems development life cycle can only be viewed as a linear process. LO: 1: Describe the life cycle of a systems development project, with an emphasis on the Difficulty: Moderate Such marketing is consistent with applicable law and Pearson's legal obligations. 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? Figure 2.7 Database objects map to filenames. Requirements Gathering The first step is requirements gathering. D) providing an integrated development environment. The type of object can always be determined by querying the DBMS system catalog or data dictionary. Each of these objects is basically a collection of data accessible as rows and columns. Please be aware that we are not responsible for the privacy practices of such other sites. ________________is often developed by identifying a form or report that a user needs on a regular basis. Or you can gather suggested standards from the community via user groups and conferences. B) design The database standards and procedures should be a component of corporate-wide IT standards and procedures. B) design Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. For instance, if our service is temporarily suspended for maintenance we might send users an email. D) network. Data redundancy is used to establish relationships between data but is never used to improve database performance. D) implementation. C) on demand paging. processing. Classification: Concept C) backup and recovery needs. C) loosely A) the need for specialized personnel. A) logically B) 1970s. A) application programs. An enterprise resource planning system integrates all functions of the enterprise. Ch. A database is an organized collection of ________ related data. Reduced program maintenance is an advantage of file processing systems. D) a procedure stored on the server. Difficulty: Moderate Which of the following types of data can be stored in a database? LO: 1: Identify four categories of applications that use databases and their key characteristics. C) Conversion costs C) fields. Characteristics of the structure of the database are generally changed during the implementation phase of the database development process. They also ensure that work can continue . ________ is a tool even non-programmers can use to access information from a database. 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. Languages, menus, and other facilities by which users interact with the database are collectively called a(n): 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. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account. failure to implement a strong database administration function. databases. Modern Database Management, 13e (Hoffer) Classification: Concept, Program-data dependence is caused by: An organization's corporate functions do not exist in a vacuum; they exist to provide support to the business. Chapter 1 The Database Environment and Development Process, According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored A) planning A basic set of database administration standards should be established to ensure the ongoing success of the DBA function. A database management system is a software tool that makes it possible to organize data in a database. Create a list of standard abbreviations and forbid the use of nonstandard abbreviations. Without standard database object naming conventions, it will be difficult to identify database objects correctly and to perform the proper administration tasks. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file 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. 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) object. LO: 1: Describe the life cycle of a systems development project, with an emphasis on the Difficulty: Moderate Files 5. C) ERD. Answer: C Difficulty: Moderate C) Programmers For example, embedding a T into the name for test and a P for production is a bad idea. C) analysis C) analysis Answer: B Classification: Concept C) provides management reporting tools. There are many types of constraintstriggers, unique constraints, referential constraints, check constraintseach of which can be named. They can be stored as a printed document, in an online format for easy access, or in both ways. Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle. The data repository assists database administrators in enforcing standards. Database development projects are never done in a bottom-up fashion. is the most popular RDMS data model notation. B) design The most common source of database failures in organizations is: failure to implement a strong database administration function. C) decision support. Please note that other Pearson websites and online products and services have their own separate privacy policies. Basic standards that can be modified to your requirements can be bought from a publisher or software vendor. C) Database management system B) Predictable use of data LO: 1: Name several limitations of conventional file processing systems. D) a datamart. D) 80 percent. A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. D) 1990s. Of course, you can create whatever tasks you deem necessary in your roles and responsibilities matrix. B) various operational data sources. C) 1980s. C) user view more than: A) Unstructured and unpredictable use of data Which organizational function should set database standards? CASE is a class of tools that: A) assists the database administrator in maintaining a database. A) creating data. A) Specialized personnel needs A) poor; personal computers 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. The more the application programmers understand the nuances of the DBMS and the role of the DBA, the better the working relationship between DBA and development will beresulting in a more efficient database environment. The relational data model is no longer popular in the 21st century. Classification: Concept 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 . reasons for the three-schema architecture for databases. Data. Standards should be developed to ensure that the operational support staff understands the special requirements of database applications. C) analysis C) analysis D) All of the above, Which of the following will interfere with access to operational databases? C) Improved responsiveness Difficulty: Difficult LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file D) database management system. An organization that has a strong command-and-control system usually requires a vertical, tall organizational administrative structure. While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com. The traditional methodology used to develop, maintain and replace information systems is called the: The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase. A) entity Chapter 6, Design Reviews, offers a comprehensive discussion. Classification: Concept Data that describe the properties of other data are: A database is an organized collection of ________ related data. A) The need to provide greater independence between programs and data Procedures are required for migrating database objects and programs from environment to environment. C) analysis A data warehouse contains summarized and historical information. B) server. failure to implement a strong database administration function. Database Administration: Creating the Database Environment, Defining the Organization's DBMS Strategy, Database Administration: The Complete Guide to DBA Practices and Procedures, 2nd Edition, Supplemental privacy statement for California residents, Mobile Application Development & Programming, Database objects and files can be grouped together in, A clear statement of the organizations overall policy with regard to data, including its importance to the company, Guidelines for establishing data ownership and stewardship, Rules for data creation, data ownership, and data stewardship, Conceptual and logical data modeling guidelines, The organizations goals with regard to creating an enterprise data model, Responsibility for creating and maintaining logical data models, Guidelines for tool usage and instructions on how data models are to be created, stored, and maintained, Instructions on how to document when physical databases deviate from the logical data model, Guidelines on communication between data administration and database administration to ensure effective database creation and usage, A checklist of departments to notify for impending changes, DBMS storage, usage, and monitoring procedures, A description of how database access differs from flat file access, Program preparation procedures and guidance on how to embed SQL in an application program, Interpretations of SQLSTATEs and error codes, References to other useful programming materials for teleprocessing monitors, programming languages, and general application development standards, Details on what authority to grant for specific types of situations; for example, if a program is being migrated to production status, what DBMS authorization must be granted before the program will operate successfully in production, Specific documentation of any special procedures or documentation required for governance- and compliance-related requests, A definitive list of who can approve what types of database authorization requests, Information on any interfaces being used to connect DBMS security with operating system security products, Policies on the use of the WITH GRANT OPTION clause of the SQL GRANT statement and how cascading REVOKEs are to be handled, Procedures for notifying the requester that database security has been granted, Procedures for removing security from retiring, relocating, and terminated employees. A) relationship. of an information system. AACSB: Information Technology, Which of the following is NOT an objective that drove the development and evolution of B) various operational data sources. Pearson may send or direct marketing communications to users, provided that. processing. Answer: C 18) Which organizational function should set database standards? Answer: D A database is an organized collection of related information. B) Users A workgroup database is stored on a central device called a(n): Cost and complexity are just two of the disadvantages of database processing. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions. Although personal databases improve productivity, one risk is that data cannot be shared with other users. Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. A) relationship. C) Lines A database is an organized collection of ________ related data. A) collecting data. A) enterprise view Which of the following is NOT a cost and/or risk of the database approach? Disabling or blocking certain cookies may limit the functionality of this site. C) decision support. D) Ties 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. Answer: B An enterprise data model describes the scope of data for only one information system. The physical database server and/or the virtual database server . This can be done on the Account page. B) a table or set of tables. Classification: Concept, The SDLC phase in which every data attribute is defined, every category of data is listed, and C) ASP C) analysis C) user view C ) Older systems that often contain data of poor quality are called ________ systems. Which organizational function should set database standards?A) ManagementB) Application developmentC) Technical services D) None of the above. Difficulty: Easy 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. D) user snapshot, ) ________ is a tool even non-programmers can use to access information from a database. LO: 1: Describe the life cycle of a systems development project, with an emphasis on the Difficulty: Moderate, A person, place, object, event, or concept about which the organization wishes to maintain A) Management B) Application development C) Technical services D) None of the above D ) None of the above 21) ________ is a tool even non-programmers can use to access information from a database. What is the enthalpy of combustion of one mole of gaseous methanol? They are often used to help prepare system flows or procedural flow charts that outline how a business will operate. The failure to implement a strong database administrative function is the most common source of database failures in organizations. 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. Difficulty: Easy Answer: B A person, place, object, event or concept about which the organization wishes to maintain data is called a(n): entity. A rule that CANNOT be violated by database users is called a: In a file processing environment, descriptions for data and the logic for accessing the data are built into: Databases may be more expensive to maintain than files because of: Which of the following is NOT a cost and/or risk of the database approach? B) a table or set of tables. An X in the matrix indicates involvement in the process, whereas a P indicates primary responsibility. A sample matrix is shown in Table 2.4. A) client. Comprehensive migration procedures should be developed to address these types of questions. B) Systems Development Life Cycle One of the most popular RAD methods is: Answer: D Which organizational function should set database standards? D) more than 7 billion exabytes of data. There are around 160 national standardization organizations which are members of ISO (the International Organization for Standardization). Program failures, hardware failures, and other problems are first identified by operational support before specialists are called to resolve the problems. A) the data is always non-redundant. Operational support assures that applications are run according to schedule. 20) Which organizational function should set database standards? The database standards and procedures should be a component of corporate-wide IT standards and procedures. B) server. Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing. Home The heart of this exercise is defining how corporate functions can help maximize value for an organization. Answer: D D ) None of the above . LO: 1: Name several limitations of conventional file processing systems. AACSB: Information Technology, Database development begins with ________, which establishes the range and general 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. In a file processing environment, descriptions for data and the logic for accessing the data is built into: Which of the following types of data can be stored in a database?

Narvon Beverage Equipment, Articles W