Please see attached instructions and notes.
Referencing not needed for for this project.
Project for Chapter 3 Choose either Option A or Option B. Paper MUST be minimum of 500 words Option A Austin Peay State, a university near Nashville, Tennessee, is applying a data-mining approach to higher education. Before students register for classes, a robot looks at their profiles and transcripts and recommends courses in which they are likely to be successful or have higher chances of success. The software takes an approach similar to the ones Netflix, eHarmony, and Amazon use to make their recommendations. It compares a student’s transcripts with those of past students who had similar grades and SAT scores. When a student logs in, the program offers 10 “Course Suggestions for You.” This recommendation is based on the student’s major and other information related to that student. The goal is to steer students toward courses in which they will make better grades. According to Tristan Denley, a former programmer turned math professor turned provost, students who follow the recommendations do substantially better. In the fall of 2011, 45 percent of the classes that students were taking had been on their top 10 recommendations list. This data-mining concept is catching on. Three other Tennessee colleges now use Denley’s software. Institutions outside the state are developing their own versions of the idea. 1. Which other companies are using approaches similar to the one used by Austin Peay State? 2. Based on which data does the system make a course recommendation to a student? 3. What are the benefits and drawbacks of this approach to course recommendations? 4. Are there any data that should or should not be included in data mining for this purpose? Why or why not? OR Option B With more than 200 million registered users, Pandora Radio is a personalized Internet radio service that helps you find new music based on your past and current favorites. (The service is also available to mobile devices as an app.) The success of Pandora Radio’s business model derives from applying data-mining tools to the Music Genome Project, which is a vast database of songs that a team of experts has broken down into their various components: melody, rhythm, vocals, lyrics, and so on. Listeners begin by entering their favorite songs, artists, or genres, creating customized “stations.” Then, Pandora Radio mines its database to find songs that are similar. Another data-mining tool that Pandora uses is the like/dislike (thumbs up/thumbs down) option that accompanies each song the site suggests. These responses are also factored into which songs the Web site decides to play for the user. 1. How does Pandora Radio recommend music to its listeners? 2. How are the listeners of Pandora Radio able to create their customized stations? 3. What are some variables that Pandora Radio uses to recommend a song? PowerPoint Presentation Module 3 Data and Business Intelligence Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Learning Objectives (1 of 2) Define a database and a database management system Explain logical database design and the relational database model Define the five components of a database management system Summarize three recent trends in database design and use Explain the four major components and functions of a data warehouse and their use for business Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Learning Objectives (2 of 2) Describe the functions of a data mart Explain business analytics and describe its role in the decision-making process Explain the advantages and challenges of big data and predictive analytics for a business Explain database marketing and its business applications Explain key features of Tableau and Power BI as two popular business intelligence and visualization platforms Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Databases Database Collection of related data that is stored in a central location or in multiple locations Data hierarchy Structure and organization of data, which involves fields, records, and files Database management system (DBMS) Software for creating, storing, maintaining, and accessing database files Makes using databases more efficient Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Exhibit 3.2 Interaction between the User, DBMS, and Database Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Types of Data in a Database Internal data Collected from within an organization Stored in the organization’s internal databases and can be used by functional information systems External data Comes from a variety of sources Stored in a data warehouse Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Methods for Accessing Files (1 of 3) Sequential access file structure Records in files are organized and processed in numerical or sequential order Records are organized based on a primary key (e.g., Social Security numbers or account numbers) Used for backup and archive files because they rarely need updating Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Methods for Accessing Files (2 of 3) Random access file structure Records can be accessed in any order, regardless of their physical locations in storage media Fast and very effective when a small number of records need to be processed daily or weekly Records are stored on magnetic disks to achieve speed Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Methods for Accessing Files (3 of 3) Indexed sequential access method (ISAM) Records accessed sequentially or randomly, depending on the number accessed Random access: used for a small number Sequential access: used for a large number Uses an index structure and has two parts Indexed value Pointer to the disk location of the record matching the indexed value Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Logical Database Design (1 of 3) Information is viewed in a database in two ways Physical view: how data is stored on and retrieved from storage media Logical view: how information appears to users and how it can be organized and retrieved Depending on the user, there can be more than one logical view of data Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Logical Database Design (2 of 3) Data model determines how data is created, represented, organized, and maintained Includes: Data structure Operations Integrity rules Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Logical Database Design (3 of 3) Hierarchical model Relationships between records form a treelike structure Records are called nodes, and relationships between records are called branches Network model Similar to the hierarchical model but records are organized differently Each record can have multiple parent and child records Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Exhibit 3.3 A Hierarchical Model Bidgoli, MIS, 10th Edition. © 2021 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Bidgoli