You 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.
page3image3665788640
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 the
discipline.