The Scenario: You will be developing your submissions (a relational database mod

Question

The Scenario:

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.

Question:

This week, you are going to discuss the business case for the final project. A business case is an analysis and explanation of why a business is initiating a venture, initiative, project, or task. The business case typically includes a gap analysis that explains how the proposed initiative will address needs in current conditions, leading to a future state that is a significant improvement over the present. The “gap” is the difference between the current and future states

The final project for this course involves a DBMS project for Birchwood Lane Schools. In this group discussion, you will work with your group mates to consider the business case for this project. Explain your perspective on the need for the new approach to managing data via a database management system and modeling data according to standards. Why does Birchwood Lane Schools need a database? Next, begin to develop ideas for a relational data model that responds to the business case.

Thank you!

Explanation / Answer

Birchwood Lane Schools is in need of a assistance to meet state and federal requirements for schools. Current state and federal requirements include an application system that records all student, course, and instructor data electronically. The best way to accomplish this task first requires a comprehensive database management system (DBMS) model to ensure all necessary data is included. Following thorough analysis of the needs of the Birchwood Lane School System, the following report includes recommendations to fully implement the system

He administration has indicated the current data needs that must be included. For students, the following need to be included: full name, full address, phone, email, birth date, enrollment date, graduation date, courses taken, and courses currently enrolled in. This information will need to be kept up to date and will all be attributes for the student entity. For the entity instructors, the following attributes are necessary: full name, full address, phone, email, birth date, hire date, courses taught, and courses currently assigned. And finally, the following attributes are needed for the course data entity: course name, course start date, course end date, course category, instructor, and students. This information must be included in the records in order to pull up transcripts for students and to aid in scheduling of courses with the appropriate instructors. It is also necessary in order to properly maintain communication between schools and students, as well as between colleges that may be seeking information regarding students. In order to avoid needing to further alter the system in the future, there are additional attributes that would be beneficial to include. For students, cumulative grade point average, courses needed, and clubs/sports would allow further benefits to the school. When pulling up reports on each student, to see what courses they still need to take would allow a comprehensive academic learning plan to be stored and followed. Prospective colleges also seek out information from schools regarding students and the additional attributes would allow that information to be readily found and reported. It would also be useful for the database to contain unique IDs for students, courses, and teachers.

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

Over the last few months, our staff has worked closely with your team, and has allowed for us to develop profound insight into the needs of the Birchwood Lane School District. Your educators have perfected the art of education, and our years of experience and technical expertise has allowed us to craft a sciatic solution which will allow the art and science of education to merge once more. The deployment of a modern database system not only ensures that the Birchwood Lane School District will maintain a competitive advantage for years to come, but will unify the system as a whole. We propose...

• MySQL Utilization: MySQL is the leading open source database management software.

•Creation database stored in the “cloud.”

•Costs are greatly reduced with the utilization of a cloud based system.

•Database optimization for utilization with mobile devices.

•Deployment of the said database is guaranteed to ensure a minimum of 5 years of operational functioning.

•System will be easily scalable.

•Positive long-term cost of deployment, resulting from increased efficiency in record keeping and minimal cost of maintenance.

•System wide training for Birchwood personnel, to ensure adequate understanding of the proposed system.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.