The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to design a physical ...

This type of model is used to design the database. The physical data model contains all the specifics about how the logical model will be implemented. This model format includes table names ...

an existing canonical data model can be a valuable jump-start to the process of building a physical database design covering one or more areas from canonical models. Most importantly, these canonical ...

from that model, generate a physical database design for almost any RDBMS. Of course, the ability to follow those links is only useful if all of your data stores are documented in PowerDesigner. I ...

An introduction to databases and Database Management Systems (DBMS). Topics include basic concepts of database technology, an introduction to SQL, techniques for logical and physical database design, ...