Hi, i'm making a database on mysql for a uni assignment. In the write up of the report i've been told to put in a logical model which can be done by identifying the relationships from a conceptual model. I know what a conceptual model is and have identified the relationships between entities, but I don't know what a logical model is and what it looks like! Can anyone help?
You already have the conceptual model, which defines the relationships between the entities you're modeling. A logical model addresses the organization of data within that model, i.e. what tables and fields will actually be created and how they relate to one another (the "Relationships" diagram in MS Access is one example). Then from there you create the physical model, which is the database itself.
Depending on who you ask, the difference between a conceptual model and a logical model can be rather blurry. I prefer to keep the conceptual model on the semantic side of things, focusing on the real-world entities and their meaning; the logical model would be more syntactic, focusing on the structure of the information and some implementation details.
Does that help?