DBM 502 Exciting Results / snaptutorial.com

1. DBM 502 Apply Team Week 4 Data Models For more classes visit www.snaptutorial.com Read the following sections of “Case Forondo Artist Management Excellence Inc.” of Modern Database Management: “Case Description” “Email from Alex Martin, Administrative Assistant” “Email from Dale Dylan, Established Artist” “Email from Sandy Wallis, Event Organizer” After reading the Case descriptions and emails, create a 700-word document, and ensure you: Modify the enterprise data model you created in Week 2 to accommodate the information gleaned from Alex Martin’s, Dale Dylan’s, and Sandy Wallis’s e-mails. Create an ER diagram for FAME based on the enterprise data model you developed in Week 2. State any assumptions you made in developing the diagram. Submit your assignment.

2. ********************************************** DBM 502 Apply Week 1 Database Management Plan Part 1 Storing and Extracting Information For more classes visit www.snaptutorial.com Scenario You are the Vice President for Information Technology at a small, growing business. You have been tasked with developing a plan for maintaining databases for storage of business data and use in business analytics. In Weeks 1-5 you will work on gathering information in a Database Management Plan. In Week 6, you will present your plan in a 20-minute presentation (10-12 slides) to the President of Information Technology. Create a 700-word entry in your Database Management Plan. You will use information from this entry in your presentation due in Week 6. In your Database Management Plan entry, ensure you: Provide an overview of how databases can be used in a company to store and extract information. Decide what data elements need to be stored. Analyze major component of the SDLC when developing this database application.

3. A Database Management Plan template is available to help you record and organize your information. ********************************************** DBM 502 Apply Week 2 Database Management Plan Part 2 Database Storage For more classes visit www.snaptutorial.com Create 700-word entry in your Database Management Plan. You will use information from this entry in your presentation due in Week 6. Ensure you: Assess the best way to organize data into your database. Distinguish how organizational data can be used in the most effective way through developing a database. Describe the relationship model and conceptual design to be used. ********************************************** DBM 502 Apply Week 2 Team Database Instruction Analysis

4. For more classes visit www.snaptutorial.com Read the following sections of “Case Forondo Artist Management Excellence Inc.” on p. 51 of Modern Database Management: “Case Description” “Email from Martin Forondo, Owner” As a Learning Team, create a 750-word memo describing your initial analysis of the situation at Forondo Artist Management Excellence (FAME) as it relates to the design of the database application. Write this as though you are writing a memo to Martin Forondo. In your memo, ensure you: Decide your approach to addressing the problem at hand (e.g., specify the systems development life cycle or whatever approach you plan on taking). Determine what the new system will accomplish. What functions will it perform? Which organizational goals will it support? Discuss what the benefits of using the new system will be. Use 2 concrete examples to illustrate this. List general categories of costs and resources needed for the project and implementation of the ultimate system. Recommend a timeline/road map for the project.

5. Create an enterprise data model that captures the data needs of FAME. Use a notation similar to the one shown in Figure 1-4 of Modern Database Management. Submit your assignment. ********************************************** DBM 502 Apply Week 3 Database Management Plan Part 3 Database Administration and Data Governance For more classes visit www.snaptutorial.com Based on your previous work in the previous week, create a 700-word entry in your Database Management Plan. Ensure you:

6. Evaluate and assist company decision makers in understanding the importance of database administration and data governance in relation to building scalable and robust applications. Describe how SQL constructs could be used to create data definition language (DDL) and data manipulation languages (DML). Explain how the design would be checked from each role’s perspective, according to the information they require. Use these roles as an example: The administration team needs access to records and permission to update and enter new data. The development teams need to write the expected transactions relatively easily, which might depend on the degree of normalization. The application team needs access to any and all data to manage the interface. ********************************************** DBM 502 Apply Week 4 Database Management Plan Part 4 Administration and Validation For more classes visit www.snaptutorial.com Based on your previous work in the previous week, create a 700-word entry in your Database Management Plan. You will use information from this entry in your presentation due in Week 6. Ensure you:

