联结
举例:
我们有多个工厂A,B,每个工厂会生产的商品种类为T1,T2,T3,,商品所对应的价格为P1,P2,P3,那么我们如何设计数据表结构去存储每隔商品的信息?
没有考虑联结时,设计的表结构如下:
+------------+-----------+----------+ ----------+
| factory | commodity| price | factoryid |
+-----------------------------------------------+
| A | T1 | P1 | 1001 |
+-----------------------------------------------+
| A | T2 | P2 | 1001 |
+-----------------------------------------------+
| A | T3 | P3 | 1001 |
+-----------------------------------------------+
| B | T1 | P1 | 1002 |
+-----------------------------------------------+
| B | T2 | P2 | 1002 |
+-----------------------------------------------+
| B | T3