M07

Introduction to Database Management, Programming Techniques ( C++ with OOPS), e-Commerce Technology
Code: 
M07
Year / Semester: 
1st Semester
Objective: 

To equip students with the knowledge of Database Management, Programming Techniques and e-commerce Technology.

Credits: 
4

INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

Introduction to Database Management

Database Management System, Advantages of Database Processing, Disadvantages of Database Processing.

The Relational Model – QBE and Relational Algebra

Relational Databases, QBE, Simple queries, Simple criteria, Compound Criteria, Computed Field, Calculating statistics, Grouping, Sorting, Joining Tables, Using an update query, Delete Query Make table query, Relation Algebra,

The SQL

Introduction, Table creation, Simple Retrieval, Compound conditions, computed field, Using special operator, sorting, Built-in functions, Nesting queries, Grouping, Joining tables, union, Updating Tables, Creating table from a Query, SQL commands.

Relational Model SQL – Advance

Introduction, Views, indexes, Security, integrity Rules, Structure Changes, System catalogue.

Database Design – Normalization

Introduction, Functional dependence, Keys, Normal forms, Incorrect Decompositions, Multi-valued Dependencies, Avoiding the problems with multi-valued dependencies, Applications to Database Design.

Database Designing methodology

Introduction, user views, information Level Design Methodology, Represent the user view as a collection of tables, Normalize the tables, Represent all Keys, Merging the result into the Design, Physical level Design, Survey form, Obtaining information form from Existing Documents. Relationship consideration, Nulls and Entity subtypes, the entity relationship model.

DBMS Functions

Introduction, update and retrieve data, Provide catalog services, Support concurrent update, Recover Data, Security services, Data Integrity Features, Support Data Independence, Support Data replication, Utility services.

Database Administration

Introduction, Database policy formulation and enforcement, Other Database administrative Functions, DBMS maintenance, Technical functions.

PROGRAMMING TECHNIQUES (LOGIC BUILDING AND C++WITH OOPS)

Introduction

History Types of languages Structured Language Object oriented programming OOPS terminology and features

Algorithms and Flow Charts

Algorithms Definition, needs and characteristics Flow Charts Rules, Advantages and implementation Concepts of loping and counting

Program Development

Program identification Analysis Program design Coding Debugging Testing Documentation Maintenance Characteristics of a Good program

Data Types

Primary data types Tokens Variables and literals Keywords and operators C++ Data Types Operators and Expressions Types of operators Precedence of operators

Decision Making, Branching and Looping

Branching if, if- else, if-else-if statement switch Statement Conditional operator goto statement Looping while, do- while, for statements Nesting of loops, jumping in loops

Arrays

One dimensional array Declaration of array Initializing of arrays Two dimensional arrays Initializing two dimensional arrays Multidimensional arrays

Pointers

Introduction Dynamic and Static allocation of memory Pointer variable Pointer and arrays Arrays of pointers Dynamic memory allocation operators this pointer

User defined functions

Why use functions The format of C++ function Calling a function Types of functions Functions, arguments and return values Recursion of functions Variables in functions Automatic, External, Static and register variables

Structures and Unions

Structures, definitions Assigning and initializing values of structure members Comparing structure variables Arrays of structures Arrays of members in structure Unions Nested Structure Size of operator Defining the size of structure

Class and Objects

Definition of class and object OOPs properties Member variable and member functions Friend functions Class member access- private, public and protected Array of class objects Structured union, nested class

Constructors and Destructors

Definition of constructor and destructors Need Declaration and definition Types of constructors- default, parameterized, copy

Polymorphism

Definition Type of polymorphism Definition of function overloading and operator overloading Operator overloading and friend functions Syntax of operator overloading Overloading of unary and binary operator Constructor overloading

Inheritance

Definition Base class and sub class Inheritance mode Types of inheritance

File handling

Definition of files and streams Opening and closing of files Stream checking File modes Types of files getline function File pointer 

e - COMMERCE TECHNOLOGY

E- commerce: An Introduction

Introduction, Transaction, E- Commerce’s history, Types of E- commerce, Consumer- to – business

Introduction to word wide web

Introduction to web, Web architecture, Web and electronic commerce, Web and internets, Use of web in E- commerce, External web interface

Advantages of E- commerce

Introduction, Accepting orders, Selling advertising space, Selling and trading online advertising space, Selling Soft ware of others downloadable goods, Charging visitors for access to your site

Business and finances

Taking existing business to the web, Getting software for business plans

Planning your site

Introduction, designing your web site, Steps for developing your site, Basic layout of your site, Choosing the contents and color, art and fonts

Registering your name

Understanding domain names, choosing domain names, Registering with inter NIC.

Checking, hosting your site, promotions and publicity

Security issues

Digital signature, Digital certificates, Implementation and Management issues

Introduction to IT Act 2000

Suggested Readings: 
  1.  ELMASRI NAVATHE, Fundamentals of database System.
  2. Database System Concept, Silberschatz, Korth. Sudarshan
  3. Yashavant Kanetkar.Introduction To OOPS & C++