The Entity-Relationship (ER) model was originally proposed by Peter in 1976 as a way to unify the network and relational database views. Simply stated the ER model is a conceptual data model that views the real world as entities and relationships. A basic component of the model is the Entity-Relationship diagram which is used to … Read more
Database design is defined as: “design the logical and physical structure of one or more databases to accommodate the information needs of the users in an organization for a defined set of applications”. The design process roughly follows five steps: 1. Planning and analysis 2. Conceptual design 3. Logical design 4. Physical design 5. Implementation … Read more
A data model is a conceptual representation of the data structures that are required by a database. The data structures include the data objects, the associations between data objects, and the rules which govern operations on the objects. As the name implies, the data model focuses on what data is required and how it should … Read more