This preview shows page 1. Sign up to view the full content.
Unformatted text preview: in the case
material. You just need to know that an intersect table must be created whenever
there is a many-to-many relationship. “No one” will tell you when.
Find Virtual Entities
15. Finally, a table may be created even though there might NOT be a “physical”
entity that it represents. For example, has anyone actually seen a “Shipment”? If
so what does it look like? Make no mistake - what we DO see, feel, and touch are
the products, shipping lists, and invoices that represent a shipment. I personally
have never seen a shipment.
Identify Primary Keys
16. Once you have done th...
View Full Document
This note was uploaded on 01/26/2014 for the course COMM 335 taught by Professor Y.m.cheung during the Fall '12 term at The University of British Columbia.
- Fall '12