CREATING THE PHYSICAL MODEL WITH SQL SERVER - A Developer's Guide to Data Modeling for SQL Server - page 205

Orders

■

Order Details

■

Products

■

Shipments

■

ShippingCarriers

■

Shipping Methods

■

Payments

■

CreditCards

■

GiftCards

■

BankAccounts

■

F IGURE 9.7

The Orders submodel from the Mountain View Music logical model

First, let's look at the entities that can be made into tables as is. We
have already made tables out of the Products and Employees entities, so
those two are all set (with a single exception for tbl_employee, which we
look at shortly). Of the remaining entities, Shipments, ShippingMethods,
ShippingCarriers, and Order Details can all be made into tables without
any major modification other than their names. That leaves us with six en-
tities that still need some work: Orders, Customers, and the supertype