Categories Pricing Corporate
Free Textbook

Business Information Management: Exercises

Solutions to Hands on Exercises

(27 ratings)
41
Language:  English
This is the exercise book for Business Information Management.
Download free PDF textbooks or read online. Less than 15% adverts
Business subscription free for the first 30 days, then $5.99/mo
Description
Preface
Content
book.tabs.appendix

This is the exercise book for Business Information Management. Each chapter provides a comprehensive coverage of relevant theory concepts followed by review questions, and/or case studies and worked examples. Many practical examples are included to illustrate the data analysis concepts. These exercises should help students acquire hands on skills, prepare for assessment and solve types of problems encountered in employment.

Information management is vital for today’s businesses. It requires significant investment and supports critical business processes. With the proliferation of the information economy and information systems, effective information management determines success of virtually every business operation. Obtaining business value from vast amount of information collected by businesses is no longer only a technological challenge. The choice of decision making tools and information solutions rests with the business, as well as with IT managers.

Key Features

Each chapter provides a comprehensive coverage of relevant theory concepts followed by review questions, and/or case studies and worked examples. Many practical examples are included to illustrate the data analysis concepts. These exercises should help students acquire hands on skills, prepare for assessment and solve types of problems encountered in employment. The book is supported by:

- A downloadable versions of the database files used in this book

- Solutions for instructors

Starting with a general introduction to information management the text takes the reader through the essential concepts of data analysis in Microsoft™ Access 2007. It presents an overview of the relational data model and data management using SQL. The data analysis chapters start with the preliminary concepts of database organisation and a gentle introduction to basic SQL. Further chapters introduce more advanced concepts of built-in functions, joining information from several tables and nested queries.

  1. Introduction to Information Management
    1. Summary
    2. Answers to the Review Questions
    3. Case Study: Walmart Harnesses RFID Technology to Improve Efficiency
  2. Relational Data Model and SQL
    1. Summary
    2. Solutions to Exercises
  3. Data Definition in SQL
    1. Summary
    2. Solutions to Exercises – DDL and DML activities
  4. Advanced Selection Queries
    1. Summary
    2. Solutions to Exercises – Order As and Selection
  5. Joining Tables
    1. Summary
    2. Solutions to Exercises – Join, Selection and Projection
  6. Functions, Aggregate and Group-set Functions
    1. Summary
    2. Exercises
  7. Information Security Management
    1. Suggested Discussion Points for Exercises
    2. External Resources and Links
About the Authors
Kate

Kate Davis

Prof. Vladlena Benson