• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Entity Types > The Entity-Relationship Model

The Entity-Relationship Model

The Entity-Relationship (ER) model is a fundamental tool of relational database design. In fact, it is considered so critical that most relational database management systems, including both SQL Server and Access, include some form of ER diagramming as a management tool.

As you probably know, ER analysis begins with the identification of a problem space—that subset of the real world that the database is intended to model. Remember, the system is intended to do something, not everything. Limiting system scope is critical to a project's success. In this chapter, and elsewhere in the book, we'll use a system to manage the inventory and sales of a used bookstore as a sample.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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