Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q1. Green Nursery Sdn. Bhd. carries a wide range of products, from pots, plants, gardening tools, fertilisers and pesticides. They sell their products from three
Q1. Green Nursery Sdn. Bhd. carries a wide range of products, from pots, plants, gardening tools, fertilisers and pesticides. They sell their products from three different nurseries located within Klang Valley. The following is an entity relationship diagram (ERD) of Green Nursery Sdn. Bhd. 1 M 1 M EMPLOYEE serves CUSTOMER places ORDER M has N 1 NURSERY located PRODUCT (a) Describe the relationships shown in the entity relationship diagram (ERD). (8 marks) (b) Design the Third Normalisation Form (3NF) table for the case above. Identify the primary key(s) for each table and fill in TWO (2) rows of data for each table. (18 marks) (C) When a customer checkout the plants they have selected, the nursery employee will enter the items in the point-of-sales (POS) system and issue an invoice to the customer. Suggest TWO (2) data validation rules that can be applied to reduce input errors when keying into the POS system. (4 marks) [Total: 30 marks]
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