Introduction to Entity Relationship Diagrams

Databases

This assignment on developing and interpreting Entity Relationship Diagrams has the following learning outcomes:

●Design an Entity-Relationship diagram, given the requirements of an information system.

●Identify entities, constraints and relationships captured by an entity relationship diagram


●Design an information system and rationalize said design in a manner that enables a software engineer to implement the design in a relational database system.

●Apply the practice of information modeling in a situation similar to those seen in the industry.

This is an individual assignment.

Sriram Mohan

ER Diagram

One Week

Writing

Design

As a software engineer you will often be required to design information systems based on a client’s requirements. It is your responsibility to ensure that the information system has the ability to store the required data in an efficient manner without any duplication. The ER diagram is an industry standard and provides a visual representation of the database design. The ER diagram is the focal point of communication with the client and should be easy to read, modify and capture all the constraints to be represented in the database.

N/A