Database Reference
In-Depth Information
SEMINAR
SeminarID
SeminarDate
SeminarTime
Location
SeminarTitle
SEMINAR_CUSTOMER
SeminarID (FK)
EmailAddress (FK)
CUSTOMER
EmailAddress
LastName
FirstName
Phone
StreetAddress
City
State
ZIP
CONTACT
EmailAddress (FK)
ContactDate
ContactNumber
ContactType
SeminarID (FK)
PRODUCT
ProductNumber
Description
UnitPrice
QuantityOnHand
INVOICE
InvoiceNumber
InvoiceDate
PaymentType
Subtotal
Shipping
Ta x
Total
EmailAddress (FK)
LINE_ITEM
InvoiceNumber (FK)
LineNumber
Quantity
UnitPrice
Total
ProductNumber (FK)
Figure 12-10
The HSD Database Design
dimension tables radiating out from the center. The fact table is always fully normalized,
but dimension tables may be non-normalized.
To illustrate a star schema for a dimensional database, we will build a (very) small data
warehouse for Heather Sweeney Designs (HSD), a Texas company specializing in products for
kitchen-remodeling services. HSD puts on seminars to attract customers and sell topics and
videos in addition to doing actual design work. For more information about Heather Sweeney
Designs, see the Chapter 7 Heather Sweeney Designs Case Questions on pages 343-353. A
database design for HSD is shown in Figure 12-10, and an Microsoft SQL Server 2012 data-
base diagram for the HSD database is shown in Figure 12-11. In addition, the Chapter 7
Figure 12-11
The HSD Database Diagram
 
 
Search WWH ::




Custom Search