One to Many
VENDOR DATA DICTIONARY
Vendor Data Records
PARTS DATA DICTIONARY
PARTS DATA RECORDS
QUERY RESULTS BEFORE NORMALIZATION
QUERY AFTER NORMALIZATION
QUERY RESULTS AFTER NORMALIZATION
XLM-J Review Questions (Due: Wed. Feb. 29)
1. What is the differenced between a report and a query? The difference between a
report and a query is that a report is designed for human consumptions; for example, the
information is arranged so that it looks
1. Each part has one and only one supplier.
2. A supplier may provide many parts. There may be suppliers present not currently providing any parts.
1. Max Cardinalities: 1/M
Min Cardinalities: 1/0