(Solved): Map the Conceptual EERD given on figure 1 to produce a complete LOGICAL ERD for Tourmato. T ...

Map the Conceptual EERD given on figure 1 to produce a complete LOGICAL ERD for Tourmato. This LOGICAL ERD needs to include all the correct tables, relationships, multiplicity constraints, attributes, primary keys and foreign keys. It should be easy to read and needs to fit on one page of the report. - It should fit on one page of the report and be easy to read. - It should use UML notations as learnt in this module and no other notations. You have been hired by Tourmato as a Database Consultant to undertake a database project to support the data needs of the firm. In this second part, you are given a conceptual data model for Tourmato (figure 1), and your first goal is to map it onto a high-quality LOGICAL ENTITY RELATIONSHIP DIAGRAM (ERD) to logically represent how the key business data needs can be organised as a set of interrelated tables that can then be implemented. These tables need to be interconnected according to the strict rules of the relational model to be implementable. Tourmato is a touristic company that offers exciting "off-the-beaten track" visiting tours around several cities across Europe. Essentially, Tourmato takes groups of customers around European cities to visit them and experience their unique atmospheres, under the direction of a local experienced tour guide. To provide a range of experiences, every city covered by Tourmato offers many visiting tours. A tour session is a visiting tour that has been assigned a specific start date and time, a start address, an end date and time, an end address and a specific price. Tourmato customers can place a booking for a variety of exciting tour sessions, depending on what they like. The conceptual EERD for Tourmato is given in Figure 1 (see next page). Figure 1. Conceptual EERD for Tourmato