Foundation of Business Intelligence: Databases and Information Management

Topics: SQL, Database management system, Database Pages: 16 (3934 words) Published: August 31, 2014


Assignment on
Foundation of Business Intelligence: Databases and
Information Management
Course: Computer and Information Management (CIS-501)
Program : MBA

Prepared by:
ID
Name
Intake &Program
13141301001
Aziza Md. Aziz
19th EMBA
13142201058
Md. Azizul Hasan
30th MBA

Prepared to:
Mr. Mohammad Raisul Alam
Chairman and Assistant Professor
Faculty of Engineering and Applied Science
BUBT

Table of Content

Sl. No.
Description/Content
Page Number
1.
Introduction
3
2.
Problems of Managing Data resources in a traditional file environment and how they are solved by data management system 4
3.
Major capabilities of database management systems (DBMS) and the reason of Relational database becoming so powerful 7
4.
Important principles of database designing
9
5.
Principal tools for accessing information from database to improve business performance and decision making 11
6.
Reasons of Information policy, data administration and data quality assurance essential for managing a firm’s data resources 15
7.
Closure
16
8.
References
17

1. Introduction
Database systems are the information heart of modern enterprises, where they are used for processing business transactions and for understanding and managing the enterprise. Business intelligence is the analysis of data to produce insights useful for managing the enterprise and increasingly, in routine business operations such as intelligent supply chain management. The knowledge of Database Management helps business intelligences to know transaction processing and decision support, how to use data mining technologies to discover the structure, trends, and relationships in the data to produce valuable business insights and effective decision support processes. This assignment includes the following relevant issues regarding Database and Information Management: 1. Problems of Managing Data resources in a traditional file environment and how they are solved by data management system 2. Major capabilities of database management systems (DBMS) and the reason of Relational database becoming so powerful 3. Important principles of database designing

4. Principal tools for accessing information from database to improve business performance and decision making 5. Reasons of Information policy, data administration and data quality assurance essential for managing a firm’s data resources This assignment will be a very helpful as a source of information to get a clear concept of what is database, how DBMS and relational database helps business intelligence to solve business problems, tools of database to improve business performance, importance of Information policy, data administration and data quality assurance for managing a firm.
2. Problems of Managing Data resources in a traditional file environment and how they are solved by data management system

File Organizing Terms and Concepts

In a traditional file organizing concept a computer system organizes data in a hierarchy that starts with bits and bytes and progresses to fields, records, files and database. A Bit represents the smallest unit of a data (o and 1). The widely used code conversion method is known as “American Standard Code of Information Interchange” (ASCII). A Byte is a group of bits. (1 Byte consists of 8 bits) It represents a singly character/letter/number or symbol. A field is a group of words or a complete number or contents of Bytes. A record is a group of related fields/data.

A file is a group of records of same types.
A database is made up of a group of related files.

Problems with the traditional file environment:
In most organizations, systems tend to grow independently without a company-wide plan. Accounting, finance, manufacturing, human resources and sales and marketing all develop their own systems and data files. Each application requires its own files and its own computer program to operate. This process leads to...

References: 1. Class Lectures
2. Management Information System by Laudon and Loudon
3. http://www.bu.edu/met/programs/graduate/computer-information-systems/database-management-business-intelligence-certificate/
4. file:///C:/Users/SAMSUNG/Desktop/Database-Example-Design.pdf
5. http://searchdatamanagement.techtarget.com/definition/OLAP
6. http://www.techopedia.com/definition/1174/data-cleansing
7. http://en.wikipedia.org/wiki/Hierarchical_database_model
8. http://en.wikipedia.org/wiki/Network_model
9. http://www.actacommercii.co.za/index.php/acta/article/viewFile/44/44
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Cloud database management system Essay
  • Management Information System and Business Strategy Essay
  • DATABASE MANAGEMENT Essay
  • Essay on Use of Database Management Systems to Meet Business Needs.
  • Management Information Systems Essay
  • Business management Essay
  • Essay on Business Management
  • Essay about MANAGEMENT OF BUSINESS

Become a StudyMode Member

Sign Up - It's Free