Class Exercise: Normalizing from an Application View


    a.  Use relation schema notation to specify the sales invoice
        form shown below:

                             SALES INVOICE

          Invoice No: _____________         Date: ________________

          Customer Name: _________________________________________

          Address: _______________________________________________

          Phone: ______________   Sales Person: __________________

          Line Items:                       
          ItemNo  Description    Quantity   Unit Price  Item Total
          ------  -------------  --------   ----------  ----------    
          ______  _____________  ________   __________  __________
          ______  _____________  ________   __________  __________
          ______  _____________  ________   __________  __________
          ______  _____________  ________   __________  __________
          ______  _____________  ________   __________  __________

                                        Invoice Total:  __________





    b.  Normalize your data definition given for the sales invoice
        form in part a into a set of 3NF relations.