INFO6002: Entity-Relationship Modeling for a Database for Office Wizard - Customer Sales - IT/Computer Science Assignment help

Assignment Task

Assignment Background 
You are asked to develop a conceptual database design using Enhanced Entity Relationship modeling for a database for Office Wizard. 
Office Wizard is a local company that specializes in supplying office equipment and stationeries to corporate customers. After years of managing the records manually, the company has decided to computerize the database. You are tasked to design the conceptual database design for Office Wizard’s database based on the business requirements provided in this document. 
Your lecturer will act as your client, whom you can query for any further information and clarifications. This can be done via the Blackboard Discussion Forum detailed below. 
Business Requirements 
Office Wizard supplies a wide variety of office equipment and stationeries such as cabinet, computer desk, swirl chair, paper, folder, pen, pencil, marker, etc. The various suppliers supply these products to Office Wizard who distribute them to its customers. Three areas are considered in this database for Office Wizard: 
• Managing Supplier & Product information 
• Managing Sales information 
• Managing Employee information 
Supplier & Products: Following information needs to be maintained for products of Office Wizard: 
• Product ID (which is unique for each product) 
• Product name 
• Manufacturer 
• Category (furniture, writing equipment, filing equipment, misc., etc.) 
• Description 
• Quantity description (e.g. a rim of paper, a dozen of pens, a box of 10 markers, etc.) 
• Unit price (based on the quantity description) 
• Status (available, out of stock etc.) 
• Available quantity 
• Re-order level 
• Maximum discount – This is the maximum discount that can be provided on the product. This is given as a percentage of the Unit Price. 
Office Wizard obtains their products from various suppliers. To ensure product availability, most products are obtained from multiple suppliers. The following information is to be maintained for each supplier: 
• Supplier ID 
• Name 
• Address 
• Phone number 
• Fax number 
• Contact person 
• Product(s) supplied 
Prior to ordering goods from suppliers, a quotation is requested. A quotation includes the following information: 
• Quotation number (this is unique for each quotation) 
• Date of quotation 
• Validity period (in months) 
• Description 
• Supplier providing the quotation 
• Products, quantities and unit price quoted for each product 
• Employee requesting the quotation 
A quotation may result in one or more orders of products from Suppliers (known as Supplier Orders). The following information needs to be maintained with regard to supplier orders: 
• Supplier order ID (which is unique for each supplier order) 
• Date order was made 
• Supplier to whom the order is given 
• Description 
• Quotation leading to the supplier order 
• Products ordered, quantities and unit prices for each product 
• Total amount of order 
• Status (received, completed etc.) 
• Order received date 
• Payment date 
• Payment reference number (unique for each payment). The payment reference number is a reference to payments made in the Accounting System. 
Customer Sales: Office Wizard receives orders from customers through its sales staff (in person or through the phone). Order information includes: 
• Date of order 
• Products (at least one product per order) 
• Unit price for each product 
• Quantity ordered for each product 
• Discount given (if any) 
• Overdue fees (if any) 
• Cancellation fees (if any) 
• Total amount due 
• Billing date 
• Due date 
• Status (processing, delivered, awaiting payment, completed, etc.) 
• Employee managing the sale 
• Description 
Product prices vary from time to time. Therefore, when an order is taken, the product prices should be based on the effective prices at the time of ordering. 
A customer order may be paid partially as multiple customer payments. For instance, a large order may have a deposit prior to customer order is processed etc. All customer payments for orders need to be maintained in the database. A customer payment includes: 
• Date payment is made 
• Amount paid 
• Customer order to which the payment is made 
• Payment reference number (unique for each payment). The payment reference number is a reference to payments received in the Accounting System. 
Office Wizard maintains a list of customer records which include the following detail: 
• Company name 
• Address 
• Phone number 
• Fax number 
• Email address 
• Contact person name (one contact person per company) 
• Maximum Allowable Credit. A customer can make orders up to the maximum allowable credit amount without making a payment. A default value of $5000 is given for normal customers. For trusted customers the maximum credit limit is increased based on the manager’s discretion. 
Human Resources & Payroll: The following information about employees is stored in the database: 
• Employee ID 
• Name 
• Gender 
• Work phone number 
• Home address 
• Home phone 
• Date of birth 
There are different positions at Office Wizard. Each position has the following information: 
• Position ID (which is unique for each position) 
• Position title 
• Hourly rate 
Employees are assigned to only one current position. Each assignment has a start date and an end date (end date is null for a current position). History information about employees’ positions must be maintained. 
Employees of Office Wizard are generally divided into two groups: sales and administration. Each sales staff is given a sales target to meet each quarter. The sales targets can be different for each staff and quarter. For performance monitoring and data mining purposes, the database needs to keep the historical records of all sales targets for each sales staff: 
• Year 
• Quarter 
• Sales amount to be met 
Employees are paid monthly wages. The base pay is determined by multiplying the hourly rate of the position by the number of hours for the month. Next, any allowances (such as bonuses etc.) are included. Finally, taxes are deducted to determine the net pay. 
 

This INFO6002: IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.