What is a database conceptual design?
Database design involves identifying existing relations between separate parts of data and mapping these relationships in an organized way that makes sense. There are several types of database design: Database conceptual design, logical database design and physical database design. The logical and physical database is possible. The conceptual design of the database is slightly most clear because there is no direct work on the database model during this phase. This process is only an exercise when identifying relevant data. Here is the central idea of the design of the conceptual database: the model of the relationship of entity. This does not apply to the overall organization and structures its own design of a logical database; But he is the predecessor. Cardinitation expresses how regularly the entity experiences a specific relationship with another entity. In the actual model, the points in which the entity on the diagram branches to connect to individual or more entities. The model shows various "attributes" such as names, characteristics and quantity connectedwith entities and relationships.
Final considerations in the development of Entity-Relationship for Database Conceptual Design include the assignment of each observed attribute of a particular domain and double control to ensure that everything in the model makes sense. Control of everything means the finding and filtering of everything repeatedly, ensuring that all attributes are associated with the right entities and relationships, and confirming that all associations in the diagram are logical. If the connection is not logical in the context of the real world, it must be logical at least at an abstract level.
The design of the logical database monitors in the conceptual phase. This process gives these relationships and cohesion that they previously mapped, and organizes them in such a way that they can actually be used to design a physical database. Completion of tasks in the design of a physical database results in a database that is functional and well structured in the light of work done inDesign of conceptual database and design of a logical database.