28.1.3 Implementing One-to-Many Relationships (cont.)

  • Break into 2 tables
  • Link items to an invoice w/Invoice_Number
Item
Invoice_
Number		 Product_
Code		 Quantity
INTEGER CHAR(10) INTEGER
11731 116-064 3
11731 257-535 1
11731 643-119 2
11732 116-064 10
11733 116-064 2
11733 643-119 1
Invoice
Invoice_
Number		 Customer_
Number		 Payment
INTEGER INTEGER DECIMAL(10,2)
11731 3175 0
11732 3176 249.5
11733 3175 0
prev |top |next