Hands-On Database describes four scenarios: Wild Wood Apartments, Vince’s Vinyl, Grandfield College, and Westlake Research Hospital. Choose one of the four scenarios. You will use your chosen scenario to complete all scenario tasks throughout the course. Each scenario task has you complete the “To Do” activities described at the end of certain chapters in Hands-On Database.

 

Specifically, the following critical elements must be addressed:

 

 Completeness: The submission is complete and includes responses (as appropriate) for each element of the scenario activity.

 

 Correctness: The responses are correct and thoroughly respond to each element of the scenario activity.

 

 Critical Analysis: The responses exhibit critical analysis by clearly stating the response to each element of the scenario activity and providing evidence to support the response.

 

 

 

Week 2

 

Based on your selected scenario from Hands-On Database, complete the “To Do” activities described at the end of Chapters 2 and 3 of the textbook. Your response should be submitted as a Word document.

For additional details, please refer to the Scenario Rubric document in the Assignment Guidelines and Rubrics section of the course.

 

Milestone 1

 

Begin working on your final project by selecting one of the scenarios provided for the final project. Using the selected scenario, analyze the organization to determine the problem/challenge, business requirements, and limitations of the current system(s). Explain how the problem or challenge impacts the various departments and operations within the organization.

For additional details, please refer to the Final Project Guidelines and Rubric document and the Milestone One Rubric document in the Assignment Guidelines and Rubrics section of the course.

 

Milestone One Rubric   Submit an analysis of the organization that will use the database developed for the final project. Select one of the scenarios provided for the final project. Using the selected scenario, analyze the organization to determine the problem/challenge, business requirements, and limitations of the current system(s). Explain how the problem or challenge impacts the various departments and operations within the organization.

 

Specifically, the following critical elements must be addressed:

 

 Organization A. Problem: Analyze the organization to determine the problem/challenge, business requirements, and limitations of current system(s). B. Departments and Operations: Explain how the various departments and operations within the organization are impacted by the issue or challenge.

 

Guidelines for Submission: Your paper must be submitted as a three- to five-page Microsoft Word document using appropriate modeling language and/or diagrams. It should use double spacing, 12-point Times New Roman font, and one-inch margins. It should include at least three sources, which should be cited in APA format.

 

Milestone Two Rubric

 

Submit the preliminary design of the database for the final project. Devise a conceptual model that will best address the scenario you selected for the final project. Your model should include all necessary entities, relationships, attributes, and business rules. Based on the conceptual model, illustrate a logical model for your DBMS that accurately represents all necessary aspects of the DBMS to address the solution. Create a physical database design that builds on the nonphysical (conceptual and logical) models you crafted. This design includes the conceptual and logical models of the database, as well as the physical design of the database.

 

Specifically, the following critical elements must be addressed:

 

 Analysis and Design A. Conceptual Model: Based on the business problem or challenge, devise a conceptual model that would best address the problem. Your model should include all necessary entities, relationships, attributes, and business rules. B. Logical Model: Based on the conceptual model, illustrate a logical model for your DBMS that accurately represents all necessary aspects of the DBMS to address the solution. C. Physical Design: Create a physical database design that builds on the nonphysical (conceptual and logical) models you crafted.

 

Guidelines for Submission: Your paper must be submitted as a 6- to 12-page Microsoft Word document using appropriate modeling language and/or diagrams. It should use double spacing, 12-point Times New Roman font, and one-inch margins. It should include at least three sources, which should be cited in APA format.

 

Milestone Three Rubric

 

Research the various database management system (DBMS) products available for your scenario and compare the top contenders to highlight similarities and differences. Analyze these database products for their appropriate uses, strengths, and weaknesses in comparison with the needs of your organization. Recommend and defend the best DBMS product(s) for fully addressing the broad, high-level technological and operational needs of the organization. Recommend and justify needed software and hardware to fully meet operational applications in various departments. These will supplement the DBMS product you recommend to fully meet specific needs or requirements left open by the DBMS product.

 

