Question: Section B: ENTITY RELATIONSHIP DIAGRAM (20marks) Answer all questions based on the short case study below. Miss Anita Wong has hired you to design and

 Section B: ENTITY RELATIONSHIP DIAGRAM (20marks) Answer all questions based on

Section B: ENTITY RELATIONSHIP DIAGRAM (20marks) Answer all questions based on the short case study below. Miss Anita Wong has hired you to design and develop a simple database for her to manage her hand sewing workshop classes. Every time she conducts a workshop, she will list down the date and location and give a special name for the workshop. She sets to have maximum 15 participants for every workshop at the price of RM150 per session, and the participants can choose to be a member or maintain as non-member of her shop. Members has the benefit of discount rate and special birthday promo while non-members are entitled to occasional vouchers. Before conducting the workshops, she will make sure she has all items and tools such as fabric, needle, threads, and chalks ready for the workshop and record the quantity taken out from her inventory to be given to the participants. (a) Identify the main entities from the case above. [4marks] (b) Identify the main relationship types and specify the cardinality for each relationship. State any assumptions you make about the data. [4marks) (C) Identify one supertype and its subtypes from the case above and state if it has disjoint/overlapping constraints and partial/total completeness constraints. [4marks] (d) Using your answers for (a), (b) and (c) draw a Crow's Foot ERD to represent the data requirements for the company. [8marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!