Business Informatics

Contents 

1.Introduction to Computer

1.1Introduction

1.2Characteristics of computers

1.3Basic structure of a computer

1.4Types of computers

1.5Application areas of computers

1.6Types of programming language

1.7Data organization

1.8Types of memory (Primary and Secondary)

1.9Input  / output devices

1.10Representation of numbers

2.Operating System and Services

2.1Introduction

2.2DOS software

2.3Booting process

2.4Files and directories in DOS

2.5Wildcard characters

2.6Redirection in DOS

2.7DOS commands

2.8Batch files

2.9Types of operating system

3.Windows Operating Environment

3.1Operating environment – windows

3.2Components of the windows Operating System (O.S.)

3.3Running windows applications

3.4 Switching between applications

3.5Windows utilities

3.6Difference between DOS and windows operating system

4.Editors and Word Processors

4.1Introduction

4.2Word processor

4.3Microsoft word

4.4Elements of Ms-word

4.5 Viewing the toolbars

4.6 Description

4.7 Main menu options

4.8 Operations for Ms-word

4.9 Creating and managing tables

4.10 Find and replace text

4.11 Desktop publishing

5.Spreadsheets and Database Packages

5.1Introduction

5.2Microsoft excel

5.3 Ms-powerpoint

5.4 Microsoft access

6.Introduction to Relational Database Management System

6.1Introduction

6.2Data hierarchy

6.3An entity, a record and a file

6.4Storing and accessing of data records

6.5Problems with the traditional file environment

6.6What is a data base management system?

6.7The objectives of Data Base Management System (DBMS)

6.8Components of a Data Base Management System (DBMS)

6.9Advantages of Data Base Management System (DBMS)

6.10Relational Data Base Management System (RDBMS)

6.11Constraints in database

6.12Creating the database

7.Entity Relationship (ER) Model

7.1Introduction

7.2The ER model

7.3Steps / rules for constructing an E-R diagram

7.4Case studies of E-R diagrams

8.Normalization

8.1Introduction

8.2What is normalization?

8.3Goals of normalization

8.4Concept of functional dependency

8.5Process of normalization

9.Structured Query Language (SQL)

9.1Introduction

9.2Characteristics and advantages of SQL

9.3The parts of SQL

9.4Basic structure of SQL

9.5SQL data types

9.6SQL commands about tables

9.7SQL statements

Included Question Papers – April 2012