Database Reference
In-Depth Information
SEMINAR
Column Name
Data Type
(Length)
Key
Required
Default Value
Remarks
SeminarID
Integer
Primary Key
Yes
DBMS supplied
Surrogate Key:
Initial value=1
Increment=1
Format: yyyy-mm-dd
Format: 00:00:00.000
SeminarDate
Date
No
Yes
None
SeminarTime
Time
No
Yes
None
Location
VarChar (100)
No
Yes
None
SeminarTitle
VarChar (100)
No
Yes
None
Figure 7-39
Sample Database Column
Specifications for the
Heather Sweeney Designs
Database (SEMINar table)
Relationship
Referential
Integrity Constraint
Cascading
Behavior
Parent
Child
On Update
On Delete
SEMINAR
SEMINAR_CUSTOMER
SeminarID in SEMINAR_
CUSTOMER must exist in
SeminarID in SEMINAR
No
No
CUSTOMER
SEMINAR_CUSTOMER
EmailAddress in SEMINAR_
CUSTOMER must exist in
EmailAddress in CUSTOMER
Yes
No
No
No
SEMINAR
CONTACT
SeminarID in CONTACT
must exist in SeminarID in
SEMINAR
CUSTOMER
CONTACT
EmailAddress in CONTACT
must exist in EmailAddress in
CUSTOMER
Yes
No
CUSTOMER
INVOICE
EmailAddress in INVOICE
must exist in EmailAddress in
CUSTOMER
Yes
No
INVOICE
LINE_ITEM
InvoiceNumber in
LINE_ITEM must exist in
InvoiceNumber in INVOICE
No
Yes
PRODUCT
LINE_ITEM
ProductNumber in LINE_
ITEM must exist in
ProductNumber in PRODUCT
Yes
No
Figure 7-40
referential Integrity Constraint
Enforcement for the Heather
Sweeney Designs Database
 
Search WWH ::




Custom Search