Author: Seema Kedar
Publisher: Technical Publications
Database Concepts and Systems Purpose of database systems, Views of data, Data models, Database language, Transaction management, Storage management, Database administrator, Database users, Overall system structure, Different types of database systems. E-R Model Basic concepts, Design issues, Mapping constraints, Keys, E-R diagram, Weak entity set, Extended E-R features, Design of an E-R database schema, Reduction of an E-R schema to tables. Relational Model Structure of relational database, The relational algebra, Views SQL-Background, Basic structure, SET operations, Aggregate functions, Null values, Nested subqueries, Derived relations, Views, Modification of database, Joined relations, DDL, Other SQL features. Transaction Transaction concepts, State, Implementations of atomicity and durability, Concurrent executions, Serializability, Recoverability, Transaction definition in SQL. Concurrency Control Lock based protocol, Timestamp based protocol, Validation based protocol, Deadlock handling, Insert and delete operations, Concurrency in index structure. Recovery System Failure classification, Recovery and atomicity, Log based recovery, Shadow paging. Graphical User Interface Murphy's law of GUI design, Features of GUI, Icons and graphics, Identifying visual cues, Clear communication, Color selection, GUI standard, Planning GUI design work. Visual Programming Sharing Data and Code : Working with projects, Introduction to basic language, Using inbuilt controls and activeX controls, Creating and using classes, Introduction to collections, Using and creating activeX components, Dynamic data exchange, Object linking and embedding. Creating Visual Software Entities : Working with text, Graphics, Working with files, File management, Serial communication, Multimedia control interfaces.Programming for the Internet : Using activeX controls on the web-the internet transfer control for HTTP, FTP. Database Programming : Database basics, Visual basic's database tools, Database designing and programming, DAO, RDO, ODBC, ADO, OLE DB, Relational databases, The data object models, Form and fields validation, Client server programming, COM-DCOM.