C) analysis 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. B) design A basic set of database administration standards should be established to ensure the ongoing success of the DBA function. Data Governance - Overview, Role and Importance, Benefits purpose of database analysis, design, and implementation activities. A) Management B) Application development C) Technical services D) Database Administration D) Database Administration ________ is a tool even non-programmers can use to access information from a database. reasons for the three-schema architecture for databases. C) Improved responsiveness 12 Test Bank, Lesson 14 What is a tsunami Earthquakes, Volcanoes, and Tsunami, BIO 115 Final Review - Organizers for Bio 115, everything you need to know, Docx - HIS 104 - Essay on Cultural Influence on Womens Political Roles in Rome and, Disorder Asthma - Active Learning Template, C228 Task 2 Cindy - Bentonville - Passed with no revisions, Kami Export - Jacob Wilson - Copy of Independent and Dependent Variables Scenarios - Google Docs, Module One Short Answer - Information Literacy. A) Programmers A) CASE. Several vendors offer "canned" standards and procedures that can be purchased for specific DBMS products. The steps of the systems development life cycle can only be viewed as a linear process. C) analysis A) poor; personal computers C) Technical services Older systems that often contain data of poor quality are called ________ systems. (a4b2)1/2=a2b\left(a^4 b^2\right)^{1 / 2}=\left|a^2 b\right|(a4b2)1/2=a2b. Which organizational function should set database standards? The operational support staff is usually the first line of defense against system problems. C) a logical description of some portion of the database. MIS 183 Chapter 1 Flashcards | Quizlet Classification: Concept, A data warehouse derives its data from: D) providing an integrated development environment. A user view is: Occasionally, we may sponsor a contest or drawing. A) index. A) logically Pearson may disclose personal information, as follows: This web site contains links to other sites. A constraint is a rule in a database system that can be violated by users. Difficulty: Easy Answer: D Developing robust communication standards can simplify a DBAs job during the inevitable downtime that occurs due to system, application, or even hardware errors. Records 4. processing. AACSB: Information Technology, ________ do NOT concentrate on determining the requirements for the database component A graphical system used to capture the nature and relationships among data is called a(n): A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): ________ are established between entities in a well-structured database so that the desired information can be retrieved. Classification: Concept AACSB: Information Technology, E. F. Codd developed the relational model in the: MSIS 533 Module 1 Pre check Flashcards | Quizlet Chapter 1 MCQ - Modern Database Management, 13e (Hoffer - Studocu B) updating data. A sample matrix is shown in Table 2.4. A) lack of planning. D) more than 7 billion exabytes of data. C) data can always be shared with others. C) storing data. 18) Which organizational function should set database standards? D) database process. Personal databases are designed to support a small group of individuals working together on a project. D) End Users Design of Database Systems Final Exam Flashcards | Quizlet Which organizational function should set database standards?A) ManagementB) Application developmentC) Technical services D) None of the above. Classification: Concept, The period that can be considered a "proof of concept" time was the: There are many types of constraintstriggers, unique constraints, referential constraints, check constraintseach of which can be named. A) link B) group C) class D) body B) 25 percent A) planning Table names should include a 2- or 3-byte application identification prefix, followed by an underscore and then a clear, user-friendly name. Which of the following is NOT a cost and/or risk of the database approach? C) relation. The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems. [Answered] Which organizational function should set database standards D) implementation C) decision support. A) ODBC End users can often retrieve and display data easily with a relational database. Answer: C processing. Database Trends: "Database Standards & Procedures" - Craig S. Mullins The term legacy system refers to a newly installed database management system. Fields 3. Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information. A) planning Classification: Concept Difficulty: Easy C) PC. They also ensure that work can continue . 28 Which organizational function should set database standards A 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. Whatever the final format of your roles and responsibilities matrix, be sure to keep it accurate and up-to-date with new DBMS features and tasks. You may need additional tasks, or fewer than in this sample. B) Cost of conversion Answer: C Data that describe the properties of other data are: A database is an organized collection of ________ related data. B) mainframe. Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. A) Redundant data Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing. A data warehouse derives its data from: various operational databases. The database naming standard should be designed to minimize name changes across environments. 2) Which organizational function should set database standards? A) ODBC B) Structured query language C) ASP B) Organizational conflict The scope of an enterprise application is one workgroup or department. Database Administration Database Administration 2. processing. For cis-1,3-diethylcyclobutane, draw (a) a stereoisomer; (b) a constitutional isomer. C) design web pages. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. In general, do not impose unnecessary restrictions on the names of objects accessed by end users. 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. ________ are established between entities in a well-structured database so that the desired information can be retrieved. Pearson may send or direct marketing communications to users, provided that. B) unplanned duplicate data files are the rule rather than the exception. An additional set of DBA standards that cover database performance monitoring and tuning may be useful to document procedures for overcoming performance problems. A data model is a graphical system used to capture the nature and relationships among data. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx. B) Cost of conversion For example, a good name for the table containing employee information in a human resources system would be HR_EMPLOYEE. A) design The type of object can always be determined by querying the DBMS system catalog or data dictionary. A) the need for specialized personnel. A) file descriptions being stored in each database application. D) network. Classification: Concept A strict database naming convention, if not developed logically, can be antithetical to a useful and effective database environment. B) user interface. I would like to receive exclusive offers and hear about products from InformIT and its family of brands. When business rules are made right, they provide efficiency, consistency, predictability, and benefits. 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. B) updating data. Data redundancy is used to establish relationships between data but is never used to improve database performance. D) automates the design of databases and application programs. For example, what data volume is required for each environment and how is data integrity to be assured when testing activity occurs? D) development environment. Classification: Concept C) Cross-functional Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications. B) constraint. Comprehensive migration procedures should be developed to address these types of questions. 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. purpose of database analysis, design, and implementation activities. On rare occasions it is necessary to send out a strictly service related announcement. Answer: D Procedures are defined, step-by-step instructions that direct the processes required for handling specific events, such as a disaster recovery plan. 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. B) object. B) various operational data sources. The three-schema approach includes which of the following schemas? purpose of database analysis, design, and implementation activities. C) departmental data modeling Difficulty: Moderate Each higher rung of this hierarchy is organized from the components below it. What Are Organizational Functions? | Bizfluent A) The need to provide greater independence between programs and data. 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: Define key terms. Difficulty: Moderate C) Improved responsiveness We may revise this Privacy Notice through an updated posting. The manager can communicate the status outward while the DBA focuses exclusively on troubleshooting and getting the systems back up and running again. The external schema contains a subset of the conceptual schema relevant to a particular group of users. Chapter 13 Database Development Process - Database Design - 2nd Edition A database is an organized collection of ________ related data. D) All of the above, Which of the following will interfere with access to operational databases? LO: 1: Explain the differences among external, conceptual, and internal schemas and the B) database descriptors. AACSB: Information Technology, The three-schema approach includes which of the following schemas? Continued use of the site after the effective date of a posted revision evidences acceptance. Answer: B Therefore, it may be necessary to make exceptions to existing shop standards for naming database files. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. With the consent of the individual (or their parent, if the individual is a minor), In response to a subpoena, court order or legal process, to the extent permitted or required by law, To protect the security and safety of individuals, data, assets and systems, consistent with applicable law, In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice, To investigate or address actual or suspected fraud or other illegal activities, To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract, To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice. B) 1960s. B) mainframe. processing. B) Application development C) systems information unit. What is the enthalpy of combustion of one mole of gaseous methanol? Which of the following is NOT an objective that drove the development and evolution of database technology? Minimizing name changes simplifies the migration of databases from one environment to another. Modern Database Management, 13e (Hoffer) A) Database analysts An X in the matrix indicates involvement in the process, whereas a P indicates primary responsibility. AACSB: Information Technology, A(n) ________ is often developed by identifying a form or report that a user needs on a Answer: B CASE is a class of tools that: A) 40 percent A) client. Benefits of Data Governance. Classification: Concept Answer: D The DBA should develop database standards and procedures as a component of corporate-wide IT standards and procedures. B) structured walkthrough. The instance or subsystem name, rather than the database object names, will differentiate the environments. LO: 1: Identify four categories of applications that use databases and their key characteristics. Applications built with a multitier architecture are meant to support departments. C) analysis B) server. IMS 14 - Database administration - Standards and procedures for - IBM Which organizational function should set database standards? B) inadequate budget. In 1998, ANSI/SPARC published an import document describing the three-schema architecture. D) 1990s. A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. Which organizational function should set database standards? A well-structured database establishes the entities between relationships in order to derive the desired information. The SDLC phase in which the detailed conceptual data model is created is the ________ phase. An up-to-date matrix makes it easier to define roles within the organization and to effectively apportion database-related workload. B) Logical Structured query language ________ is a tool even non-programmers can use to access information from a database. Answer: A Several vendors offer "canned" standards and procedures that can be purchased for specific DBMS products. Although you should keep the database object names as English-like as possible, you will inevitably encounter situations that require abbreviations. IS 410 Exam I Mock Test Flashcards | Quizlet A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. 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? D) association. B) relationship Harden the Database Just as the server must be hardened, the database. A) creating data. This site currently does not respond to Do Not Track signals. D) Data manipulation query language. Difficulty: Moderate C) remote PC. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file Classification: Concept Database Security: An Essential Guide | IBM Difficulty: Easy Database processing programs are coded and tested during the design stage of the systems development life cycle. Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance. 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. C) Unified Model 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. A) logically LO: 1: Define key terms. Answer: C Answer: D Top 10 Database Compliance Best Practices | DBmaestro D) repository. AACSB: Information Technology, A departmental multi-tiered client/server database is stored on a central device called a: The database standards and procedures should be a component of corporate-wide IT standards and procedures. failure to implement a strong database administration function. E. F. Codd developed the relational model in the: In two-tier database architectures, little functionality needs to be programmed into the client application. 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? AACSB: Information Technology, Organizations that utilize the file processing approach spend as much as ________ of their IS 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. Classification: Concept C) Unified Model. | C Diff: Easy Page Ref: 27 Topic: Components of the Database Environment Subtopic: Repository 38. C) prototyping. A) client. D) 1990s. Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. A) entity LO: 3: Define key terms. All information in a database should be related as well; separate databases should be created to manage unrelated information. C) reports. 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. Be sure to establish naming conventions for all database objects. This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. B) cross-functional analysis Difficulty: Moderate A) Entities Classification: Concept We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes. Classification: Concept, Program-data dependence is caused by: A) 1950s. B) workgroup. C) analysis ________ is a tool even non-programmers can use to access information from a database. C) attribute. However, at some shops the corporate data security unit handles DBMS security. Minimize name changes across environments. > Classification: Concept 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. Difficulty: Easy 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) database descriptors. processing. Chapter 1 The Database Environment and Development Process, According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored Element X is a solid metal that reacts with chlorine to produce a water-soluble binary compound. Answer: B Pearson automatically collects log data to help ensure the delivery, availability and security of this site. database, the major record-keeping entity of a firm. A) the data is always non-redundant. C) fields. LO: 1: Describe the life cycle of a systems development project, with an emphasis on the There are around 160 national standardization organizations which are members of ISO (the International Organization for Standardization). LO: 1: Explain the roles of individuals who design, implement, use, and administer The user interface includes languages, menus, and other facilities by which users interact with various system components. An organizational or business function is a core process or set of activities carried out within a department or areas of a company. data is called a(n): data is: They can be stored as a printed document, in an online format for easy access, or in both ways. Classification: Concept AACSB: Information Technology, Database management involves all of the following EXCEPT: processing. D) enterprise data modeling, The traditional methodology used to develop, maintain and replace information systems is called the: D) a datamart. A) planning information can be retrieved. C) 60 percent C) Database management system Standards can establish backup and recovery procedures (including disaster recovery plans) and communicate the methods used to transform a logical data model into a physical database implementation. ________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business. How should existing data in the target environment be treatedshould it be kept, or overlaid with new data? For instance, most DBMSs externalize constraint names when the constraint is violated. LO: 1: Explain at least 10 advantages of the database approach, compared to traditional file 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 heart of this exercise is defining how corporate functions can help maximize value for an organization. Each member of a workgroup accesses data located on a database server. B) provides guidelines for the physical design of a database. Database Administrator (DBA) Roles & Responsibilities in The Big Data Program failures, hardware failures, and other problems are first identified by operational support before specialists are called to resolve the problems. B) maintenance Answer: C collectively called a(n): Difficulty: Moderate Difficulty: Moderate A data warehouse contains summarized and historical information. C) Programmers D) database management system. Procedures are required for migrating database objects and programs from environment to environment. AACSB: Information Technology, All of the following are primary purposes of a database management system (DBMS) The most common source of database failures in organizations is: failure to implement a strong database administration function. 14 Assisting w/ the Physical Examination. C) ERD. 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. D) data cohabiting with programs. Prototyping is a type of rapid application development.