Welcome to Live Chat

Welcome to LiveWebTutors Services, World's leading Academic solutions provider with Millions of Happy Students.

Call Back
logo

24x7 Support Available

To Get the Best Price Chat With Our Experts

chat now

In A Hurry? Get A Callback

shopping cart 0

Subject Solutions Code Description Price Delete

Amount Payable : $0

continue shopping proceed to checkout

World's Leading Assignment Library

Centre for Information and Communications Technology of Data Modelling Assignment.

Question Preview:

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 di...

View Complete Question >>

Question Preview:

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.

View Less >>

Solution Preview

create table orderline(order_id number primary key,product_id number not null,quantity_order number)

create table product(customer_id number primary key,unit_price number)

create table order_details(order_id number, emp_id number not null,order_date date,customer_id number,customer_name char(20) not null)

alter table order_details add foreign key (order_id) references orderline(order_id)

create table customer (customer_id number not null,customer_name varchar(20))

insert into orderline values(1,100,10)

insert into orderline values(2,200,20)

insert into orderline values(3,300,30)

insert into orderline values(4,400,40)

insert into orderline values(5,500,50)

question Get solution

$5

Orginal Price : $6.50

Pay Now

Upload Assignments

250 words

side

Get Your Assignment

Don’t delay more, place your order now. Quick assignment help will be offered to you.

Order Now

CUSTOMER REVIEWS

Excellent

logo

Based on 702 reviews See all reviews here

One of the Best Service

I trust LiveWebTutors for my assignments because of their ability to deliver the perfect assignments time and again. Only a few of my assignments required minor revisions. The rest assured it is the best assignment writing service in the market.

Elizabeth
Sydney

Great Service and on time

I felt so exhausted and burdened with the large number of assignments I had to write and desperately needed someone to help me with all the writing and there was LiveWebTutors company on the internet. They finished my assignments before the due date and also offered me a first-timer discount.

Christina
Perth

One of the Best Assignment Provider

I ordered my Mathematics and Marketing assignments from them last month. I received the content on the set date. Most importantly, the assignments were well-written and plagiarism free. I scored a top grade for the assignment written by them. They are a reliable company.

Oli
Brisbane

Very Helpful Customer Service

I was quite unsure about getting my assignment written online but after coming across LiveWebTutors.com, all my worries have vanished. The quality of the assignments written by their writers is just invincible. Their customer support is very polite and helpful. You should try their service at least once

Kabir
Adelaide