Specifically, the following critical elements must be addressed:

 

 DBMS A. Research: Research the various DBMS products available for your scenario and compare the top contenders to highlight similarities and differences. Analysis: Analyze these database products for their appropriate uses, strengths, and weaknesses in comparison with the needs of your organization.  B. Recommendation: Recommend and defend the best DBMS product(s) for fully addressing the broad, high-level technological and operational needs of the organization.  C. Hardware, Software: Recommend and justify needed software and hardware to fully meet operational applications in various departments. These will supplement the DBMS product you recommend to fully meet specific needs or requirements left open by the DBMS product.

 

Guidelines for Submission: Your paper must be submitted as a five- to seven-page Microsoft Word document. It should use double spacing, 12-point Times New Roman font, and one-inch margins. It should include at least three sources, which should be cited in APA format.

 

Milestone 4

 

Submit a detailed data model of the database with analysis and justification based on a specific group or department within the organization. Select one particular group or department (such as Sales or Customer Service) within the organization in your chosen scenario from Hands-On Database. Then develop and illustrate a comprehensive enterprise data model for the selected group. Articulate the operating rules within the group to allow for an application model. Assess the extent to which your data model reflects the operating rules of the organization.

 

Specifically, the following critical elements must be addressed:

 

 Data Model: For the three sections of this element, you will focus on a particular group or department within the organization (such as Sales or Customer Service). A. Enterprise Data Model: Develop and illustrate a comprehensive enterprise data model for the selected group.  B. Operating Rules: Articulate the operating rules within the group to allow for an applicable model. C. Rule Reflection: Assess the extent to which your data model reflects the operating rules of the organization.

 

Guidelines for Submission: Your paper must be submitted as a four- to six-page Microsoft Word document using appropriate modeling language and/or diagrams. It should use double spacing, 12-point Times New Roman font, and one-inch margins. It should include at least three sources, which should be cited in APA format.

 

Milestone 5

 

 Submit the legal and ethical considerations relative to the database and includes a security plan that addresses the legal and ethical considerations. Articulate the relevant legal and ethical standards that need to be considered in your solution design and in future implementation. Determine the best practices in design, data use, and storage to ensure legal compliance. The regulations in place and the best practices for aligning operations will likely change depending on the type of industry in which your company resides. Support your conclusions with research support. Determine best practices in design, data use, and storage to ensure ethical operation of your company. These best practices will likely change depending on the industry in which your company resides. Support your conclusions with research support. In consideration of the type of organization you selected, the data used, and your consideration of legal and ethical standards, discuss the security needs of your DBMS solution. Considering the group/department for which you constructed your enterprise data model (Milestone Four), discuss the differences in security needs at this level in comparison with those of the company as a whole. Given the comparisons and discussions above, recommend a comprehensive but high-level (pertaining to the solution as a whole rather than the particular department) security management plan for your design that will align to organizational needs. 

 

Specifically, the following critical elements must be addressed: 

 

 Law, Ethics, and Security A. Standards: Articulate the relevant legal and ethical standards that need to be considered in your solution design and in future implementation. Legal Compliance: Determine the best practices in design, data use, and storage to ensure legal compliance. The regulations in place and the best practices for aligning operations will likely change depending on the type of industry in which your company resides. Support your conclusions with research support.  B. Ethical Practices: Determine best practices in design, data use, and storage to ensure the ethical operation of your company. These best practices will likely change depending on the industry in which your company resides. Support your conclusions with research support.  C. Security Needs of Solution: In consideration of the type of organization you selected, the data used, and your consideration of legal and ethical standards, discuss the security needs of your DBMS solution. Considering the group/department for which you constructed your enterprise data model, discuss the differences in security needs at this level in comparison with those of the company as a whole. D. Database Security Plan: Given the comparisons and discussions above, recommend a comprehensive but high-level (pertaining to the solution as a whole rather than the particular department) security management plan for your design that will align to organizational needs.