Edit database schema(attached) with solid academic writing for all question listed below
I have written ER diagram and data dictionary. add mapping to database schema.
Also provide detailed explaination of each topic with examples(references and text citation)
Identify and list all relevant entities and their relationships:
1) Select no less than five entities.
2) Provide a diagram.
3) Map this to a database schema.
4) Provide a data dictionary for all entity attributes.
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 or mapping to the schema. In addition, provide the rationale for the design chosen, its limitations, and its possible extensions.
Sample Solution