Introduction to DBMS: Introduction – data and data management – File based data management – database systems – functions of DBMS.
Components of DBMS – data dictionary – data base users – database designers – end users – system administrator – security officers – network administrators.
Database architecture and design: Introduction – database architecture – data abstraction – physical and logical data independence – data base languages – database design
E-R Modeling: Introduction - ER Models – components of ER model – ER diagram conventions – relationships. – ER diagrams.
Tables: create table – modify table – delete table - insert statement – update statement – delete statement - Select statement.
Reference Book:
1. Henry F. Korth, Abraham Silberschatz & S. Sudarshan, “Database System Concepts”, Tata McGraw-Hill, 2010. 2. Nilesh Shah, “Database Systems Using Oracle”, Second Edition, PHI, 2008
Text Book:
1. Alexis Leon, Mathews Leon, “Fundamental of Database Management System”, Tata McGraw–Hill, 2008