E-COM (B-TECH Information Technology 5th)

Objective: The objective of the course is to offer good understanding of database

design, modeling and implementation of database management systems.

Introduction - Database Systems versus File Systems, View of Data, Data Models,

database languages, Database Users and Administrators. Transaction Management,

Decision Support Systems, Components of a Database management System.

Distributed Processing and Client- Server Architecture. Entity-Relationship Model –

Basic Concepts, Constraints, Keys, Design Issues, E-R Diagrams.

Relational Model - Structures of relational databases, Integrity Constraints, Logical

database Design, Tables, Views, Data Dictionary. Relational Algebra, Relational

Calculus. SQL – Basic Structures, Query Handling, Embedded SQL, Open Database

Connectivity (ODBC), Java Database Connectivity (JDBC), Triggers, Security and

Authorization. Query By Example (QBE), User Interfaces and Tools, Forms and

Graphical User Interfaces. Report Generators. Overview of Relational Query

Optimization.1. Introduction to Electronics Commerce [15%]

 Defining Electronics Commerce, Forces fueling Electronics Commerce,

Electronics Commerce Industry Frame work, Types of Electronics Commerce.

2. World Wide Web and its applications [20%]

 Brief history and introduction of WWW, The web and the Electronics

Commerce, Key concepts behind Web, Web and Database Integration, Web

Software development tools (HTML, XML, UML, Java script, VB script, ASP,

JSP), Multimedia Web extensions (VRML, Real Audio, Internet and Web based

Technology), Directories and search engines.

3. Firewalls and Transaction security [15%]

 Introduction to firewalls and network security (Types, policies and Management),

Transaction Security, Encryption and Transaction Security, The comparison of

encryption methods, Security in WWW (Netscape's secure socket layer, security

and online web based banking)

4. Electronics Payment Systems [8%]

 Overview of the Electronics payment technology, Electronics cash, Electronics

checks, online credit cards based system, other emerging financial instruments.

5. Electronics Commerce and banking [8%]

 Home Banking, Banking via the PC using Internet/Intranet, Banking via online

services, Banking via Web.

6. Electronics Commerce and Retailing [8%] Changing Retail industry dynamics and

technology improvements in Electronics retailing, Mercantile models from consumers

perspective .

7. Supply chain management [8%]

 Fundamentals and management of supply chains, Supply chain application

software ad its future.

8. Roadmaps to E-Business [8%]

 Challenges and strategy creation, Roadmaps to E-Business.

9. Translating E-Business strategy into action [10%]

 Beginning of a virtual factor, E-business blueprint creation, E-Business project

planning checklist, an execution blueprint, Failures of E-Business Initiatives