Question No. 9: Schema Design through Entity Relationship Modeling 112 marks In Malam Jaba, there is a store that rents pair of skis and also sells snowboard to the tourists. The store is interested in automating its sale and rental process. The store owner has gathered the following requirements and wants you to design the database. The store contains two types of equipment: Pair of skis and snowboard. They are identified uniquely by their equipment ID. For both the equipment, their model needs to be stored. In addition, for pair of skis, their rental price, while for snowboard their sale price needs to be stored. Tourists that visit the store are identified by their passport numbers. In addition, their name, nationality and multiple contact numbers also need to be stored. There can be two types of tourist: skier or snowboarder. For skiers we want to store their years of experience too. Skiers rent pair of skis while snowboarders purchase snowboard. A Skier may rent one or more pair of skis and a pair of skis can be rented by many skiers throughout the course of its life. For each rental, the store also wants to record the rental date and return date. A Snowboarder may purchase one or more snowboards. For each purchase, the store wants to record purchase date too. a) Draw an Entity Relationship Diagram (ERD) for the above set of requirements. 151 b) Translate the ERD obtained in part a) to the corresponding relational schema. 151 c) At this stage, one of your table must be containing rental date and retum date. Write a DDL statement for that table imposing all the related constraint and an additional constraint that the return date must always be greater or equal than the rental date. 121 Page 3 of 3