Scenario 1 In the first case, the assistant manager of a company need to plan, order, schedule, ship and install equipment to be used during the booth shows. After the show, the equipment will be shipped back to the owners. During the shipping process, all the equipment must be tracked to ensure that they arrive in good working condition. The assistant manager must also ensure that the equipment are returned in good condition and also track any damages so that they can be sorted out. In order to define the necessary database fields, all the stakeholders and their functions were identified and listed. Key elements and stakeholders The most important elements for the company’s booth show are outlined below   * Suppliers : These are companies that will supply the booth materials and the equipment to be displayed at the show. All equipment and materials must be listed alongside the suppliers.   * Booth materials : These are the materials that will be used to construct the booths. These materials and their quantity must be determined and the marketing assistant should order them in advance.   * Display equipment : These are the equipment that will be displayed at the booth. It is expected that people from around the world will attend the show. The assistant marketing manager must purchase state of the art electronic equipment so that the company can secure deals with the customer’s visiting the booth show.   * Shipping companies : Booth materials and the equipment must be transported via ship from various parts of the world to the exhibition site. This requires that the shipping companies be involved in the transportation process. Types of fields for each item The data fields that can be used to represent the major items in a database are outlined below: Booth materials  1. Material ID number  2. Material name  3. Material description  4. Country of origin  5. Use at the show  6. Booth materials supplier Display equipment  1. Identification number  2. Name  3. Description  4. Supplier  5. Type of equipment  6. Shipping company Shipping company  1. Name  2. Identification number  3. Contact details  4. Address  5. Equipment/ materials to be shipped  6. Time of shipment  7. Details of the shipment Suppliers  1. Name  2. Identification number  3. Supplier address  4. Equipment/ material be supplied  5. Supply Contract details  6. Materials /equipment dispatch date Important relationship that should be tracked There are many important relationships that need to be tracked by the assistant manager. These include: Tracking each supplier and the equipment/ materials being supplied : There are different materials and equipment required for this show. These materials will be procured from different suppliers around the world. It is therefore important to keep track of all the suppliers, the materials and equipment they supply and the delivery dates. The assistant manager must ensure that the suppliers provide quality materials and equipment for the show. The relationship between the shipping company and the assistant manager : it is important that the assistant manager tracks all the shipping companies involved in transportation of materials and equipment to the show. This is because there are different shipments arriving at different dates. It is therefore paramount to track these complex relationships so as to get up to date information about the shipment, c