Birchwood Lane Schools Proposal is responsible for each area of focus By also

Birchwood lane schools proposal is responsible for

This preview shows page 4 - 8 out of 14 pages.

Birchwood Lane Schools Proposalis responsible for each area of focus. By also giving access to state and federal regulators of the school district, time is saved for them by less travel being required to Birchwood Lane Schools to view and investigate the current operations the school system in running. This would also allow upper management to review current operations from a far.Database DesignThe database model that I have designed identifies three entities. They are Course, Student, and Instructor. I have labeled the Primary keys as next to the attributes listed; StudentID, InstructorID, and CourseID. I have also included an area that is labeled CourseAssignment that shows the courses the teachers and students are participating in with foreign keys. The relationships that are connected to the students and teachers are call 1;M relationships. Along with providing a conceptual diagram, I have also included an entity-relationship diagram that shows the corresponding relationships with one another.By utilizing this approach and implemented correctly, Birchwood Lane Schools would have the ability to obtain the necessary information needed to improve their efficiencies, collect data to optimize their school’s performance while meeting and exceeding local, state, and federalregulations. 4
Birchwood Lane Schools Proposal5
Birchwood Lane Schools ProposalDatabase InformationThe database that I would recommend is Microsoft SQL Server Access 2016. The reasonfor recommendation is because I believe it is the most user friendly for all parties involved, it hasan excellent data migration checklist to help with planning for a project within the school system that may take place down the line when Birchwood Lane Schools is looking to improve in any area. The details regarding Microsoft SQL Server 2106 is as follows:Operating Information6
Birchwood Lane Schools ProposalComponentRequirement.NET FrameworkSQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework from .For more information, recommendations, and guidance about .NET Framework 4.6 see .Windows 8.1, and Windows Server 2012 R2 require before installing .NET Framework4.6.Network SoftwareSupported operating systems for SQL Server 2016 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA.Note: Shared memory and VIA are not supported on failover clusters.Also, note that the VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture