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
Search WWH ::




Custom Search