Read the scenario below, provide responses to the related questions and submit them through StudentWeb. Place your Student Identity number and your Name in the document header, left aligned. Scenario A medium sized company called Box Hill Computing is in the business of supplying desktop computer systems, PC components and accessories. They have a shop in the main street for retail sales. Upstairs from the shop the company office has several sales people who sell to new and existing business clients. Because of the greater volumes of products purchased by business clients they receive a discounted sales price on all products. The sales people are paid a base salary plus a commission of 3% of their total invoiced sales to customers. The retail sales staff in the shop below each receive a salary but no commission on sales. Customers usually deal with the same sales person, and they can place any number of sales orders at any time. A separate invoice is created for each sales order. Orders are delivered the same day or next day depending on how big and complex is the order. Also depending on whether or not stock is available. Part of an order will be delivered if full quantities cannot be found in the warehouse. Both retail sales staff and sales people draw stock from the same warehouse. Any single payment by a business customer may be for part of an invoice, all of the invoice or for multiple invoices. Business customer payments are by cheque, by credit card or by bank transfer. Retail customers in the shop must pay with cash or by a credit card. At the rear of the shop is the single warehouse from which all sales stock is drawn. Each product stocked has an identity number. Some products, such as motherboards, have a unique serial number for each unit in stock which must be recorded for warranty purposes and for identifying version differences. Every product sold has a single unit of measure. That means that cables are only sold packaged in standard lengths and each different length of the same type of cable has a different identity number. From the above details you can easily imagine that Box Hill Computing needs to keep information about its customers and their orders for products as well as information about the retail sales. That means that the company also needs to keep track of its stock holding in the warehouse. The company needs to know how much money it has taken and how much money it can expect to take in the next accounting period. For the purposes of this assignment we will not consider the payments that Box Hill Computing must make to its suppliers. Questions 1. What data entities do you identify in the scenario above? (2 marks) 2. What attributes (fields) are needed to describe each entity? List them for each entity. (2 marks) 3. Normalise the collections of attributes for each entity. Show the process of normalisation from un-normalised form (UNF) through First Normal Form (1NF), Second Normal Form (2NF) to Third Normal Form (3NF). In the process you will be creating additional entities. Assessment Criteria The following criteria must be met for full marks. a. All needed entities are identified. b. All attributes for each entity are identified. c. Your normalisation technique is defensible. d. Your application of the normalisation technique can be followed by the assessor. e. All key attributes including compound keys are correctly identified by underlining in all Normal Forms. f. All instructions in this assignment are followed. Submission Date The assignment is due on Friday the 5th of September 2014. Note that this is one week later than the originally published due date. Submission Submit your assignment as a Word document at the upload link for Assignment 1 in StudentWeb.
The post Communications Technology of Data Modelling appeared first on Homework Aider.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
