Design a database schema for the “Relational Database Design Proposal”. Identify and list all relevant entities and their relationships: Select no less than five entities. provide a diagram.
Design a database schema for the “Relational Database Design Proposal”. Identify and list all relevant entities and their relationships: Select no less than five entities. provide a diagram. Map this to a database schema. 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. Tip: If you do not have access to ER modeling software or a diagramming tool like Visio or OmniGraffle, you can simply create diagrams in a presentation tool like PowerPoint. This is an essential skill which is used in the field.
