UARK ISYS 2103 Exam 3
Customer Relationship Management (CRM) - answera technology for managing all your
companies relationships and interactions with customers and potential customers
GOAL: Improve Business Relations - answergoal of CRM
Marketing/ Sales (CRM) - answer-have to know customers
-make the connection
-earn customer trust
Benefit for customers (CRM) - answer1. Organizations: allows efficiency by automating
elements of business
2. Optimization: simplify/ streamline customer interaction
3. Learn: Learn about purchasing a product
Customer Relationships Widen, Lengthen, and Deepen
Supply Chain and CRM - answer-Track data to see customers product preference
-the collection of data to get products where they need to go
SCM/ CRM integration - answer-Provides a system to execute supply chain
transactions, manage supply chain relationships, and monitor related processes
Accounting (CRM) - answer-Creates long term relationships, and documents it
-Introduction of Converged CRM
Finance (CRM) - answer-used for CUSTOMER COLLECTIONS and Outstanding
invoices
-BANKING
Human Resources (CRM) - answer-Employee resource management
-Profile MGMT, compensation, training, leave, certifications, data, and alerts
Why CRM is important - answer-Computers work all the time
- make customers feel unique
-Improved information
Advantages of Databases - answer-Minimal data redundancy
-Improved data consistency
-Increase Security
, -Improved Data quality
-Improved data accessibility and sharing
Advantages of Databases - answer-Enforcement of Standards
-Program-data Independence
-Increased Productivity of application development
-Reduced program maintenance
Intro to SQL - answer-Relational database mgmt system (RDBMS)
a. Create, update, administer data
-Introduction to Structured query language (SQL)
Data Definition Language (DDL) - answerCommands that define a database, including
creating, altering, and dropping tables and establishing constraints
Data Manipulation Language (DML) - answerCommands that maintain and query a
database
Writing SQL Statements - answer-NOT case sensitive
-one or more lines
-keywords can not be split across lines
-Each Sql statement (Not line) end with semicolon
Anatomy of a SQL statement- Select - answer-list the columns (or expressions) that
should be returned from the query
-What comes back in the Results?
Anatomy of a SQL statement- From - answer-Indicate the tables or views from which
data will be obtained
-Where did we go to get the results?
Anatomy of a SQL statement- Where - answer-Indicate the conditions under which a
row will be included in the result
-Which records do we include in the results?
Anatomy of a SQL statement- Group By - answer-Indicate categorization of results
-Aggregate by what?
Anatomy of a SQL statement- Having - answer-Indicate the conditions under which a
group will be included
- Which groups do we include in the results?
Anatomy of a SQL statement- Order By - answer-Sorts the result according to specified
Criteria
- In what order do we return the results?
Customer Relationship Management (CRM) - answera technology for managing all your
companies relationships and interactions with customers and potential customers
GOAL: Improve Business Relations - answergoal of CRM
Marketing/ Sales (CRM) - answer-have to know customers
-make the connection
-earn customer trust
Benefit for customers (CRM) - answer1. Organizations: allows efficiency by automating
elements of business
2. Optimization: simplify/ streamline customer interaction
3. Learn: Learn about purchasing a product
Customer Relationships Widen, Lengthen, and Deepen
Supply Chain and CRM - answer-Track data to see customers product preference
-the collection of data to get products where they need to go
SCM/ CRM integration - answer-Provides a system to execute supply chain
transactions, manage supply chain relationships, and monitor related processes
Accounting (CRM) - answer-Creates long term relationships, and documents it
-Introduction of Converged CRM
Finance (CRM) - answer-used for CUSTOMER COLLECTIONS and Outstanding
invoices
-BANKING
Human Resources (CRM) - answer-Employee resource management
-Profile MGMT, compensation, training, leave, certifications, data, and alerts
Why CRM is important - answer-Computers work all the time
- make customers feel unique
-Improved information
Advantages of Databases - answer-Minimal data redundancy
-Improved data consistency
-Increase Security
, -Improved Data quality
-Improved data accessibility and sharing
Advantages of Databases - answer-Enforcement of Standards
-Program-data Independence
-Increased Productivity of application development
-Reduced program maintenance
Intro to SQL - answer-Relational database mgmt system (RDBMS)
a. Create, update, administer data
-Introduction to Structured query language (SQL)
Data Definition Language (DDL) - answerCommands that define a database, including
creating, altering, and dropping tables and establishing constraints
Data Manipulation Language (DML) - answerCommands that maintain and query a
database
Writing SQL Statements - answer-NOT case sensitive
-one or more lines
-keywords can not be split across lines
-Each Sql statement (Not line) end with semicolon
Anatomy of a SQL statement- Select - answer-list the columns (or expressions) that
should be returned from the query
-What comes back in the Results?
Anatomy of a SQL statement- From - answer-Indicate the tables or views from which
data will be obtained
-Where did we go to get the results?
Anatomy of a SQL statement- Where - answer-Indicate the conditions under which a
row will be included in the result
-Which records do we include in the results?
Anatomy of a SQL statement- Group By - answer-Indicate categorization of results
-Aggregate by what?
Anatomy of a SQL statement- Having - answer-Indicate the conditions under which a
group will be included
- Which groups do we include in the results?
Anatomy of a SQL statement- Order By - answer-Sorts the result according to specified
Criteria
- In what order do we return the results?
