Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JacobPressures
Posting Yak Master
112 Posts |
 Posted - 2005-09-12 : 18:02:05
|
| What is the difference between the logical database schema and the physical database schema?Thanks! |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-09-12 : 18:20:20
|
| A very basic breakdown:Logical:entities and relationships Physical:tables and foreign keysNathan Skerl |
 |
|
|
JacobPressures
Posting Yak Master
112 Posts |
Posted - 2005-09-12 : 18:30:28
|
| so once the tables and attributes are laid out and a DB is created, the visual representation of those tables in Access or SQL Server is the Physical Database Schema?an example being www.geocities.com/jacobpressuresor is the above an example of a Model?While the ER-Diagram shetches when i first start modeling the relationship is the logical? |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2005-09-12 : 18:36:13
|
| The logical schema is the formal adherence to the underlying data model. In our case the Relational Model. ERDs is a common methodology, but really only skims the surface of RM. Functional Dependancy Analysis is the bread and butter for normalisation.The difference between the logical and physical can be vast....DavidMA front-end is something that tries to violate a back-end. |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-09-12 : 18:38:26
|
| Peep this:[url]http://www.developer.com/tech/article.php/641521[/url]Nathan Skerl |
|
|
|
|
|
|
Difference in Logical and Physical DB Schemas