DBM 502 Education for Service--tutorialrank.com

1. DBM 502 Apply Team Week 4 Data Models For more course tutorials visit www.tutorialrank.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.

2. 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. ============================================== DBM 502 Apply Week 1 Database Management Plan Part 1 Storing and Extracting Information For more course tutorials visit www.tutorialrank.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.

3. 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. 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 course tutorials visit www.tutorialrank.com

4. 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 For more course tutorials visit www.tutorialrank.com Read the following sections of “Case Forondo Artist Management Excellence Inc.” on p. 51 of Modern Database Management: “Case Description”

5. “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.

6. 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 course tutorials visit www.tutorialrank.com Based on your previous work in the previous week, create a 700-word entry in your Database Management Plan.

7. Ensure you: 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

8. For more course tutorials visit www.tutorialrank.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: 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

9. For more course tutorials visit www.tutorialrank.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 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:

10. 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 course tutorials visit www.tutorialrank.com 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.

11. 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.

12. 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. Include videos, audio, photos, diagrams, graphs, (as appropriate) and substantial speaker notes or audio narration in your presentation. Submit your assignment. ============================================== DBM 502 Week 1 Discussion Data and Information For more course tutorials visit www.tutorialrank.com

13. 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 course tutorials visit www.tutorialrank.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?

14. ============================================== DBM 502 Week 3 Discussion SQL Server For more course tutorials visit www.tutorialrank.com 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?

15. 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 4 Discussion Database Administration For more course tutorials visit www.tutorialrank.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? ==============================================

16. DBM 502 Week 5 Discussion Data Warehouse For more course tutorials visit www.tutorialrank.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? How will the increasing trend to use cloud-based databases impact your thinking? ============================================== DBM 502 Week 6 Discussion Big Data and Analytics For more course tutorials visit www.tutorialrank.com

17. 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? ==============================================