ONLY NEED ANSWERS FOR TASK 3 (QUESTION NUMBER 3(I TO IX))

THANK YOU

AutoSave on AUR H2UB ICT200 Group Assessment v2 (1).docx - Word O Search Sameer Chettri SC Ga File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Calibri (Body) 11 A A Aa A ALI I u X, X? ADA I Normal I No Spac... Heading 1 Heading 2 Find Replace Select Paste Title Dictate Sensitivity Editor Clipboard Font 4 Styles Editing Voice Sensitivity Editor Paragraph Submission Requirements: This is a group assessment task with 3-4 students in a group. Students will submit one group report (1000 words) detailing the tasks carried out in the assignment. Report must be well- written and should have appropriate referencing. This report is due by the end of week 11. Complete all tasks based on the given case study. . Case Study: The Fragrance Flowers Group operates extensively in the Australian flower industry. They are a multi-generational family business running for last 50 years focussing on providing everyday fresh and quality flowers to customers through different cities in Australia. They also provide the option to add accessory items such as leddy bears, chocolates or a vase along with the flower purchase. Recently they are planning to replace their current manual system by designing a new database system that will make the online flower ordering experience more convenient and hassle-free. A simplified database should support procedures such as checking the inventory of all components for a particular arrangement in different store locations, determining popular items, fulfilling customer needs more efficiently, and allowing, staff to generate customized reports as requested by the management. To support these functionalities the database should contain data about a particular store, customer, order, flower arrangements components, and accessory items. The following list describes the data requirements in more details. Customer data includes unique customer number, first name, last narre, email, phone, and city. One customer can place one or many orders, Order data includes unique order number, order description, order month, order year, order type, order total and store details (number, city, phone and manager) where Page 1 of 5 1093 words English (Australia) Focus TE 200 Sameer Chettri SC Ga Share Comments AutoSave on AUR H2UB ICT200 Group Assessment v2 (1).docx - Word O Search File Home Insert Draw Design Layout References Mailings Review View Help Calibri (Body) 11 A A Aav Ao A A Aa A ALI Paste IUX, X? ADA T Normal 1 No Spac... Heading 1 Heading 2 Title Find Replace Select Dictate Sensitivity Editor Clipboard Font Paragraph Styles Editing Voice Sensitivity Editor The following list describes the data requirements in more details. Customer data includes unique customer number, first name, last name, email, phone, and city. One customer can place one or many orders. Order data includes unique order number, order description, order month, order year. order type, order total and store details (number, city, phone and manager) where that order is placed. An order can include one or many order items. Orders can be of three types - Online, phone, and in-person. Order Item data includes various items purchased by the customer for a specific order. It can store information regarding order number, item (Flower arrangement) along with the qly of that item purchased. Flower Arrangement information may include unique arrangement id, name, style, occasion, and price. A store can sell specific types of flower arrangements. ICT200 Assessment 1 Group Report K^>KOI Customers can buy flowers with different arrangements along with a number of accessories. Accessory information includes accessory id, name, and price. Sample data for the proposed database is provided below: Page 1 of 5 1093 words English (Australia) Focus BE 200 Sameer Chettri SC Ga Share Comments AutoSave on BOB H2UB ICT200 Group Assessment v2 (1).docx - Word Search File Home Insert Draw Design Layout References Mailings Review View Help Calibri (Body) 11 A A Aav Ao A A Aa A ALI Paste I u X, X? ADA T Normal 1 No Spac... Heading 1 Heading 2 Title Find Replace Select Dictate Sensitivity Editor Clipboard Font Editing Voice Sensitivity Editor Paragraph Styles Sample data for the proposed database is provided below: Customer custNumber CustName custEmail custPhone custCity co1 David Smith dsmith@gmail.com 12345678 Sydney 002 34653874 Melbourne enter studenti nome ente studenti email 003 53687632 Perth cnter student2 nome cater student email 004 enter students 47123798 Adelaide enter students email nome cos enter studente 23782834 Sydney enter students email nome Complete customer table with names and emails for each group member as requested. Retail Order orderNumber storeNumber storeCity storePhone Manager order Month ordercar grder Typs order Total 1500 1 Sydney 27747234 kim Dec 2019 BSP $170 3 Peth 15141023 len IN 2020 Recipe 5100 3502 Melbour 2358/526 ull Hub 2020 2020 $450 1 Sydney 84204525 Sher: Feb 2020 32 Page 2 of 5 1093 words English (Australia) Focus TE 200 Sameer Chettri SC Ga Share Comments AutoSave on BOB H2UB ICT200 Group Assessment v2 (1).docx - Word Search File Home Insert Draw Design Layout References Mailings Review View Help Calibri (Body) 11 A A Aav Ao A A Aa A ALI Paste I u X, X? ADA T Normal I No Spac... Heading 1 Heading 2 Title Find Replace Select Dictate Sensitivity Editor Clipboard Font Styles Editing Voice Paragraph Orderitem Sensitivity Editor OrderNumber Itemid quantity 1501 F01 2 1501 FO2 1 1502 F01 3 1502 FO3 2 1503 FO3 3 1504 FO3 1501 rom 3 3 FlowerArrangement arrangeID arrangeName style occassion arrange Price F01 Iris Vase Anniversary $BO FO2 Orchids centrepiece Congratulations $150 FOB Lilies Hamper Thank you $100 F04 Rainbow Bouquet Wedding $110 FOS Sunflowers Boxed Get Well SEO Page 3 of 5 1093 words English (Australia) Focus BE 200 AutoSave on BOB H2UB ICT200 Group Assessment v2 (1).docx - Word O Search Sameer Chettri SC Ga File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Calibri (Body) 11 A A Aa A ALI IUX, X? ADA T Normal I No Spac... Heading 1 Heading 2 Find Replace Select Paste Title Dictate Sensitivity Editor Clipboard Font Paragraph Styles Editing Voice Sensitivity Editor Accessory accessory accessoryName accessoryPrice A01 Teddy bear $50 A02 Chocolate $20 A01 Basket $30 A04 Plant $25 ICT200 Assessment 4 Group Report > Task 1: Introduction 2 marks a. Introduce the important aspects of the case study. This section should include introduction to the case study in your own words and details of tasks that need to be completed for this report, Page 3 of 5 1093 words English (Australia) Focus TE 200