Exam (elaborations)
UARK ISYS 2103 Exam 3. Questions with Solutions
- Course
- Institution
UARK ISYS 2103 Exam 3.
[Show more]
Content preview
UARK ISYS 2103 Exam 3Customer 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?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller julianah420. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now