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