Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will select an organization for which you will complete each of the assigned tasks. The organization can be real or fictitious, but the work

You will select an organization for which you will complete each of the assigned tasks. The organization can be real or fictitious, but the work that you complete needs to apply to the scenarios that are provided.

Your company is facing two new requirements for an existing application. The application manages customers and products, and it is been working fine for several years. Recently, the marketing department has requested the following improvements to the information technology (IT) department:

They want to be able to search for a specific product using the best search algorithm.

They want to be able to print a sorted list for all of the customers, using the last name as a key.

You have been assigned this project by your manager. Your company is not using databases to store the information for customer or products, so you will have to help it decide which algorithm to use when sorting a list of elements or searching for an element.

The existing information for customers is as follows:

- First name

- Last name

- Shipping address

- Billing address

- Phone number

- Customer ID

The information for the product is as follows:

- Product ID

- Name

- Description

- Wholesale price

- Sale price

- Inventory

In this week, you will create a Word document to do following tasks:

1. Describe your scenario company. **My scenario company is a fictional company that I will call AirParts. In this company they manage, store, inventory, sell and buy parts for different aircraft.**

2. Based on the product and customer data explained in this document, provide at least 2 different types of data structures for the customers and the products. Remember that the data structure selection can have an impact in the performance achieved by the algorithm.

3. Evaluate the benefits and disadvantages of each data structure.

4. Recommend 1 option, knowing that the operations that are going to be performed on the customers are sorting using different keys, and the operation that is going to be performed on the product data is mostly searching.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions