Example: Physical Database Design
Relationships
Related Elements
Main Description

The Physical Database Design includes an entity relationship diagram of the physical design:

Physical Database Design Example


The physical Database Design also includes the appropriate DDL:

CREATE TABLE Gift_Registrant_Address___4       (Address_ID               char(18) NOT NULL,        Registrant_Name          char(18) NULL
 )
go
CREATE UNIQUE CLUSTERED INDEX XPKGift_Registrant_Address___4
ON Gift_Registrant_Address___4
 (
Address_ID
 )
go
exec sp_primarykey Gift_Registrant_Address___4,
Address_ID
go