A small business wants to develop a database for storing and managing its sales information. At the beginning, the business would like to keep the information about its customers and the order each customer has placed.

1. Several entity-relationship (E-R) diagrams are developed to represent the following facts related to the database that they will operate.

• Each customer can place many orders for specific products
• Each order is placed only by one customer

A. Please select the most appropriate ER diagram for the design of the database at the business in this situation. (3 marks)

B. Consistent with the E-R diagram of your selection above, describe the database tables that will be required, by listing the appropriate fields for the 2 tables, and the Access field types. For each table:

1. List the field names (Giving both the name and the Access data type) required to maintain the necessary data. (1 mark)
2. Label the primary key (PK) in each table. (1 mark)
3. Label any foreign keys (FK) needed to link the tables (1 mark)