Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Exotic Treat company The Exotic Treat company is a small, independent business that sells exotic sweets and cakes to the public. The proprietor is

The Exotic Treat company The Exotic Treat company is a small, independent business that sells exotic sweets and cakes to the public. The proprietor is very keen on baking and specializes in making homemade sweets and cakes for sale in the shop. As well as making much of the confectionery sold in the shop, the proprietor also buys sweets and some cakes from suppliers to increase the range of products for sale. At the end of each day the proprietor reviews the sales of the homemade items. He then decides how many sweets and cakes to make for the next day. This is also partly to replenish any stock that needs to be bought from suppliers, and also to keep track of the sales. Once a week the proprietor checks the stock to dispose of anything that is past its use by date. He also checks to see if any raw ingredients for the homemade products, or any pre-made sweets and cakes need to be ordered from the suppliers. The proprietor orders supplies on a Cash On Delivery basis, so all deliveries are paid for immediately. *Make appropriate assumptions where necessary (a). Draw a Context Diagram to depict the above system. (10 marks) (b). Produce a Level 1 Data Flow Diagram upon completing (a). (40 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

The Database Experts Guide To SQL

Authors: Frank Lusardi

1st Edition

0070390029, 978-0070390027

More Books

Students also viewed these Databases questions