Team Project Description and Specifications Purpose This document provides the description and specifications for Assessment Task 2 Team Project. After you have read the following background description and assignment specifications, you should refer to the associated BISM7206 Team Project – Formatting and Submission Requirements document. If your team has any questions after you have read both documents and researched the issue, please post your questions to the Assessment Task 2 Team Project forum on the Discussion Board under the relevant thread. Background After completing a double degree in business and environmental sustainability, Sophie White planned to use her business skills to build a successful eco-friendly business on the Sunshine Coast in Queensland.Sophie put her plan into practice and is now the owner of her retail business organisation called Electric Wheels Transport (EWT) which currently specialises in electric scooters. EWT has two retail outlets on the Sunshine Coast (Coolum Beach and Mooloolaba) and one in Manly ( east of Brisbane). These retail outlets enable Sophie to offer customers an attractive form of transport that is fun, practical, and cheap to run, and it also appeals to her passion for the environment. Other he demand for electric scooters is increasing as an alternative eco-friendly mode of transport. These factors are encouraging for Sophies business outlook and growth potential especially compared to the business performance when Sophie first purchased the business. Sophie purchased EWT as an established business that had grown too quickly, was overstocked,diversified too much, and had cash-flow problems. After assessing the business, Sophie developed a business plan and adopted a strategy that had more achievable outcomes and better performance potential. However, Sophie had to implement some major changes to operate successfully. When Sophie purchased the business, its stock was included in the contract. Stock that was largely used for tourist hires had to be sold and the excessive quantity of new stock on-hand also had to be reduced. The new business model would sell a smaller range of electric scooters that were popular and EWT would no longer hire out scooters. When Sophie purchased EWT, the digital business records largely consisted of Excel spreadsheets. Sophie still uses these Excel spreadsheets to record customer details including each customers name, age, address, and email address.Each customer is given a unique customer identification number and registered to the retail outlet where they make their purchase. Details of each electric scooter purchase are also recorded (excluding payment details and invoices). Electric scooters do not have vehicle EWTs customers to adopt electric scooters include the relatively low outlay to purchase an electric Assessment Task 2 Team Project: Description and Specifications 1 incentives encouraging scooter and the increasing need for sustainable urban mobility. Hence, t BISM7206 Information and Retrieval UQ Business School Semester 2 2022 identification numbers like motor vehicles, so purchase records are based on the type of electric scooter purchased including the brand and model and also the purchase date. EWT also sells accessories for their scooters such as safety helmets,scooter locks, phone holders and attachable carry-bags. These accessories are compatible with all stocked electric scooters. The purchase details are recorded manually in a hardcopy register including the customer that purchased the accessory, the purchase date, and the accessory type. An Excel spreadsheet has additional details recorded about each of the accessories such as a unique accessory code (identifier), accessory name, description, and price. Each retail outlet offers the same accessories and electric scooters. The patchwork of systems and manual recordkeeping at EWT has become difficult to maintain and various system-related issues and data anomalies have been increasing. Consequently, the reliability and usefulness of business information that can be accessed are questionable. .Technical data associated with each type (brand and model) of in the business is also stored, but Sophie finds it difficult working with disparate information systems. In this context, Sophie is unable to explore the feasibility of business improvements without reliable information. Continued growth in the global electric scooter and the growing awareness of clean energy transportation Sophie recognises that business decisions and overall business performance outcomes require easy and timely access to accurate, complete, consistent, and useful business information. It is clear to Sophie that EWTs system issues need to be resolved. Therefore, Sophie has decided that EWTs information systems need to be upgraded before any further business growth opportunities are pursued. As a database design consultancy team,you have been asked to make recommendations for a way forward. Ultimately, a centralised database system that maintains data about the complete business will be required. However, Sophie has suggested that a phased approach be adopted with Phase 1 focussing on EWTs core business needs. Therefore, Sophie requires that the database created in Phase 1 should enable access to basic details of each of the three retail outlets (address, phone number and email), the customer details, the details of electric scooters and accessories available for sale and the purchase records of electric scooters and accessories. records to explore the demographics of customers (egtheir age and city where they live) and any Sophie aims to monitor the business activities and would like to periodically analyse the Excel spreadsheets and other business trends such as the most popular electric scooters and patterns in demand electric scooter transportation. With this thriving market, Sophie is market is expected is anticipated to drive the adoption of other forms of electric keen to develop growth strategies including the possibility of introducing electric bikes and electric skateboards to EWTs retail stock. Currently, such major business decisions cannot be made by Sophie because of poor quality data and unreliable information systems. Assessment Task 2 Team Project:Description and Specifications 2 BISM7206 Information and Retrieval UQ Business School Semester 2 2022 While the range of electric scooters that the previous owners offered are still listed in an Excel spreadsheet, only the types of electric scooters available at EWT should be stored in the new database. The type of electric scooters available for sale at EWT include those listed in the following table: Table 1: Scooter Types For Sale at EWT Kaabo Mantis V2 UScooters GT Sport NIU KQi2 Pro NAMI BURN-E 2 Okai ES20 Neon ANYHILL UM-2 EMOVE Cruiser Kaabo Wolf King GT UScooters Booster V Segway GT2 Vsett 10+ Hiboy S2 Inokim OXO Apollo City Pro EMOVE RoadRunner Unagi Model One (E500) Apollo Air Kaabo Wolf Warrior X The above outlets scooter types are available at each of EWTs retail and identify the scooter brand and model.While various other details are stored in the Excel spreadsheet, Sophie does not require all of that data to be stored in the new database. For example, the new database does not need to store data specifying the water resistance, maximum weight, lights, and battery. Sophie requires all other data in the Excel spreadsheet relating to EWTs electric scooter types. Your team should consider the future growth of EWT when designing Phase 1 of the proposed system. Therefore, Phase 1 should be designed in a manner that will enable the integration of future enhancements and additional functionality. However, your design should reflect the as-is processes or present state, not the to-be state, of EWTs business processes. Phase 1 Limitations: You are only required to complete the first phase of the project which has a limited scope. In particular,the first phase of the project should not include the following in your database design: staff details (eg name, salary, job title); inventory stock control customer invoices and customer payments (accounts receivable); EWTs accounts payable. To avoid potentially unnecessarily complex designs, please post questions that you might ask the end- user to the Assessment Task 2 Team Project forum on the Discussion Board under the relevant thread. Other assumptions that you make, should be documented. Assessment Task 2 Team Project:Description and Specifications 3 BISM7206 Information and Retrieval UQ Business School Semester 2 2022 Assignment Specifications and Deliverables Your database design consultancy team have been asked to design and develop a well-structured database system for EWT based on the previous background narrative and the above limitations. You are required to write a professional business report that includes or addresses the following: 1) Team charter: Your team should have completed a team charter. Please provide documentation of elements in your team charter that address the following: a) Work breakdown and task allocation . b) Team dynamics including communication methods, action to be taken for poor team performance and conflict resolution. 2) Requirements collection and analysis:a) Briefly describe fact-finding techniques that would be appropriate for this project and explain why you believe these techniques are appropriate. b) Write two questions you would ask participants in the fact-finding process. Briefly explain the purpose of asking each question. 3) Logical database design (EWT DB Phase 1): a) Using Crows Foot notation, construct a relational data model that shows the logical database design (use app.diagrams.net) based on the background narrative, limitations and the datasets referred to in 4) Cleanse and import data (below). b) Create a data dictionary with details about each relation including attribute names, descriptions, SQL data types and sizes as well as integrity constraints on the data and any default values.Your data dictionary should be presented as a set of tables in your report and it is suggested that you consider changing the Page Orientation to Landscape in this section to make it more readable. 4) Cleanse and import data: Sophie has provided you with an excel workbook containing the original datasets used by the previous business owners (ExistingData.xlsx). You are required to cleanse and filter this data so that data imported into the new database is accurate, complete, and consistent. You are required to use this data to populate part of the new database (and incorporate this into your logical database design). a) Cleanse and filter the worksheets and import the data into the new database: Document the step-by-step process you apply to achieve the requirements of 4a. eg- Whatdidyouchangeordotocleanseandfilterthedataineachstep? – Howdidyouimportthedataintothenewdatabase? Carefully consider and apply the details in the background narrative. Ensure that all fields are free of data errors and contain valid, accurate, complete and consistent data. Make sure that all the units of measure in the data don’ t get lost in the transfer. Assessment Task 2 Team Project: Description and Specifications 4 BISM7206 Information and Retrieval UQ Business School Semester 2 2022 b) Display results: Write a SELECT statement in MySQL Workbench to display the column headings and first row of each table created in 4a) above. Display the complete dataset created in 4a) above, in alphabetical order by brand and model, using one SELECT statement. After executing these scripts, copy the SQL scripts and paste into your report. Then,take a screenshot of the Result Grid (displaying the full results) and paste this into your report as an image. Check that all the details in this image are complete and legible. MySQL scripts must be copied from MySQL Workbench and pasted into your Microsoft Word document (not as an image). Do not embed links to .sql files as these will not be marked and you will receive zero marks for your SQL scripts. 5) Database queries: a) Sophie expects the EWT database system will enable more informed strategic planning and better decision-making. In this context, what are two (2) business management questions that Sophie would expect the database to answer? Briefly explain how the answers to these questions might help improve the management planning and/or decision-making Processes at EWT. These questions should be insightful (eg processesseeking to identify trends) rather than daily transactions such as finding the address for a customer. b) Write one SELECT statement for each of the two questions specified above (5a). You are not required to use MySQL Workbench for these queries but format these queries as you would in MySQL Workbench (there should be no syntax errors). c) How could the database system automatically activate a notification to customers to inform them that new accessories are being stocked? (Limit your answer to concepts/tools discussed in BISM7206 ). Assessment Task 2 Team Project: Description and Specifications 5You are not required to use MySQL Workbench for these queries but format these queries as you would in MySQL Workbench (there should be no syntax errors). c) How could the database system automatically activate a notification to customers to inform them that new accessories are being stocked? (Limit your answer to concepts/tools discussed in BISM7206). Assessment Task 2 Team Project: Description and Specifications 5You are not required to use MySQL Workbench for these queries but format these queries as you would in MySQL Workbench (there should be no syntax errors). c) How could the database system automatically activate a notification to customers to inform them that new accessories are being stocked? (Limit your answer to concepts/tools discussed in BISM7206). Assessment Task 2 Team Project: Description and Specifications 5

Related posts: