The Dynamic Chemicals Corp. keeps track of its customers and its orders. Customers typically have several outstanding orders while each order was generated by a single customer. Each customer has a unique customer number, a customer name, address, and telephone number. An order has a unique order number, a date, and a total cost.

a. What kind of relationship is there between customers and orders?

b. Develop sample customer and order data and construct two files in the style of Figure 3.5 in which to store your sample data.

c. Do any fields have to be added to one or the other of the two files to record the relationship between customers and orders? Explain.

d. Merge these two files into one, in the style of Figure 3.6. Does this create any problems with the data? Explain.