Business Information Management: Exercises

Solutions to Hands on Exercises

Avaliações:
( 27 )
41 pages
Idioma:
 English
This is the exercise book for Business Information Management.
Este é um e-book grátis para estudantes
Inscreve-te para acesso grátis
Todos os livros de estudantes são grátis para sempre. Menos de 15% de anúncios
 
Período de 30 dias grátis
Subscrição para empresas grátis nos primeiros 30 dias, após o período $5.99/mês
Última adição
Sobre o autor

Dr Vladlena Benson is a Course Director of the MA Management programme at Kingston Business School, and a Senior Lecturer at the Department of Informatics and Operations Management, Kingston University. She teaches Information Management Strategy to MBA students in the UK and Russia, and is a visiting...

My key desire is to help students to increase knowledge and understanding as well as increasing my own knowledge and abilities by continuing my professional development.


Specialties:

Stakeholder Management

Project Management

Change Management

...
Description
Content

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