943,640 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 7100
  • MySQL RSS
Apr 20th, 2004
0

MySQL - logical model from a conceptual model

Expand Post »
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?
Similar Threads
Reputation Points: 11
Solved Threads: 0
Newbie Poster
dina is offline Offline
12 posts
since Nov 2003
May 21st, 2004
0

Re: MySQL - logical model from a conceptual model

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?
--sg
Reputation Points: 182
Solved Threads: 71
Posting Pro in Training
gusano79 is offline Offline
475 posts
since May 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: NEWS - MySQL Database To Get New Features
Next Thread in MySQL Forum Timeline: Can't see MySql records using PHP with any browser





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC