Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Section Review

Remember These Points

  • Any number of database models may be used for the implementation of a logical data model.
  • Tables, columns, rows, primary keys and foreign keys are the basic building blocks of a physical relational model.
  • Specific rules exist within the relational model which are different from other implementation databases. These include null column values and the order of rows within tables.
  • A specific recipe can be followed to properly transform a logical data model into a valid physical relational model.
  • Most data modeling tools will automatically follow these transformation recipe, allowing one to quickly produce a physical data model under automated control.
  • Sometimes there are transformation deficiencies in certain modeling tools requiring the physical model to be manually enhanced after its initial transformation from the logical model.

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint