The purpose of this assignment is to build upon your database project proposal in 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 will give 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.
0 comments