FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Logical data modeling belongs to the entity relationship model, built using an Entity Relationship Diagram (known as ERD), a standard modeling technique used as a communication tool by data modelers worldwide. Within it are the complete set of business requirements but not technical components.

Detailed explanation-2: -The logical data model is an abstract representation of a possible implementation, without being bound to any specific implementation, while the conceptual data model is a high level representation of the business requirements and the connected data sets and relationships.

Detailed explanation-3: -A conceptual data model is the highest level, and therefore the least detailed. A logical data model involves more detailed thinking about the implementation without actually implementing anything. Finally, the physical data model draws on the requirements from the logical data model to create a real database.

Detailed explanation-4: -Logical design is used to refer to the task of creating conceptual data model. It is maps the conceptual model to the DBMS. The internal model is the representation of the database as"seen"by the DBMS also it called the internal schema.

Detailed explanation-5: -A logical design is a conceptual, abstract design. You do not deal with the physical implementation details yet; you deal only with defining the types of information that you need. The process of logical design involves arranging data into a series of logical relationships called entities and attributes.