New User Special Price Expires in

Let's log you in.

Sign in with Facebook


Don't have a StudySoup account? Create one here!


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

Ch 11 Behind the Scenes: databases & info systems, Microcomputer Applications for Business

by: Gianna Molinare

Ch 11 Behind the Scenes: databases & info systems, Microcomputer Applications for Business CGS2100

Marketplace > Florida State University > CGS2100 > Ch 11 Behind the Scenes databases info systems Microcomputer Applications for Business
Gianna Molinare

Preview These Notes for FREE

Get a free preview of these Notes, just enter your email below.

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

These notes are based on the class lecture and some of its contents will be found in Exam #2.
Intro to Microcomputer Applications for Business
Jack Winston
Class Notes
business, Computer
25 ?




Popular in Intro to Microcomputer Applications for Business

Popular in Department

This 3 page Class Notes was uploaded by Gianna Molinare on Friday July 22, 2016. The Class Notes belongs to CGS2100 at Florida State University taught by Jack Winston in Summer 2016. Since its upload, it has received 9 views.


Reviews for Ch 11 Behind the Scenes: databases & info systems, Microcomputer Applications for Business


Report this Material


What is Karma?


Karma is the currency of StudySoup.

You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 07/22/16
Ch 11 Behind the Scenes: databases & information systems  Database building blocks o A database is a collection of related data, which can be:  Stored  Sorted  Organized  Queried o Databases make data more meaningful & useful o Databases turn data into info o Advantages of using databases:  Databases can manage large amounts of data efficiently  Databases make info sharing possible  Databases promote data integrity o Disadvantages of using databases  Can be more time-consuming & expensive to set up & administer  Care is needed to insure they function as intended  Administrator is responsible for designing, constructing, and maintaining databases o Planning & creating database  How data tables are created:  Step 1: input unique field names  Step 2: define data type  Step 3: set a maximum field size  Step 4: set a default value if necessary  Repeat for each field in the table  Database types o 3 major types of databases:  Relational  Object-oriented  Multidimensional  Databases that are set up to facilitate drilling down to retrieving data  Relational databases are the most commonly used  Organizes data in table format  Logically groups similar data into a relation  Common field in 1 table (primary key) linked to common field (foreign key) in 2nd table  Need to keep data in related tables synchronized  Where you need to avoid redundancy  Object-oriented databases  Store data in objects rather than tables  Contain methods for processing or manipulating data  Can store more types of data than relational databases  Can access data faster  Multidimensional databases  Database functions  Functions  Populate database by creating records  Allow users to extract subsets of data from database  Output data in meaningful & presentable format  How businesses use databases  Database warehousing & storage  Large-scale collection of data  Contains & organizes data in 1 place  Data comes from multiple databases  Consolidates info from various systems  Presents enterprise-wide view of operations  Business intelligence systems  Software-based solutions to gather & analyze info  Deliver up-to-the-minute data  Integral bc they store functional info  All perform similar functions  Office support systems  What an office support system accomplishes:  Office support system (OSS) is designed to improve  Transaction-processing systems  Batch processing  Data is accumulated, then several transactions are processed at once  Appropriate for activities that aren't time-sensitive  Often more efficient  Management info system (MIS)  Provides timely & accurate info  Enables managers to make critical decisions  Directs outgrowth of TPS  Powerful if organized & outputted in useful form  Often included as feature of TPS  Can generate various reports  Decision support system (DSS)  Another type of business intelligence system  Designed to help managers develop solutions for specific problems  Uses info from databases & data warehouses  Users can add own insights & experiences to solution ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~  Ethics & data o Before social media, database managers were challenged to collect & collate customer data into coherent format & provide managers w/ data-driven decision options o Early methods included collecting business cards & transcribe data o Rise of social media provided treasure trove of customer & consumer data  Knowledge Discovery & Data Mining o 1 factor that drives data mining= evolution of affordable high- performance computers that are able to slice & dice petabyte size databases o There are highly complex methods of data mining  Major classes of data mining o Anomaly detection- looks for data out of defined range o Association rule learning- dependency modeling o Clustering- histogram analytics o Classification- sorting data by known characteristics o Regression- modeling w/ least errors (Chi) o Summarizing- data compaction w/ analysis, display conclusions in brief manner  Data analytics o Science of examining raw data w/ purpose of concluding info o Distinguished from data mining by scope, purpose, & focus of analysis o Focuses on inference, process of deriving conclusion based solely on what is already known by researcher o Exploratory data analysis- where new features in data are discovered o Confirmatory data analysis- where existing hypotheses are proven true or false o "analytics" has been used by many business intelligence software vendors as buzzword  Data for sale o Harvested data are processed & stored in data warehouses o Metadata are used to facilitate search & retrieval of data of interest o Predictive model markup lang= example of methods used for data analysis  Ethical fallout from data mining


Buy Material

Are you sure you want to buy this material for

25 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


You're already Subscribed!

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

Why people love StudySoup

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Allison Fischer University of Alabama

"I signed up to be an Elite Notetaker with 2 of my sorority sisters this semester. We just posted our notes weekly and were each making over $600 per month. I LOVE StudySoup!"

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Parker Thompson 500 Startups

"It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

Become an Elite Notetaker and start selling your notes online!

Refund Policy


All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email


StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here:

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.