7. List the benefits of data administration compared to database administration. Propose an effective data governance program. Define the standards and approaches for the validation of database and application code.These include coding standards, expectations for what has been checked at each stage of testing (unit test, system test, user test), expectations for code review or inspection, etc. Submit your assignment. ********************************************** DBM 502 Apply Week 5 Database Management Plan Part 5 Monitoring and Team Roles For more classes visit www.snaptutorial.com Based on your previous work in the previous weeks, create a 700-word entry in your Database Management Plan. Consider the previous week’s creation of standards for database administration and explain the following in your entry: How performance will be monitored and tuned

8. How backups will happen How data quality will be monitored and improved How information should be secured, etc. How all of the standards are important to the business from a user perspective Also, include the following from this week’s learning: Explanations of how individual team roles will need to contribute to managing historical data via data warehouses and data marts Recommendations of techniques for designing an effective data warehouse Submit your assignment. ********************************************** DBM 502 Apply Week 6 Database Management Plan Final Project Plan for Business Data and Analytics For more classes visit www.snaptutorial.com

9. You are the Vice President of Information Technology at a small, growing business. You have been tasked with developing a plan for maintaining databases for storage of business data and use in business analytics. Using the work from Weeks 1-5, create a 20-minute presentation (10-12 slides) to explain your Database Management Plan. Ensure you: Provide an overview of how databases can be used in a company to store and extract information. Distinguish how organizational data can be used in the most effective way through developing a database. Compare how structured and unstructured data are used for data analytics, including concepts like Cloud and Hadoop. Evaluate and assist company decision makers in understanding the importance of database administration and data governance in relation to building scalable and robust applications. List the benefits of data administration compared to database administration. Propose an effective data governance program. Recommend how individual team roles can contribute to finding ways to build in ongoing monitoring; all roles have an interest in database quality and recovery. Summarize how your plan will assist the company in overall effectiveness, including the value of analytic results, such as data visualization and finding and applying patterns. Your goal is to convince them that by implementing your Database Management Plan, the organization will be able to deliver effective, reliable data management support to meet business needs.

10. Include videos, audio, photos, diagrams, graphs, (as appropriate) and substantial speaker notes or audio narration in your presentation. Submit your assignment. ********************************************** DBM 502 Entire Course For more classes visit www.snaptutorial.com DBM 502 Week 1 Database Fundamentals (800 Words Paper) DBM 502 Week 2 Team Database Roles DBM 502 Week 2 Entity Relationship Diagram (100 % Score) DBM 502 Week 3 Team Database Design Standards DBM 502 Week 3 Individual DDL and SQL DBM 502 Week 4 Database Warehouse and Historical Data (100% Score) DBM 502 Week 4 Database Validation Plan DBM 502 Week 5 Team Database Administration Standards DBM 502 Week 5 Historical Data Paper DBM 502 Week 6 Team Executive Presentation

11. DBM 502 Week 6 Big Data Paper (14 Pages) ********************************************** DBM 502 Week 1 Database Fundamentals (800 Words Paper) For more classes visit www.snaptutorial.com DBM 502 Week 1 Database Fundamentals ********************************************** DBM 502 Week 1 Discussion Data and Information For more classes visit www.snaptutorial.com

12. Respond to the following in a minimum of 175 words: Contrast the terms data and information. Use Figure 1-1 in Ch. 1, "The Database Environment and Development Process," of Modern Database Management as a starting point. Provide 2 examples of data and information from your own experiences. This may well lead to some differences of opinion and the conclusion that one person’s data may be another person’s information. ********************************************** DBM 502 Week 2 Discussion Entity Relationship Diagrams For more classes visit www.snaptutorial.com Respond to the following in a minimum of 175 words: Describe the benefits of using Entity Relationship Diagrams (ERDs) in database design, implementation, and documentation. What are some of the tools that can be used to create ERDs? **********************************************

13. DBM 502 Week 2 Entity Relationship Diagram (100 % Score) For more classes visit www.snaptutorial.com DBM 502 Week 2 Entity Relationship Diagram ********************************************** DBM 502 Week 2 Team Database Roles For more classes visit www.snaptutorial.com Learning Team: Database Roles Review the Learning Team Project Instructions. Write a 2- to 3-page paper describing the organization's staffing needs relative to database and application development, and database administration. The team needs to agree on the staff positions to use. From there, they must decide on a job description for each position

