Features of good database design –High level Conceptual Data Models for Database Design-Entity Types,EntitySets,Attributes and Keys –Relationship Types,RelationshipSets,Roles and Structural Constraints-Weak Entity Types –ER Diagrams,Naming Conventions and Design Issues-Enhanced Entity Relationship Modeling: Subclasses,Superclasses and Inheritance- Specialization and Generalization –Constraint and Characteristics of specialization and Generalization-UML Class Diagrams

Relational Schemas –Functional Dependencies-Normal forms Based on Primary Keys-General Definitions of Second and Third Normal Forms –Boyce –Codd Normal Form – Properties of Relational Decompositions –Multivalued Dependencies and Fourth Normal forms-Views-Cursors,triggers and Stored procedures- Embedded SQL,DynamicSQL,Advanced Features of SQL

Introduction to Database Security Issues – Discretionary Access Control based on granting and Revoking privileges –Mandatory Access Control and Role-based Access control for Multilevel Security –Statistical Database security –Flow Control –Encryption and Public key infrastructures.

DBMS Standardization – Architectural models for distributed DBMS-Distributed DBMS Architecture: Client/server system-Peer-to-peer Distributed system- MDBS architecture-Global Directory Issues. Distributed Concurrency control: Taxonomy of concurrency control mechanisms-Locking based concurrency control-Deadlock management

Alternative Design Strategies-Top down Design Process-Bottom up design process –Distributed design issues-Fragmentation –Horizontal fragmentation-vertical fragmentation-Hybrid fragmentation-Allocation problem-information requirements-Allocation models