Assignment
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.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.
Attachment:- Project-Case-Study-Scenarios.rar