Main Concepts of ER Models . The ER or (Entity Relational Model) may be defined as a high-level conceptual data model diagram. Entity-Relation model is based on the notion of real-world entities and the relationship between them.
ER modeling helps you to analyze data requirements systematically to produce a well-designed database. So, it is considered a best practice to complete ER modeling before implementing your database.
How do you design an ER Model using Oracle SQL Systems?
- The E-R model with attributes and relationships. You can draw the model using any tool you wish, including hand-drawn.
- The results of your normalisation – show all normal form stages
- Include any supplementary descriptions/notes/assumptions/discussion to strengthen your proposed design of the system.