IT 204 SNHU MySQL Database Proposal and Implementation Report
IT 204 Final Project Guidelines and Rubric Database Proposal and Implementation Plan ReportOverviewThe final project for this course is the creation of a database proposal and implementation plan report that will address the needs of a case scenario involving Birchwood Lane Schools. The purpose of this project is to assess your understanding of data models, simple database structures and functions, and terminology from an information management perspective.You are to design a simple database framework that addresses the needs of Birchwood Lane Schools, and to develop a strategy for implementing that database. Your deliverables for this project will include the relational database you have designed, including the conceptual and logical diagrams (e.g., Microsoft Visio), a narrative addressing the database selection and justification, as well as a plan for implementation.The project is supported by four milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality of the final submission. These milestones will be submitted in Modules Two, Three, Four, and Five. The final submission of your database proposal and implementation plan report will occur in Module Seven.It is important to note that at the end of your degree program experience, you will develop a portfolio that will provide a clear representation of your mastery of program outcomes, skills, and abilities. The artifact that is suggested for use from this course is the case needs analysis section of your proposal and plan. It is strongly recommended that you save this document in a place where it can be accessed again at a later date.Outcomes This assessment will evaluate your mastery with respect to the following course outcomes:● Apply the appropriate terminology of the realm of data and information management to real-world scenarios● Develop and address complete and valid data requirements for business cases● Design and plan to implement a simple relational data model using standard database management methods● Differentiate between the uses, benefits, and limitations of commonly used tools and technologies in data and information managementPromptYou will be developing your project and its critical elements based on the following scenario:Birchwood Lane Schools currently records all student, instructor, and course data on paper. To meet state and federal requirements, Birchwood Lane Schools must implement an application system that records all student, instructor, and course data electronically.You will design a relational database and develop a strategy for implementation, which you will fully document in a comprehensive written report. Current data requirements include the following:Student data (full name, full address, phone, email, birthdate, enrollment date, graduation date, courses taken, courses currently enrolled)Instructor data (full name, full address, phone, email, birthdate, hire date, courses taught, courses currently assigned)Course data (course name, course start date, course end date, course category, instructor, students)Each student and instructor may have multiple addresses and may be enrolled in multiple courses during a term. Each instructor may teach multiple courses during a term.Specifically, the following critical elements must be addressed in your submission:Introduction: Based on the given scenario you were provided:Summarize the data and information requirements of the business case and client needs using appropriate data and information managementterminology.Briefly explain the purpose of the database management system (DBMS) used and the importance of a database in meeting the requirements.Business Case and Gap Analysis: Analyze the client needs and how the project will address them. This type of analysis identifies the difference between a current condition and future state (i.e., gap analysis). Based on the scenario showing the current system the school has in place to collect data:What information should be included in the new database solution to address the current state? Why?What additional information is needed to complete the business case data requirements and achieve the desired future state?Relational Database Model: Based on the scenario and the information from your introduction and your analysis:Design a basic relational database visual diagram with entities, attributes, and relationships based on the requirements you have identified. Be sure to include proper relationship mapping.Create a conceptual data model visual diagram and a logical data model visual diagram based on the entities present in your visual conceptual database.Database Selection: Select an appropriate DBMS (Note: Refer to Milestone Four to help you with this area) to recommend for Birchwood Lane Schools (Oracle, IBM DB2, MS SQL Server, or an open-source database) and explain:A. Why did you choose this DBMS? Be sure to lists all uses, benefits, and limitations for each of the following: data size limits, purchase cost, administration, operating system/hardware requirements, features, and performance/scalability.Explain what additional or alternative technologies might assist Birchwood Lane Schools in managing its data.Comparatively evaluate these technologies in terms of their applicability to the needs of Birchwood Lane Schools.Implementation of Relational Database Model: In outline format, recommend a step-by-step process for implementing the new database.Include relevant information and steps necessary for implementing the new database model.What additional pieces of information are necessary to develop a full plan for implementation or may impact implementation success? Forexample, these could include DBMS management requirements, man hours, or data input.Closing Statement: Articulate the importance of an electronic DBMS versus Birchwood’s traditional paper method using appropriate terminology for thediscipline.MilestoneMilestonesRefer to the Guidelines and Rubrics folder to review the rubrics for each project component DeliverablesModule DueTwo ThreeFour FiveSevenGradingGraded separately; Discussion Rubric Graded separately; Discussion RubricGraded separately; Milestone Three Rubric Graded separately; Milestone Four RubricGraded separately; Final Project Rubric (in this document) One Group Discussion: Defining the AudienceTwo Group Discussion: Business Case for the DBMS ThreeProposal Draft Four Database Management System SpecificationsFinal Submission: Database Proposal and Implementation Plan Report Final Project RubricGuidelines for Submission: Written components of the project must follow these formatting guidelines when applicable: double spacing, 12-point Times NewRoman font, one-inch margins, and APA citations. The written proposal report must be between 5 and 10 pages, not including cover page, diagrams, or resources.Critical Elements Exemplary (100%) Proficient (85%) Needs Improvement (55%) Not Evident (0%) Value Introduction: RequirementsMeets “Proficient” criteria and demonstrates keen insight into how the DBMS or data model will benefit Birchwood Lane SchoolsSummarizes the data and the information requirements of the business case and client needs using appropriate data and information management terminologySummarizes the data and the information requirements that are needed, but the summary lacks critical details related to the requirements or does not use appropriate data and information management terminology or contains inaccuraciesDoes not summarize the data and the information requirements that are needed7.92Introduction: PurposeMeets “Proficient” criteria, and demonstrates keen insight into how the DBMS or data model will benefit Birchwood Lane SchoolsBriefly explains the purpose of the DBMS used and the importance of a database in meeting the requirementsBriefly explains the purpose of the DBMS used and the importance of a database in meeting requirements, but explanation contains inaccuracies or is illogicalDoes not explain the purpose of the DBMS used and the importance of a database11.88Business Case and Gap Analysis: InformationMeets “Proficient” criteria, and explanation demonstrates keen insight on the information needed for the proposed database solutionIdentifies what information should be included in the new database solution to address the current state and explains reasoningIdentifies what information should be included to address the current state, but reasoning contains inaccuracies or is illogicalDoes not identify what information should be included to address the current state in the new database solution7.92Business Case and Gap Analysis: Additional InformationMeets “Proficient” criteria, and the description demonstrates keen insight into how the information from the scenario should be usedDescribes additional information needed to complete the business case data requirements and achieve the desired future stateDescribes additional information needed to complete the business case data requirements but lacks key details or contains inaccuracies in achieving the desired future stateDoes not describe additional information needed to complete the business case data requirements7.92Relational Database Model: Basic DiagramMeets “Proficient” criteria, and the relational database visual diagram is simply and intuitively organizedBasic relational database visual diagram clearly illustrates all applicable entities, attributes, and relationships based on the scenarioBasic relational database visual diagram clearly illustrates all applicable entities, attributes, and relationships based on the scenario but lacks key details or contains inaccuraciesBasic relational database visual diagram does not illustrate applicable entities, attributes, and relationships5.94Relational Database Model: Conceptual and Logical DiagramsMeets “Proficient” criteria, and the conceptual and logical visual diagrams are simply and intuitively organizedConceptual and logical visual diagrams clearly illustrate all applicable entities and attributes based on the scenarioConceptual and logical visual diagrams illustrate applicable entities and attributes based on the scenario but lack key details or contain inaccuraciesConceptual and logical visual diagrams do not illustrate applicable entities and attributes5.94Database Selection: ChooseMeets “Proficient” criteria, and the database selection reasoning evidences keen insight into the world of information technologyDatabase selection is supported with a comprehensive explanation of the uses, benefits, and limitationsDatabase selection is supported with a comprehensive explanation of the uses, benefits, and limitations, but explanation lacks key details or contains inaccuraciesDatabase selection is not supported7.92Database Selection: Additional or Alternative TechnologiesMeets “Proficient” criteria, and the database selection explanation demonstrates keen insight into additional or alternative technologiesExplains additional or alternative technologies that might assist in managing data needs of Birchwood Lane SchoolsExplains additional or alternative technologies that might assist in managing data needs of Birchwood Lane Schools, but explanation contains inaccuracies or is illogicalDoes not explain additional or alternative technologies7.92Database Selection: ApplicabilityMeets “Proficient” criteria, and the database selection evaluation demonstrates keen insight on additional or alternative technologiesComparatively evaluates additional or alternative technologies that might assist in managing data needs of Birchwood Lane SchoolsComparatively evaluates additional or alternative technologies that might assist in managing data needs of Birchwood Lane Schools, but comparison contains inaccuracies or is illogicalDoes not comparative evaluate additional or alternative technologies7.92Implementation of Relational Database Model: Information and StepsMeets “Proficient” criteria, and the information outline shows keen insight into the nuances of successful implementationIncludes all key relevant information and steps necessary for implementing the new databaseIncludes relevant information and steps necessary for implementing the new database but lacks key details or contains inaccuraciesDoes not include all key relevant information and steps necessary for implementing the new database5.94Implementation of Relational Database Model: Additional PiecesMeets “Proficient” criteria, and the implementation outline shows keen insight into the nuances of successful implementationDescribes additional pieces of information that are necessary to develop a full plan for implementation or that may impact implementation successDescribes additional pieces of information, but they may not be necessary to develop a full plan for implementation or impact implementation success or lacks key details or contains inaccuraciesDoes not describe additional pieces of information necessary5.94Closing StatementMeets “Proficient” criteria, and the use of industry-specific language effectively establishes expertise in addressing the business caseArticulates the importance of an electronic DBMS versusBirchwood’s traditional paper method using appropriate terminology for the disciplineArticulates the importance of an electronic DBMS versusBirchwood’s traditional paper method using appropriate terminology for the discipline but lacks key details or contains inaccuraciesDoes not articulate the importance of an electronicDBMS versus Birchwood’straditional paper method11.88Articulation of ResponseSubmission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy-to-read formatSubmission has no major errors related to citations, grammar, spelling, syntax, or organizationSubmission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideasSubmission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas4.96Total 100%