The Dynamic Chemicals Corporation keeps track of its customers and its orders. Customers usually have several outstanding orders while each order was generated by a single customer. Each customer consists of 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 type of relationship is there between the customers and orders?
b. Develop sample customer and order data and make two files 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 the customers and orders? Describe.
d. Merge these two files into one. Does this made any problems with the data? Describe.