IT 204 Final Project Guidelines and Rubric
The final project for this course is the creation of a database proposal and implementation plan report that will address the needs of a given scenario. The purpose of this assessment is to assess the students’ understanding of simple database structure, 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 the development of a strategy for implementing that database. Your submissions will include the relational database model you have designed, including diagrams (e.g., Microsoft Visio), a plan for implementation, and a persuasive presentation to stakeholders, in this case the Birchwood Lane School Board. The persuasive presentation will build off the work completed for this database proposal and implementation plan report and is due in Module Eight. For more details about the presentation, reference the “Final Presentation Guidelines and Rubric” document in the Assignment Guidelines and Rubrics section of the course.
The project is supported by four formative milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. 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.
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.
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 management
- Present database management proposals in a persuasive manner given the needs of specific audiences
You will be developing your submissions (a relational database model, and plan for implementation) around 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, course, and instructor data electronically. You will design a DBMS model and develop a strategy for implementation, which you will flesh out in a comprehensive written report.
Current data needs 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, each student may be enrolled in multiple courses during a term, and each instructor may teach multiple courses during a term.
Specifically, the following critical elements must be addressed in your submission:
- Case Needs Analysis: Determine the data requirements of Birchwood Lane Schools.
- What data from the scenario is needed for the database and why?
- To what extent is additional information needed to develop complete data requirements? II. Relational Database Model
- Based on the requirements you have determined, design a relational database model. Be sure to include applicable entities and proper relationship mapping.
- Develop a logical database model based on the entities present in your visual conceptual database model.
- Database Selection: Select an appropriate DBMS (Oracle, IBM DB2, MS SQL Server, or an open-source database) for Birchwood Lane Schools and explain your reasoning.
- Why did you choose this DBMS? Be sure to lists all uses, benefits, and limitations for each of the following: data size limit, purchase cost, administration, operating system/hardware and requirements, features, and performance/scalability. What differentiates your selection from other selections?
- To what extent are there additional or alternative technologies that might assist Birchwood Lane Schools in managing its data? Compare these technologies in terms of their applicability to the needs of Birchwood Lane Schools.
- Implementation Plan: Outline a process for implementing the new database.
- Be sure to include all relevant information and steps.
- Are there additional pieces of information necessary to develop a full plan for implementation or that may impact implementation success? For example, these could include DBMS management requirements, man hours, or data input.