Lec15_Business+Analytics+II

Lec15_Business+Analytics+II - ISOM 101 Introduction to...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ISOM 101: Introduction to Information Systems Lecture 15: IS & Business Analytics II Prof. Heather H. Xu Course Structure Module #1 The new economy 1. Evolution of IT in Biz 2. Characteristics 3. Roles of IS Module #2 Fundamentals of IS 1. Components of IS 2. hardware/software/network 3. The Internet Module #3 Business Applications Strategies 1. Business Intelligence 2. Managing customer relations 3. Social implications of IS Module #4 Experience Sharing 1. Guest speakers from leading IT companies 2. Project presentations Objectives  What is the advantage of a database comparing to a file system?  Understand the different database models  Database Marketing • RFM analysis • Market Basket analysis • Google Basic Concepts How is data stored in any database?  Bits -> characters (letters, numbers, symbols) • E.g., a=10001101 • 1 byte = 8 bits  Field • Made up of one or more bytes, or characters • Field – individual piece of data • Examples: • Name • Address • Phone number  Record • Fields that are grouped together for a specific purpose • Example: your record on my computer (name, id, photo, email, major. …) 20129382 A my Wong Group QQ 20234876 Lily Lewis Group FB 32743524 Joe Winson Group QQ 23746423 Alex Tam Group QQ 45734653 Jimmy Tam Group FB 28935762 Alex Chan Group GPS 93457347 Howard Lee Group GPS 93588723 Doe Smith Group FB … … … … How many fields? How many records? Basic Concepts How is data stored in any database?  Primary key • A field, or group of fields, that uniquely identifies an individual record • E.g. your ID number • E.g. order number to describe “who sells which product to whom” • Notice, not every field can be a primary key. Why?  Table • Combines logically related records • E.g., records of all students in this class • Sales record at ParkNShop • Patients’ records at a hospital 20129382 A my Wong Group QQ 20234876 Lily Lewis Group FB 32743524 Joe Winson Group QQ 23746423 Alex Tam Group QQ 45734653 Jimmy Tam Group FB 28935762 Alex Chan Group GPS 93457347 Howard Lee Group GPS 93588723 Doe Smith Group FB … … … … Basic Concepts How is data stored in any database?  Database • Logically related tables form a database • E.g., a university database includes • A student record table • An employee record table • A course listing table One Example A Character: 10001101 One Example Amy Field: First name One Example 20129382 Amy Wong Group QQ Record: some student’s info One Example 20129382 Amy Wong Group QQ 20234876 Lily Lewis Group FB 32743524 Joe Winson Group QQ 23746423 Alex Tam Group QQ 45734653 Jimmy Tam Group FB 28935762 Alex Chan Group GPS 93457347 Howard Lee Group GPS 93588723 Doe Smith Group FB … … … … Table: Student file One Example MKT Mike Wong 8723 ACCT James Dole 8712 ISOM Andy Jenings 8798 … … … … Table: Professor file Database 20129382 Amy Wong Group QQ 20234876...
View Full Document

{[ snackBarMessage ]}

Page1 / 59

Lec15_Business+Analytics+II - ISOM 101 Introduction to...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online