Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Step: 3

blur-text-image

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

Financial Accounting And Reporting A Global Perspective

Authors: Herve Stolowy, Yuan Ding, Luc Paugam

6th Edition

147376730X, 9781473767300

More Books

Students also viewed these Accounting questions

Question

How does mindfulness practice assist in rational decision-making?

Answered: 1 week ago