Summary CS1032 EXAM Notes

1/14/23, 12:04 AM CS1032 EXAM Notes




CS1032 EXAM NOTES

Table of Contents
CS1032 EXAM NOTES...............................................................................................................1
Unit 1 – Introduction to Business.......................................................................................................2
Example Questions:...............................................................................................................................................3
Unit 2 – Database Design...................................................................................................................3
Example Questions:...............................................................................................................................................9
Unit 3 – Data & Information Systems...............................................................................................10
Example Questions:.............................................................................................................................................11
Unit 4 – Competitive Strategies & Business Processes......................................................................14
Example Questions:.............................................................................................................................................16
XML Files..........................................................................................................................................17
Example Questions:.............................................................................................................................................17
XSD – XML Schema...........................................................................................................................17
Example Questions:.............................................................................................................................................18
Unit 5 – Supply Chain Management.................................................................................................19
Example Questions:.............................................................................................................................................23
Unit 6 – Infrastructure and Integration.............................................................................................23
Example Questions:.............................................................................................................................................25
Unit 7 – Connecting to the Outside World........................................................................................25
Example Questions:.............................................................................................................................................29
SQL...................................................................................................................................................29
Example Questions:.............................................................................................................................................32
Unit 8 – Decision Processes and Business Practices..........................................................................33
Example Questions:.............................................................................................................................................36
Unit 9 – Organization and Security...................................................................................................37
Unit 10 – Planning and Support........................................................................................................40
Example Questions:.............................................................................................................................................43
MS Excel...........................................................................................................................................43




about:blank 1/46

,1/14/23, 12:04 AM CS1032 EXAM Notes




Unit 1 – Introduction to Business
 The first computers introduced into businesses were made by IBM, 37 years ago (1981)
 Business require money in and money out to operate
 The main goal in business is more money coming in than going out
 The margin for the business is the difference between the money coming in and going
out
 A positive margin is considered success, while a negative margin is considered failure

First rule of business: More money in than out  a margin
Second rule of business: It takes money to make money
Third rule of business: “Nobody knows nothing”

When you have a positive margin…
In a for-profit business, it’s called profit
In a not-for-profit, it’s called a surplus
In the government, it’s called under budget
- You want a large margin to:
o Have a back fall/buffer
o Keep your interest rates down
o Pay back investors

Course definition of business: any endeavor or enterprise that achieves a goal through the
effort of a person or persons that involves a monetary component
 Anything where money is involved
o A dollar value can be put on an action (mow lawn, wash car)

*In order to run a successful business, YOU MUST TRACK EVERYTHING*
How do you run a business?
- What to track?
o Data
 How much did this material cost?
 How much did this equipment cost?
- How to track it?
o BP (before computers)
 Paper/index cards
 Ledger books
 Policy
o AP (after computers)
 Databases: everything is collected
 Spreadsheets: accounting
 IT Systems: using the information




2




about:blank 2/46

,1/14/23, 12:04 AM CS1032 EXAM Notes




Organizational Strategy
1. Industry structure
- Examine the structure of their industry
2. Competitive strategy
- Determine a competitive strategy
3. Value chains
- Which determines the value chains?
- What parts does your business contain?
4. Business processes
- Determine the businesses processes
- The business process is the day to day
- How do you conduct business?
5. Information systems
- Nature of business processes determines the structure of the IS

Example Questions:
1. Which of these is considered an action that could a business?
a) Taking out your neighbors’ trash as a favour
b) Selling lemonade on the road side
c) Working for your parents for free

Solution: a

2. Which of these would be the most successful business?
a) Margin of negative $15,000
b) Margin of positive $200
c) Margin of positive $500

Solution: c

Unit 2 – Database Design
Databases
 Databases
 DBMS
 Database application
 Enterprise vs. Personal DBMS

DBMS  Database Management Systems
Oracle is the most used database management system



Enterprise DBMS

3




about:blank 3/46

, 1/14/23, 12:04 AM CS1032 EXAM Notes




- Process organizational and workgroup databases
- Large databases
- Support many, many users
- Used for large businesses
Personal DBMS
- Designed for smaller, simpler database applications
- Supports fewer than 100 users
- Examples: Access, dBase, FoxPro, Paradox, R:Base
- Could be used for a small business

Organizations may store…
 Data
 Documents
 Spreadsheets
 Presentations
 Web pages
 Text from blogs and discussion boards
 Graphics
 Video files
 Audio files

The challenge is NOT collecting, but distributing and presenting the content

Content Management
 Management of content data
o Database management systems (DBMS)
 Effectively & efficiently storing & processing data
 Presentation of content
o Content management system (CMS)
 Organizing documents
 Seek out documents & organize access

Spreadsheet vs. Database
Spreadsheets
- SINGLE THEME/CONCEPT
Databases
- MULTIPLE THEMES/CONCEPTS

Rational Database: groups of data that are related to each other in a meaningful way
 Conceptually simple
 Easy to understand
 Relationships aren’t predefined
 Database can evolve as required
 Relationships are implied in the data
4




about:blank 4/46