Database Analysis and Design

Description

Instructions: Submit the conceptual model, logical model, and physical database design for your solution to the selected scenario. For additional details, please refer to the Final Project Guidelines and Rubric document and the Milestone Two Rubric document.Submit the preliminary design of the database for the final project. Devise a conceptual model that will best address the case study scenario you selected for the final project. Your model should include all necessary entities, relationships, attributes, and business rules. Based on the conceptual model, illustrate a logical model for your DBMS that accurately represents all necessary aspects of the DBMS to address the solution. Create a physical database design that builds on the nonphysical (conceptual and logical) models you crafted. This design includes the conceptual and logical models of the database, as well as the physical design of the database. Specifically, the following critical elements must be addressed: Analysis and Design A. Conceptual Model: Based on the business problem or challenge, devise a conceptual model that would best address the problem. Your model should include all necessary entities, relationships, attributes, and business rules. B. Logical Model: Based on the conceptual model, illustrate a logical model for your DBMS that accurately represents all necessary aspects of the DBMS to address the solution. C. Physical Design: Create a physical database design that builds on the nonphysical (conceptual and logical) models you crafted. Guidelines for Submission: Your paper must be submitted as a 6- to 12-page Microsoft Word document using appropriate modeling language and/or diagrams. It should use double spacing, 12-point Times New Roman font, and one-inch margins. It should include at least three sources, which should be cited in APA format