14. including expected education and certifications, required skills, experience, and expected pay range. All of these should be supported by references (including information from salary surveys or the Occupational Outlook Handbook to show that pay ranges are reasonable). In this week's paper, the team must make a partial submission of the final report that will: • Identify the role(s) assumed by each team member. • Describe each position, including title, job description, required education and/or certification, expected experience, skills required, pay range, and one or more questions to ask candidates during the interview. There should be enough positions to handle the major activities in database development and administration. Each description should identify the organizational role that is responsible for the position and the author of the description in that role (e.g., the DBA from the database administration role, or a business analyst from the user/stakeholder or application team). Submit your assignment using the Assignment Files tab. ********************************************** DBM 502 Week 3 Discussion SQL Server For more classes visit www.snaptutorial.com

15. Mertel Insurance is implementing a Microsoft® SQL Server® database that will track customer information, policy information, and transaction histories. The biggest concern is providing access to the information each team needs. Sales representatives need to access customer information to better serve their clients. Claims representatives must access policy information to determine coverage. Supervisors would like to access transaction histories to monitor employee performance. Compliance officers often must gather different and varied information for various regulatory agencies. Mertel executives want to monitor key metrics stored in the database to gauge company performance. Respond to the following in a minimum of 175 words: What methods do you recommend that Mertel Insurance use to retrieve information from its databases? Will you use a custom application or a more generic tool like SAP® BusinessObjects™ or Microsoft Excel? Would a team of analysts be in charge of running reports and distributing the information? Will the same approach work for all the users? Defend your recommendation. ********************************************** DBM 502 Week 3 IndividualDDL andSQL For more classes visit www.snaptutorial.com

16. Individual: DDL and SQL Assignment Using the model you defined in Week Two, provide the Data Definition Language (DDL) needed to create tables, attributes, primary and foreign key constraints, any other constraints needed on a single attribute or across attributes to ensure only valid data is entered, and indexes or other structures needed to make the performance adequate for the common and urgent operations. Write the SQL code to perform each of the common and needed activities. Explain how you expect it to use the defined structures efficiently. Describe what tools would be available in a commonly used database to determine if the database is following the execution plan you envision. Combine all items and submit in a 1- to 2-page APA formatted paper. Submit your assignment using the Assignment Files tab. ********************************************** DBM 502 Week 3 Team Database Design Standards For more classes visit www.snaptutorial.com Learning Team: Database Design Standards

17. Review the Learning Team Project Instructions. Create database design standards and validation approaches for the organization. This needs to include how the design would be checked from each perspective, with each role again contributing according to its interests (for example, the administration group according to their standards for performance, the users describing how they will validate that the database will be able to contain the information that they require, the development teams that they will be able to write the expected transactions relatively easily, which might depend on the degree of normalization, the application team that any data they need for managing the interface is covered, etc.). Write a 1- to 2-page paper explaining how the standards and approaches defend the interests of each of the roles. Submit your assignment using the Assignment Files tab. ********************************************** DBM 502 Week 4 Database Validation Plan For more classes visit www.snaptutorial.com Learning Team: Database Validation Plan

18. Create a 1- to 2-page paper defining the standards and approaches for the validation of database and application code. These include coding standards, expectations for what has been checked at each stage of testing (unit test, system test, user test), expectations for code review or inspection, etc. While QA plays a big role here, all roles are expected to contribute (development teams for unit test standards, DBAs for performance, users for acceptance testing, etc.). Submit your assignment using the Assignment Files tab. ********************************************** DBM 502 Week 4 Database Warehouse and Historical Data (100% Score) For more classes visit www.snaptutorial.com DBM 502 Week 4 Database Warehouse and Historical Data (100% Score) ********************************************** DBM 502 Week 4 Discussion Database Administration

