The final project for this course is the design and proposal of a database management system (DBMS) solution. You will select a case study from those provided, analyze the organizational issues and needs, and work your way through the conceptual, logical, and physical designs of a DBMS solution. This will require substantial research of best practices in design, available products, and the legal and ethical standards to which you must adhere during design. The skills required in this assessment will be valuable in the role of an IT manager or DBMS professional, as these individuals are often tasked with developing solutions to various organization data problems while also adhering to legal, ethical, and financial considerations. The ability to craft and present professional and logical proposals will also be expected of IT professionals, especially those at the management level. You will use Visio or a comparable tool to illustrate design models and will also have access to Microsoft SQL for implementation of the DBMS design or solution. While the length of the proposal will depend on many factors (including the type of organization, the scope of the identified challenge, and operational requirement differences), it should be long enough to address all aspects of the prompt accurately and comprehensively without unnecessary detail. The project is divided into four 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, Four, Five, and Seven. The final submission will occur in Module Nine.

Please see the attachment