Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started