Database Reference
In-Depth Information
•
Can a
Product
be referenced by more than one
Order Line
?
•
Can an
Order Line
reference more than one
Product
?
•
Can a
Product
exist without an
Order Line
?
•
Can an
Order Line
exist without a
Product
?
EXERCISE
6:
L
OGICAL
D
ATA
M
ODELING
M
INDSET
Here are some of the questions I would ask based upon this collection during the logical
data modeling phase:
•
How do you identify an
Order
?
•
How do you identify an
Order Line
?
•
How do you identify a
Product
?
•
What properties describe an
Order
?
•
What properties describe an
Order Line
?
•
What properties describe a
Product
?
•
Is
Order Short Description
always required for an
Order
? How long is it?
•
Is
Order Scheduled Delivery Date
always required for an
Order
?
•
Is
Order Actual Delivery Date
always required for an
Order
?
•
What unit of measure is
Order Weight
in?
•
What currency is
Order Total Amount
in?
•
Does
Order Status Code
ever change over time? If yes, how frequently does it
change?
EXERCISE
7:
E
MBED OR
R
EFERENCE