Chapter 15
Database Design Case Study #3: SmartMart
Abstract
This chapter presents the third of three major case studies in the book. It presents a large retail environment that includes multiple stores and warehouses. The design examines additional features of database design, including reference entities, circular relationships, and mutually-exclusive relationships. It also revisits the issue of true one-to-one relationships.
Keywords
database design
database case study
ER diagrams
SQL CREATE
reference entities
circular relationships
mutually exclusive relationships
one-to-one relationships
Many retail chains today maintain both a Web and a brick-and-mortar presence in the marketplace. Doing so presents a special challenge for inventory control ...
Get Relational Database Design and Implementation, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
