Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions

Question

How wide are Salary Structure Ranges?

Answered: 1 week ago