Business Information Management: Exercises

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

Click here to see the database files used in this book.