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
- Fall '12
- Many-to-many, Candidate key, One-to-many, Sauder School of Business, William Tan