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.

Database Project Proposal – Part 2

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, Omni Graffle, Lucid Chart, 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 Smart Art.

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