Clearly Drinks Limited is an established supplier of numerous soft drinks offering high quality branded drinks at low prices to a wide variety of customers around the North East af England. Although Clearly Drinks Limited is capable of supplying to any scale customer i.e. shop owners and also national companies, the business tends to focus predominantly around selling bulk orders of soft drinks to local and regional restaurant owners and supermarkets as they find this is the market segment that creates frequent purchases which in turn generates more long term revenue. The business has a stock room where all available soft drinks are kept and recorded on a spreadsheet including a note summary on how much each customer has purchased. In the future the business is planning on expanding so monitoring the drinks and what each customer has bought is going to become increasingly difficult on their current data storing method. Although the business uses a basic spreadsheet to monitor their stock, the current process for after a customer has placed an order is a paper-based invoice that the company keeps a copy in their office filing cabinet. Having both a spreadsheet and paper-based documents is tume consuming for staff. In order to find which drink stock is for which invoice, they first have to search through the filing cabinets for the invoice sheet and then manually check each stock record for the matching inform

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Clearly Drinks Limited is an established supplier of numerous soft drinks offering high quality branded drinks at low prices to a wide variety of customers around the North East af England. Although Clearly Drinks Limited is capable of supplying to any scale customer i.e. shop owners and also national companies, the business tends to focus predominantly around selling bulk orders of soft drinks to local and regional restaurant owners and supermarkets as they find this is the market segment that creates frequent purchases which in turn generates more long term revenue. The business has a stock room where all available soft drinks are kept and recorded on a spreadsheet including a note summary on how much each customer has purchased. In the future the business is planning on expanding so monitoring the drinks and what each customer has bought is going to become increasingly difficult on their current data storing method. Although the business uses a basic spreadsheet to monitor their stock, the current process for after a customer has placed an order is a paper-based invoice that the company keeps a copy in their office filing cabinet. Having both a spreadsheet and paper-based documents is tume consuming for staff. In order to find which drink stock is for which invoice, they first have to search through the filing cabinets for the invoice sheet and then manually check each stock record for the matching information. As Clearly Drinks Limited expands it has become evident by the manager that they need a more efficient electronic method of storing information about their drink stock, customers and invoices rather than their current spreadsheet and paper-based process which is becoming increasingly difficult to manage and maintain. The manager of Clearly Drinks Limited has asked for a database to be created for the company as it will be much more efficient and user friends for staff members. The main purpose of the database is to enable staff members to be able to check and update stock levels of their drinks and also be able to identify which customer purchased which order so that they can allocate the correct drinks to be delivered to the correct customer address. Develop a table and normalize it to the 3NF

Expert Solution