This assignment reflects an accumulation of the individual assignments from Weeks One through Five, which included creating an ERD, exploring database fundamentals, Data Architecture for Transactional Databases, Interacting with a Transactional Database, Data and Database Administration for Transactional Databases, Data Warehouses and Historical Data.\tWrite an additional 1- to 2-page paper based on the following information:\tManagement is happy with the operational work you have done and with your support of their strategic investigation of the situation and trends over time through the data warehouse. But they have heard that new techniques called analytics (or even “big data”\ufffd) can be used to find unexpected gems in all of the data that they have been collecting, whether or not it is structured.\tAre there kinds of behavior (e.g., by customers or products or their own systems) that might be valuable to be able to predict What are they What data (either internal sources described in the materials or external data sources available for free or purchase) might help make these predictions What tools would you use for management of the data, for statistical analysis, or for visualization Why is it appropriate to meet the organization’s needs\tReview and consolidate the individual assignment papers you have written throughout Weeks One through Six, along with any feedback you received from your instructor, and ensure you have included the following:\tExplained the role of data in information systems and business\tDistinguished between the three types of data management in modern organizations\tExplained the meaning of key data management questions and the importance of the answers\tExplained the environment, roles, and skills needed to support transactional data management, including relational database environment, database designers, database developers, and database administrators\tExplained and applied techniques for deciding what data you need for transactional data management, including: entity relationship modeling and conceptual design\tDemonstrated how to use DML to enter information into relational databases\tExplained how to use SQL to extract rows and columns of data from tables and combine data from multiple tables, using SELECT\tDistinguished between different approaches for managing data in relational databases, and explained when each might be used, including applications with embedded SQL, stored procedures, and triggers\tExplained why database and information security is important to an organization\tExplained how database administrators and developers can protect the integrity and confidentiality of data against internal and external attacks\tExplained how database administrators can protect data integrity against system and hardware outages\tExplained the roles, skills, and tools needed for managing historical data via data warehouses\tExplained how to select, clean, and bring data of interest into a data warehouse\tDemonstrated techniques for designing an effective data warehouse, through star database structures, selecting and organizing fact and dimension tables, and specialized indexing (e.g., bitmap indexes)\tExplained the skills and environments required for analytic data\tDescribed how those tools are used\tExplained the business value of analytic results, such as data visualization and finding and applying patterns<\/p>\n","protected":false},"excerpt":{"rendered":"
This assignment reflects an accumulation of the individual assignments from Weeks One through Five, which included creating an ERD, exploring database fundamentals, Data Architecture for Transactional Databases, Interacting with a Transactional Database, Data and Database Administration for Transactional Databases, Data Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-210268","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/210268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=210268"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/210268\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=210268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=210268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=210268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}