19. For more classes visit www.snaptutorial.com Respond to the following in a minimum of 175 words: Compare and contrast the roles of database administrators and data stewards in an organization. What responsibilities do both have in order to meet data management, quality, and governance standards? ********************************************** DBM 502 Week 5 Discussion Data Warehouse For more classes visit www.snaptutorial.com Respond to the following in a minimum of 175 words: Describe how business intelligence can help an organization monitor, manage, and make decisions for its business. How are data integrated via the use of data warehouses and data marts?

20. How will the increasing trend to use cloud-based databases impact your thinking? ********************************************** DBM 502 Week 5 Historical Data Paper For more classes visit www.snaptutorial.com Explain the technology and approach you would use to handle the needs for studying historical trends in the information you have collected, combining it with other databases if needed. What information from the database would you collect over time? Define a star model for a data warehouse for this information. What information will you store in the fact tables? What attributes will it have? What dimension tables will you create? How will you organize the dimension tables? What physical structures (e.g., specialized indexes) will you use to make the data warehouse efficient? Explain, at a level suitable for business management, what they will be able to find out using this, both by breaking down information according to one or more dimensions, or drilling down on individual cells. Combine these items and submit in a 1- to 2-page APA formatted paper. **********************************************

21. DBM 502 Week 5 Team Database Administration Standards For more classes visit www.snaptutorial.com DBM 502 WEEK 5 ASSIGNMENT 1 Assignment 1 Learning Team: Database Administration Standards Create standards for database administration. This should include how performance will be monitored and tuned, how backups will happen, how data quality will be monitored and improved, how information should be secured, etc. The administration role is major here, but development roles will need to contribute on where they can build in ongoing monitoring, and all roles have an interest in database quality and recovery. From a user perspective, the standards should make clear how all of the standards are important to the business. Submit in a 1- to 2-page APA formatted paper using the Assignment Files tab. ********************************************** DBM 502 Week 6 Big Data Paper (14 Pages)

22. For more classes visit www.snaptutorial.com 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. Write an additional 1- to 2-page paper based on the following information: Management 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”) can be used to find unexpected gems in all of the data that they have been collecting, whether or not it is structured. Are 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 Review 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: Explained the role of data in information systems and business Distinguished between the three types of data management in modern organizations

23. Explained the meaning of key data management questions and the importance of the answers Explained the environment, roles, and skills needed to support transactional data management, including relational database environment, database designers, database developers, and database administrators Explained and applied techniques for deciding what data you need for transactional data management, including: entity relationship modeling and conceptual design Demonstrated how to use DML to enter information into relational databases Explained how to use SQL to extract rows and columns of data from tables and combine data from multiple tables, using SELECT Distinguished 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 Explained why database and information security is important to an organization Explained how database administrators and developers can protect the integrity and confidentiality of data against internal and external attacks Explained how database administrators can protect data integrity against system and hardware outages Explained the roles, skills, and tools needed for managing historical data via data warehouses Explained how to select, clean, and bring data of interest into a data warehouse Demonstrated 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) Explained the skills and environments required for analytic data Described how those tools are used Explained the business value of analytic results, such as data visualization and finding and applying patterns

24. ********************************************** DBM 502 Week 6 Discussion Big Data and Analytics For more classes visit www.snaptutorial.com Respond to the following in a minimum of 175 words: How can Hadoop and associated technologies, like Hive and Pig, be used to manage big data within an organization? How can the use of data analytics and using languages like R and Python help an organization in tangible ways? ********************************************** DBM 502 Week 6 Team Executive Presentation For more classes visit www.snaptutorial.com

25. Learning Team: Executive Presentation Combine the work from the preceding weeks. If not already done, make sure that the interests of each role are considered, and, where important, explicitly described for each area. Create a 7- to 10-slide presentation. Include videos, audio, photos, diagrams, or graphs as appropriate. Include substantial speaker notes, or insert audio narration into your presentation. Explore the Microsoft® PowerPoint® website to locate instructions on recording audio, for an executive audience. Your goal is to convince them that by recruiting according to the job descriptions and following the standard, the organization will be able to deliver effective, reliable data management support to meet business needs. Submit your assignment using the Assignment Files tab. **********************************************