CSE-303 Database Management Systems
Basic Database Concepts, Conventional file processing, Three level architecture, Communication with database systems, Database management systems, Distributed database, database machines, Database administration,
Database models: The hierarchical, Network and relational database models. The entity relationship model, E-R diagram.
Database Components, Security, Data dictionary, Transactions and recovery, Concurrent processing.
Data description and data manipulation languages, Structured query language (SQL)
Storage representation and access methods, System organization and implementation of database systems, File organizations and data structures, Query languages, query optimization,
Transaction Control, Concurrency control, Security issues evolving database systems.
Database Design, Functional dependencies decomposition to normal forms, The entity relationship model, Logic for relational database, First order logic, Relational calculus and algebra, Intelligent Database, Deductive database with natural language interface,
Distributed databases, Multimedia databases, Database Implementation, Physical representation, Query optimization, Projects using on RDMS. Specific database systems, ORACLE/SQL Server/DB2 etc.
CSE-304 Database Management Systems Lab
Practical works based on CSE-303