Class Notes (1,100,000)
CA (620,000)
UBC (10,000)
COMM (700)
Lecture 5

COMM 205 Lecture Notes - Lecture 5: Rade People, Order Of Merit, Horse Length


Department
Commerce
Course Code
COMM 205
Professor
Adam Saunders
Lecture
5

This preview shows pages 1-3. to view the full 11 pages of the document.
COMM 205
Introduction to Management
Information Systems
Winter 2015 - Section 201
COMM 205
Introduction to Management
Information Systems
Winter 2015 - Section 201
Database Concepts and
Managing Data
Database Concepts and
Managing Data
Learning ObjectivesLearning Objectives
1. Explain the importance of databases.
2. Describe the fundamental concepts of the
relational database.
1. Explain the importance of databases.
2. Describe the fundamental concepts of the
relational database.
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 3
Learning Objective 1Learning Objective 1
Explain the importance of databases.Explain the importance of databases.
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 4

Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

Why Businesses Use Database?Why Businesses Use Database?
Businesses need information to run their
operations
What are the sales from June?
When will people come into our stores?
Who are our employees? How much should they
be paid?
Businesses need information to run their
operations
What are the sales from June?
When will people come into our stores?
Who are our employees? How much should they
be paid?
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 5
Storing Transactional DataStoring Transactional Data
Transactional data is stored in databases.
Database – a collection of records about various
business categories such as:
resources (inventory)
events (sales, payroll)
people (employees)
places (warehouses, stores)
Information systems maintain and access the
transactional data in databases.
Transactional data is stored in databases.
Database – a collection of records about various
business categories such as:
resources (inventory)
events (sales, payroll)
people (employees)
places (warehouses, stores)
Information systems maintain and access the
transactional data in databases.
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 6
For discussion …For discussion …
Think about the value chain (supply chain),
business processes and lululemon
Think about the value chain (supply chain),
business processes and lululemon
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 7
For discussion (cont’d)For discussion (cont’d)
What information can lululemon collect that may
be useful to their suppliers?
What information would lululemon want to know
about their supply chain?
What information can lululemon collect that may
be useful to their suppliers?
What information would lululemon want to know
about their supply chain?
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 8

Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

Business Data Management Business Data Management
Who would give us this information?
How can we ensure that it is accurate?
Some of what we are talking about is data
and not information. Can you think about
what would be the data we need for this
information?
How do we get the hard-to-find data? For
instance, how do we get certain types of
customer information?
Who would give us this information?
How can we ensure that it is accurate?
Some of what we are talking about is data
and not information. Can you think about
what would be the data we need for this
information?
How do we get the hard-to-find data? For
instance, how do we get certain types of
customer information?
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 9
Importance of Managing DataImportance of Managing Data
An effective information system provides
Timely Information
Quality Information
Relevant Information
Data should be stored and managed
efficiently in electronic storage devices.
Databases are efficient ways to do this.
An effective information system provides
Timely Information
Quality Information
Relevant Information
Data should be stored and managed
efficiently in electronic storage devices.
Databases are efficient ways to do this.
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 10
An Example of Low Quality DataAn Example of Low Quality Data
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 11
So What?So What?
What is so big deal about putting data into a
database?
How can you ensure that
there is no data redundancy?
data can be shared?
oAlso, how can data be shared in a way that it does not
violate privacy and confidentiality?
there is data consistency (or data integrity)?
Can you think of examples that the above can
happen?
What is so big deal about putting data into a
database?
How can you ensure that
there is no data redundancy?
data can be shared?
oAlso, how can data be shared in a way that it does not
violate privacy and confidentiality?
there is data consistency (or data integrity)?
Can you think of examples that the above can
happen?
COMM 205 - Winter 2015 Term 2
© 2016 – Y.M. Cheung 12
You're Reading a Preview

Unlock to view full version