Hello,

I am creating a database for a contest, and am confused about some of the requirments. The situation is to create a site and booking system for a tour company. The requirements are:

create the database, all necessary links, and relationships between tables within the database. The database will contain the following tables:

− Invoice Master: entered and given to the
judges at time of test
− Invoice Line Item Master: entered and
given to the judges at time of test



I am confused as to what the Invoice Master and Line Item Master are. If someone could help I would really appreciate it.

Thanks!

assuming basic normalisation

Invoice Master would contain the overall details. inv_ref [PK], customer_ref, date etc maybe the number of items (lines) ordered.
line item would contain each line (refno [PK], product, qty, price etc) for the invoice with a reference (inv_ref [FK]) to the invoice table for join/union queries.