Design an implementation approach for the database design process to the Kelsey Elementary School.
letgeo
team_b_kelsey_elementary_school_database_project.xlsSheet1
| Task | Start Date | Completion Date | Responsible Team Member |
| Define the business goals, objectives, and needs that the database management system will meet in Kelsey Elementary School. | 2/19/20013 | 2/25/13 | Val |
| Create a staffing model to support database administration and development in the IT organization. | 2/19/13 | 2/25/13 | Derrick |
| Document the use of a Microsoft® Visio® diagram as an entity relationship diagram (ERD) modeling tool for the IT orgainization. | 2/19/13 | 2/25/13 | Derrick |
| Define the standards, polices, and practices that the Kelsey Elementary School should put in place to use a Microsoft Visio diagram for ERD within the orgainzation. | 2/26/13 | 3/4/13 | Tavie |
| Design an implementation approach for the database design process to the Kelsey Elementary School. Include recommendations on how the Kelsey Elementary School should design and implement these processes and approaches. Ensure that the processes and approaches that you recommend address the phases of the database design process, including the following: o Conceptual design of the database • Data analysis and requirements • Entity relationship modeling and normalization • Data model verification • Distributed database design | 2/26/13 | 3/4/13 | George |
| o Database management system (DBMS) selection o What does a DBMS do? o Why did you pick this DBMS to meet the Kelsey Elementary School’s requirements? o How does the DBMS integrate with the rest of the technology infrastructure in the organization? | 2/26/13 | 3/4/13 | George |
| • Define integrity and security measure. • Determine performance measures. • Define backup and recovery processes. | 2/26/13 | 3/4/13 | John |
| o How the organization will meet database application and reporting requirements | 2/26/13 | 3/4/13 | John |
| A team progress report to your instructor explaining what your team accomplished during the week, challenges your team faced, and questions. | 3/5/13 | 3/11/13 | Val |
| Draft the following for Kelsey Elementary School's Database • Logical database design • Physical database design • How the organization will meet database application and reporting requirements | 3/5/13 | 3/11/13 | Tavie |
| Compile final paper. Write your paper and presentation for an executive audience. Include justification, rationale, advantages, and examples to support the analysis and recommendations that your team is presenting to senior management in your team’s paper and presentation. | 3/12/13 | 3/18/13 | Tavie |
| Design a power point reflecting database project. | 3/12/13 | 3/18/13 | Val |
Val:
