DBMS-I

Data Processing Fundamentals: Introduction, Data, Information and Data Processing, Data structure, Need for Data Processing, Data Processing Cycle, Methods of Data Processing, Applications of Data Processing, Advantages and Disadvantages of Electronic Data Processing.

File structure: Files, Logical and physical file, Basic File Operations, Types of File Organizations (Unordered or heap or serial files, Ordered or sequential file, Hash file, Indexed Sequential, Direct access and Random files).

Introduction: Database, Database System Applications, Database Systems versus File Systems, Purpose of Database Systems, View of Data, Database Languages, Relational Databases, Database Design, Data Storage and Querying, Database Architecture, Data Mining and Information Retrieval, Specialty Databases, Database Users and Administrators, History of Database Systems.

Entity-Relationship Model: Basic concepts, Constraints, Removing Redundant Attributes in Entity Sets, Reduction to Relational Schemas, ER-Design Issues, E-R diagram, Weak Entity Sets.

Relational Model: Structure, Database Schema, Keys, Schema Diagrams, Relational Operations.

Introduction to SQL: SQL Data Definition, Basic Structure, Additional Basic Operations, Set Operations, Null Values, Aggregate Functions, Modification of the Database. Intermediate SQL: Join Expressions, Views, Transactions, Integrity Constraints, SQL Data Types and Schemas, Authorization, Roles.

Relational-Database Design: First Normal Form, Pitfalls in Relational-Database Design, Functional Dependencies, Decompositions, Third Normal Forms, Boyce-Codd Normal Form.