Paper instructions:
This is the managerial report about AWC (Adventure Works Cycle) company’s Pattern Identification and Future Recommendations. There are few introductions about this company searching online to make you have the basic understanding. But you don’t need to write those in the paper.

NO OTHER RESOURCES NEEDED. ONLY focus on Excel data file.

In this paper, there are 2 questions need to be answered based on excel I uploaded below:

Task 1: Using predictive analytics, prepare several scenarios for the next 12 months (FY-4) of operations (up to 2 pages)
Task 2: Formulate conclusions and recommendations for the implementation of the future scenarios based on predictive analytics (overall and by buyers) – up to 2 pages
Executive summary: up to1 page

This excel file is about the forecasting how many bikes we expect to sell in whole fiscal year 4 based on the data from past fiscal 3 years. There are dataset about profit, cost, price, revenue, and also forecasting charts to analyze.

*Be detailed with the analysis. Don’t just describe the results it has, please interpreting what it might mean and how can I use the results going forward.
*Give detailed recommendations based on the analysis. All the recommendations you provide should be backed up by the extensive analysis you’ve done. When you recommend cutting cost, state exactly which costs and where in your analysis back up your claim. Remember, you’ve done the analysis, don’t give recommendations as if there’s not enough data.

Introduction to Databases

You need to make sure you review Chapter 9 in the textbook on designing databases. In addition, for those of you who have taken Introduction to Databases and/or Advanced Database courses, this should serve as a review of those courses. These problems and exercises should enhance your ability to apply database concepts when serving as a systems analyst.

QUESTIONS:

1. What are the four major functions performed by a database? HINT: CRUD
   create, read, update, and delete
2. Look at the below Figure and answer this question – What can you conclude regarding the characteristics of conventional files (flat files) and databases?(A) Conventional File System (B) Database System
3. Why do conventional file systems tend to have duplicate data?
4. What is a relational database?
5. In comparing operational databases and data warehouses, which one generally has fewer CRUD activities? Why?
    
6. Match the following terms in the first column with the definitions or examples in the second column.
7. Relational database model a. The assurance that a foreign key-value in one table has a matching primary-key value in the related table.
8. Data Warehouse b. A pattern of codes that restricts the width and possible values for each position of a field.
9. Referential integrity c. A database that stores data extracted from an operational database(s).
10. Normalization d. Data represented as a set of related tables.
11. Input mask e. A data analysis technique that organizes data into groups to form non-redundant, stable, flexible, and adaptive entities.
12. What is the purpose of data compression?
13. In what way does the choice of a data type for a field help to control the integrity of that field?
14. When an organization decides to replace a legacy system, it usually chooses a contemporary database system over a file-based system. But each type of system has its own advantages and disadvantages. Identify whether each characteristic listed below generally belongs to a file-based system or a database system.
    High cost of development
    Generally designed to be used with a single system or application
    Greater data privacy concerns
    Controlled redundancy
    Performance (speed of processing) tends to be slower
    Silo effect
15. What is a calculated field and why would you use it?
    PROBLEMS
16. You need to calculate the anticipated database capacity for constructing a database with four tables, as shown below:
    Table 1 Table 2 Table 3 Table 4
    Field1: 32 char Field 1: 5 char Field 1: 2 char Field 1: 16 char
    Field 2: 15 char Field 2: 7 Field 2: 7 Field 2: 30
    Field 3: 7 Field 3: 13 Field 3: 8 Field 3: 12
    Field 4: 12 Field 4: 6 Field 4: 4 Field 4: 7
    Field 5: 9 Field 5: 4 Field 5: 54
    Field 6: 12 Field 6: 3
    Field 7: 6 Field 7: 1
    Field 8: 2
    Table 1 will be initially loaded with 200,000 records; Table 2 with 100,000 records, and the other two tables with 40,000 records each. The expected rate of growth in the number of records is 20 percent each year for three years. What is the anticipated database capacity?
    Steps ( in case you don’t know where to start):
    a. For each table, sum the field sizes. This is the record size for the table. Avoid the implications of compression, coding, and packing – in other words, assume that each stored character and digit will consume one byte of storage. Note that formatting characters (commas, slashes and so forth) are almost never stored by the database. They are added by the application programs that will access the database and present the output to the users.
    b. For each table, multiply the record size times the number of entity instances to be included in the table. It is recommended that growth be considered over a reasonable time period (3 years). This is the table size.
    c. Sum the table sizes. That is the database size.
    d. Add a slack capacity buffer of 10 percent to account for unanticipated factors or inaccurate estimates above. This is the anticipated database capacity.
17. You are a systems designer and have a friend who owns a small bookstore and mail-order business specializing in rare books and first editions. Total sales average about a dozen books per day, store and mail order combined. Your friend wants to start selling books over the Web also, and has come to you for advice. He has heard that he should go with a relational database and that Oracle is the best one to get. Do you concur? If not, what would you recommend?

EXERCISES

1. CASE tools, such as System Architect, are used for database development and support. Search on the Web and in trade journals for some of the popular CASE tools currently in use.
   a. What CASE tools did you find, and who are their manufacturers?
   b. What is the number of installed bases, or IT shops, using each of these CASE tools?
   c. What is the range of cost for these CASE tools? Do you think they are cost effective?
   d. Compare and contract these CASE tools in terms of their features and capabilities.
   e. Which one would you use if you were a DBA and cost was not a concern? Why?
2. Currently, relational database technology is probably the most prevalent database technology used in modern information technology shops. But database technology is an evolving field and new technologies are being developed constantly. Search on the Web or in your school library for articles on emerging database technologies. Make sure to include white papers from major database companies.
   a. What articles and papers did you find? (you can limit it to the best 5).
   b. What are some of the new database technologies entering the market or under development?
   c. Compare them to relational database technologies.
   d. What influence does the growth of the Internet have on these database technologies?
   e. Which one, if any, do you feel is a serious contender to replace relational database technology? Why?