Description
The purpose of this assignment is to build upon your database project proposal by creating the database schema components. A schema is a logical grouping of database objects, such as tables, indexes, views, and queries that are related to each other.
To complete Part 2 of the Database Project Proposal assignment, write a 750-1,000-word essay that contains the following information:
Restate your database project; describe its goal and objectives.
Describe the purpose of the database schema for your project.
Write out the process associated with your business rules relating to your database.
Create a data dictionary that contains no less than five entities. Select and design an entity-relationship diagram (Crow, Chen, UML); Note: There are a variety of ER modeling software programs on the market. Microsoft Visio, OmniGraffle, LucidChart, and MySQL are few of these programs that provide free trials to create entity-relationship diagrams. In addition, you can simply create diagrams by utilizing Microsoft Word, PowerPoint Shapes, or SmartArt.
Focus on one or two areas of your design that seemed especially difficult to develop and provide a brief assessment of the difficulty you encountered in modeling.
Discuss the project’s limitations and possible extensions.
This is an ongoing project and feedback from the instructor at every stage will help you to improve your final project.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
