b) Based on the case study given below, construct an Entity Relationship Diagram (ERD) complete with all the required ta

[answerhappygod]

B Based On The Case Study Given Below Construct An Entity Relationship Diagram Erd Complete With All The Required Ta 1 (151.6 KiB) Viewed 31 times

b) Based on the case study given below, construct an Entity Relationship Diagram (ERD) complete with all the required tables, attributes and relationships using the Crow's Foot notation that reflects all the given business rules. Founded in 2009 in Japan, ABC Cooking Studio now operates over 100 studios across the world, including Hong Kong, Korea and Thailand. ABC takes cooking seriously, and the sleek and modern studio in KL's Pavilion Elite is a budding cook's dream. You have been hired by the KL's studio to develop a database system for their cooking class activities. Information about this studio is as follows: Guests may join any cooking classes that they like. They may join as many classes as they would like to. Data about guest that need to be kept will include the id number, name, telephone number, email address, country residence, nationality, and their food allergy. Data about cooking class will include the date, time, session either morning, afternoon or evening, registration fee and duration. Every cooking class will be issued with a specific id number. Each cooking class is limited up to 10 guests only to ensure sufficient attention from the cooking instructor. Even though ABC Cooking Studio is originated from Japan, they will offer local cuisines based on the country that they are operating in. ABC offers a wide variety of cuisines where one cuisine might generate many cooking classes. In anyone cooking class there will only be one cuisine being taught by one cooking instructor. Cooking instructor will handle as many cooking classes as they like. Data about cuisine that need to be kept includes the id number, cuisine name and cuisine type. Examples of cuisine type are Malay Nyonya, Malay Authentic, Traditional Village, Malaysian Chinese and many more. Each cooking instructor will be given an id number and you may keep any other appropriate data about the instructor. (13 marks)